Welcome to my World of SQL

Here is a quick checklist for your SQL Server Migration. 1. Build your New Server, Install SQL Server and required updates and keep the server ready for migration 2. Stop Application Service(s) a…

Note that DBCC DBREINDEX uses one big transaction, killing the operation in the middle would rollback the entire transaction.  It would not help you reduce log space consumption if you restart the in…

This script is useful for security audits (helping you gather information about failed login attempts), and for checking recent activity by a particular login (before you delete a login, for example)…

This will very useful, if you have implemented the partitioning functionality .   SELECT OBJECT_NAME(a.object_id) AS object_name ,a.index_id ,b.name ,b.type_desc ,a…

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

It is important to make sure you set the Max server memory setting for SQL Server 2005/2008 to something besides the default setting (which allows SQL Server to use as much memory as it wants, subjec…