Category: Performance Item: Windows task scheduler What is the windows task scheduler? It is a Windows component that can schedule programs and programs to run at

Category: Reliability Item: Dangerous build of SQL Server Why should you care about your build version of SQL Server? There are known bugs and threats in specific

Category: Reliability Item: OS Updates settings Why should you care about them? Windows updates are set to a non-optimal setting. Updates can start downloading at

Category: Performance Item: SQL Agent jobs starting simultaneously. Why should you care about them? Multiple SQL Server Agent jobs are configured to start simultaneously, which will not

Category: Reliability Item: User tables in sys DBs Why should you care about them? User datatables  should not be  in the system databases (master, msdb). In case

Category: Performance Item: Wait statistics What are SQL Server wait statistics? They are data about all the waits encountered by SQL Server threads at the instance level.

Category: Performance Item: Active tables without clustered IX What is a Heap in SQL Server table? A table without a clustered index is called Heap. It consists

Category: Reliability Item: SQL Server memory dumps What are the SQL Server dump files? They are memory dumps files generated when SQL hits a bug, or something

Category: Performance Item: CPU schedulers offline What is a CPU Scheduler in SQL Server? A query that you want to execute represents a task, your work. The

What is the database compatibility level? A compatibility level is an option associated with each database. It controls some database behaviors to be compatible with a particular version

What is the CLR integration on SQL Server? Included in SQL Server 2005, the CLR is the heart of the Microsoft .NET framework. The common

Did somebody drop a database in production instead of development? Did you run the wrong DELETE statement? Let’s follow these best practices and recommendations for