Author Archives: Ishtiaq Ahmed

SQL Server 2016 release date is June 1


Microsoft SQL team announced today morning at 9:00 am EST that the the release date for SQL Server 2016 is June 1st. Important points to note here is the following features are Enterprise only. (1) Enterprise data management (Master Data Services, … Continue reading

Posted in Uncategorized | Leave a comment

When was the last time DBCC finished successfully


/* When was the last time DBCC finished successfully? DBCC CHECKDB checks databases for corruption. You won’t know Script is from http://sqlserverpedia.com/wiki/Last_clean_DBCC_CHECKDB_date To get sample corrupt databases – http://sqlskills.com/pastConferences.asp */ CREATE TABLE #temp ( ParentObject VARCHAR(255) , [Object] VARCHAR(255) , … Continue reading

Posted in Uncategorized | Leave a comment

Largest SQL Server and SQL Azure projects in the world


How do the SQL Server scale; do they scale up or scale out? How are High Availabilty and Disaster Recovery architected? Are there any common techniques that bring the largest gain? Largest on premises SQL Server and SQL Azure projects … Continue reading

Posted in Uncategorized | Leave a comment

Query time out


Below are the questions to ask and work on when we have Query time out issues what kind of crime is this ? Query time out is client side time out. Is it my SQL server setting EXEC SP_CONFIGURE ‘query … Continue reading

Posted in Uncategorized | Leave a comment

Replication-Distribution Agent is already running


Very rarely should you acquire the following error, which can be viewed when looking at the job activity monitor failure history: “Agent message code 21036. Another distribution agent for the subscription(s) is running or the server is working on a … Continue reading

Posted in Replication | Leave a comment

Replication : Can’t find stored procedure


Occasionally, an error will display such as one of the following: “Could not find stored procedure ‘sp_MSdel_ARTICLE_msrepl_ccsr’“ “Could not find stored procedure ‘sp_MSins_ARTICLE_msrepl_ccsl’“ “Could not find stored procedure ‘sp_MSupd_ARTICLE_msrepl_ccsl’“ It is unclear how the stored procedure gets dropped from the … Continue reading

Posted in Uncategorized | Leave a comment

Backup Duration FInd


The following query gives the recent backup duration by user, Database name, server name, Backup started , Backup Finished and Total Time. DECLARE @dbname sysname SET @dbname = NULL –set this to be whatever dbname you want SELECT bup.user_name AS … Continue reading

Posted in Uncategorized | Leave a comment