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
How many CPUs are your SQL Server able to use?
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
Why should you care about the database compatibility level in SQL Server?
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
Why should you care about CLR integration in SQL Server?
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
Keep SQL Server backups safe: Best Practices
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
Improve your SQL Server transaction log performance using Delayed Durability
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
Increase SQL performance by enabling “Optimize for ad-hoc workloads” option
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”
Disk storage SQL Server and SQL Performance: Best Practices
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
Keep your jobs safe using SQL Agent notifications
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
SQL Server log file too big
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
Untrusted foreign keys and constraints can degrade your SQL Server performance
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.
Disabling Windows “Visual Effects” to boost performance
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
Improve SQL Server performance by enabling Instant File Initialization
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