Best Practice No.37
Check Database consistency at-least once every month.
Read moreBest Practices
Best Practice No.36
Do proper capacity planning for the growth of your Transaction log file and size them accordingly – don’t leave it
Read moreBest Practice No.35
In your backup strategy avoid taking daily backups of your read-only databases, monthly full backup is more than enough.
Read moreBest Practice No.34
Rebuild only those Indexes where the fragmentation level exceeds the threshold value of 30.
Read moreBest Practice No.33
Configure a dedicated NIC (network card) card for your Backups on your busy systems.
Read moreBest Practice No.32
Always use SQL Server Configuration Manager to change Service account for any SQL Related Service.
Read moreBest Practice No.31
While referring objects in Stored Procedures, functions, views and Triggers always use Fully Qualified (Multi Part) Name of the object.
Read moreBest Practice No.30
Enable “remote admin connections” on all your SQL Servers to be able to take DAC (Dedicated Admin Connection) remotely.
Read moreBest Practice No.29
Apply Password policy on all SQL Server logins (along with password expiration if possible) to avoid any security compromise.
Read moreBest Practice No.28
Understand NOLOCK hint before using this in your transactions\applications – the data you are reading might not be consistent (Dirty
Read more