Category: Best Practices

0

Best Practice No.37

Check Database consistency at-least once every month. Related posts: Best Practice No.5 Best Practice No.6 Best Practice No.22 Best Practice No.11 Best Practice No.25

0

Best Practice No.36

Do proper capacity planning for the growth of your Transaction log file and size them accordingly – don’t leave it to Auto-grow on default setting to avoid performance hit. Transaction Log files cannot take...

0

Best Practice No.35

In your backup strategy avoid taking daily backups of your read-only databases, monthly full backup is more than enough. Related posts: Best Practice No.20 Best Practice No.14 Best Practice No.6 Best Practice No.33 Best...

0

Best Practice No.34

Rebuild only those Indexes where the fragmentation level exceeds the threshold value of 30. Related posts: Best Practice No.12 Best Practice No.9

0

Best Practice No.33

Configure a dedicated NIC (network card) card for your Backups on your busy systems. Related posts: Best Practice No.14 Best Practice No.4 Best Practice No.20 Best Practice No.30 Best Practice No.7

0

Best Practice No.32

Always use SQL Server Configuration Manager to change Service account for any SQL Related Service. Related posts: Error while opening SQL Server Configuration Manager – Fixed SQL Tip-2 | Make Sure the startup type...

0

Best Practice No.31

While referring objects in Stored Procedures, functions, views and Triggers always use Fully Qualified (Multi Part) Name of the object. Related posts: Best Practice No.4 SQL Server Management Objects (SMO)

0

Best Practice No.30

Enable “remote admin connections” on all your SQL Servers to be able to take DAC (Dedicated Admin Connection) remotely. Related posts: Best Practice No.13 Best Practice No.15 Best Practice No.24 Best Practice No.8 Best...