Welcome to my World of SQL

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…

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 …

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 J…

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