Category: Best Practices

When choosing service accounts, consider the principle of least privilege. No related posts.

Don’t forget to backup System Databases (Master, Model and Msdb) while configuring Backups for your SQL Server Instance. Related posts: Best Practice No.14 Best Practice No.6 Best Practice No.8 Best Practice No.10 Best Practice...

Always keep Data and Log files on separate Physical Disk. Related posts: Best Practice No.6 Best Practice No.22 Best Practice No.11 Best Practice No.5 Best Practice No.16

Avoid using SELECT * FROM <Table_Name>, try to use only the required Columns & Rows – if possible. Related posts: Best Practice No.6 Best Practice No.9 Using Covering Index Best Practice No.3 Best Practice...

Configure start-up mode of your cluster SQL Services to Manual. Related posts: Best Practice No.23 SQL Tip-2 | Make Sure the startup type of your SQL Service is Automatic* Best Practice No.13 Best Practice...

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

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

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