SQLChamp

Best Practice No.30

Enable “remote admin connections” on all your SQL Servers to be able to take DAC (Dedicated Admin Connection) remotely.

Trace flags are used to temporarily set specific server characteristics or to switch off a particular behavior. There are many

Apply Password policy on all SQL Server logins (along with password expiration if possible) to avoid any security compromise.

Understand NOLOCK hint before using this in your transactions\applications – the data you are reading might not be consistent (Dirty

Always change the Page_Verify Database Option to Checksum after you migrate it to SQL Server 2005 or higher. Checksum is

Do you have Key Lookup problem? Key lookup taking most of the query time. then probably this is the best

A Non Clustered Index which contains all columns which are referred by a Query (in Select, Where or Join) is

Make sure Auto_Shrink is disabled for all Databases on your Production Servers.

Keep your TempDB Files & all other database files on separate disks.

In my first SQL Tip Don’t forget to recycle your SQLServer ErrorLog I listed some common problems you may face