Aug 152013
 

Enable “remote admin connections” on all your SQL Servers to be able to take DAC (Dedicated Admin Connection) remotely. Related posts: Best Practice No.13 Best Practice No.15 Best Practice No.24 Best Practice No.8 Best Practice No.26

Aug 142013
 
SQL Tip-7 | Different ways to enable a Trace Flag

Trace flags are used to temporarily set specific server characteristics or to switch off a particular behavior. There are many documented and undocumented trace flags. For example Trace Flag 1222 that can be used to get Deadlock Graph. In Trace Flag 1222 you get a detailed information about all the processes running and participating in [Read More]

Aug 122013
 

Apply Password policy on all SQL Server logins (along with password expiration if possible) to avoid any security compromise. Related posts: Best Practice No.18 Best Practice No.6 Best Practice No.9 Best Practice No.3 Best Practice No.27

Aug 052013
 

Always change the Page_Verify Database Option to Checksum after you migrate it to SQL Server 2005 or higher. Checksum is default for databases created on SQL Server 2005+. Related posts: Best Practice No.14 Where are my system databases? Best Practice No.20 Best Practice No.7 SQL Server Management Objects (SMO)

Aug 042013
 

Do you have Key Lookup problem? Key lookup taking most of the query time. then probably this is the best time to know more about covering indexes. Covering Index can solve all key lookup problems. A Non Clustered Index which contains all columns which are referred by a Query (in Select, Where or Join) is [Read More]

Aug 042013
 
Using Covering Index

A Non Clustered Index which contains all columns which are referred by a Query (in Select, Where or Join) is called Covering Index. In other words When all columns which are required to satisfy the query are included in a non-clustered Index to avoid extra key lookup that index is known as Covering index. This [Read More]