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

0

Best Practice No.5

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

0

Best Practice No.4

Use Set NOCOUNT ON for all Batches, Stored Procedures and Triggers to reduce Network traffic for SQL Server. Related posts: Best Practice No.1 Best Practice No-2 Best Practice No.3 Best Practice No.5 Best Practice...

0

Best Practice No.3

Grant Granular access whenever possible to avoid providing elevated access. Related posts: Best Practice No.1 Best Practice No-2

0

Best Practice No-2

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