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
CPU schedulers offline What is a CPU Scheduler in SQL Server? A query that you want to execute represents a task, your work. The execution
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 of
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
What is the Delayed Durability in SQL Server? This is a dangerous feature introduced in SQL Server 2014. Also known as lazy commit, It is
What is the “Optimize for ad hoc workloads” option? When you write a query in SQL Server, the query optimizer needs to create a “Plan”
The disk is the slowest part of the server. Proper storage configuration is critical to the optimal performance and operation of SQL Server. Below are
SQL Agent Jobs without notifications SQL Server Agent permits you to run a wide variety of tasks within SQL Server. Its built-in notification system allows
It is not common to have SQL log files larger than data files. If it is, this may indicate a potential problem: A possible bad
Disable keys and constraints to improve the performance of load data is a common practice in large data warehouses and other environments with big tables.
Windows Visual Effects not optimal By default, Windows is optimized for a beautiful display, but this is not very important for a server. These visual
What’s Instant file initialization (IFI)? Instant file initialization is a Windows feature that enables your SQL Server to skip the zero-writing step and begin using the