Showing posts from May, 2011

Minimally Logged Inserts in sql server 2008

This is another great feature that was introduced in sql server 2008. This is one of the enhanced features of ‘SELECT INTO ‘ statements. All you need to do is to make sure that the following conditio…

Parameter Sniffing

When a stored procedure is first executed SQL Server looks at the input parameters and uses this as guidance to build the query plan. This is known as "parameter sniffing". This is good as …

find the tables having composite clustered index

script to find the tables having composite clustered index ; WITH cte AS ( SELECT OBJECT_NAME(i.object_id) NAME, type_desc, i.index_id ,c.name columnName ,p. rows FROM sys.indexes i INNER …

Historic information – sql backups

Need to find out the historic information of backups , try this script   SELECT CONVERT ( CHAR (100), SERVERPROPERTY(' Servername ')) AS Server, msdb.dbo.backupset.database_nam…
Subscribe Our Newsletter