The Red9 Blog
Get our new tips before anyone else. Enter your email below to join our private list!
Most Popular Red9 Posts
Latest From Red9
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