Jun 172013
 

If you have to use Profiler on your production SQL Servers – filter as much as you can, configure profiler from a remote machine and do not save the profiler trace on the same production box. Rather prefer using server-side trace. Note: Profiler is deprecated now, start using Extended Events – they are very light [Read More]

Jun 132013
 

Rebuild can certainly remove Fragmentation but if the page count is less than 1000 pages, Rebuild is not required. Related posts: Best Practice No.9 Best Practice No.5 Best Practice No.1 What is Checkpoint in SQL Server? Best Practice No.13

Jun 102013
 

Configure your anti-virus to exclude all your Database related files namely (mdf, ndf, ldf, trn, bak, log, tuf and other files) Related posts: Best Practice No.6 Best Practice No.7 Best Practice No.5 SQL Tip-3 | Don’t Shrink your Database Best Practice No.1

May 232013
 

Keep Backup and Database files on separate disk to avoid single point of failure. Related posts: Best Practice No.5 Best Practice No.3 What is Checkpoint in SQL Server? SQL Tip-3 | Don’t Shrink your Database Best Practice No.1