Category Archives: Uncategorized

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 : 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

Update the statistics to all tables in a database WITH FULLSCAN


DECLARE @SQL NVARCHAR (MAX) DECLARE C1 CURSOR FOR SELECT DISTINCT ‘UPDATE STATISTICS [dbo].[‘+o.name +’] WITH FULLSCAN ‘ FROM sys.objects AS o WITH (NOLOCK) INNER JOIN sys.indexes AS i WITH (NOLOCK) ON o.[object_id] = i.[object_id] INNER JOIN sys.stats AS s WITH … Continue reading

Posted in Uncategorized | Leave a comment