0

Best Practice No.16

Try not to place user data on Primary File-group. Related posts: Best Practice No.10 What do you mean by Execution Context & Context Switching? Part-1

0

Best Practice No.15

If you are using Fill Factor don’t forget to enable Pad Index. Related posts: Best Practice No.9 SQL Tip-6 | Use Covering Index to solve key lookup issues

0

Best Practice No.14

Change the recovery model of your databases to SIMPLE where you don’t need point in time recovery and don’t wish to configure Transaction log backups also (Testing Databases etc.) Related posts: Best Practice No.5...

0

Best Practice No.13

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...

0

Best Practice No.12

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...

0

Best Practice No.11

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...

0

Best Practice No.10

Keep Guest account disabled for all your User Databases. Related posts: Best Practice No.8 Best Practice No.1 Best Practice No.5 Best Practice No.6 Best Practice No.7

0

MS Webcast | Lunch Time – How to Monitor SQL Servers using Powershell – Part 1 | 26-June-2013

I’ll be delivering another webcast in Lunch Time series and this time its on How to Monitor SQL Servers using Powershell – Part 1. Join this webcast to learn how to create your own...