Category: Best Practices

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

Best Practice No.9

Provide appropriate Fill Factor while creating\rebuilding Indexes to avoid\minimize fragmentation. Related posts: Best Practice No.6 Best Practice No.3 Best Practice No.1 Best Practice No.5 Best Practice No.7

0

Best Practice No.8

Make sure Auto_Close is disabled for all Databases on your Production Servers. Related posts: Find Users with DBOwner Database role Best Practice No.1 Best Practice No.5 Best Practice No.6 Best Practice No.7

0

Best Practice No.7

Make sure you configure SQL Server to run on a NON Default port. Related posts: Best Practice No.4 Best Practice No.1 Best Practice No.5 Best Practice No.6 Best Practice No.8

0

Best Practice No.6

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