May 202013
 

Keep VLF Count in check for all your transaction log files. Too many VLFs can cause slow DB Recovery & performance Hit. Related posts: Best Practice No.6 Best Practice No.1 Best Practice No-2 Best Practice No.3 Best Practice No.4

May 102013
 

The KEEP PLAN query hint changes the recompilation thresholds for temporary tables, and makes them identical to those for permanent tables. Therefore, if changes to temporary tables are causing many recompilations, this query hint can be used. Related posts: Using Covering Index Best Practice No.1 Best Practice No.3