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
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” of
The disk is the slowest part of the computer. Proper configuration storage systems are critical to the optimal performance and operation of SQL Server. Below
Category: Reliability Item: SQL Agent Jobs without notifications SQL Server Agent permits you to run a wide variety of tasks within SQL Server. Its built-in
It is not common to have files larger than data files. Usually, transaction logs have 10-60% of the size of the data files. This may
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.
Category: Performance Item: Windows visual Effects not optimal By default, Windows is optimized for a beautiful display, but this is not very important for a
Category: Performance Item: Instant File Initialization access right What’s Instant file initialization (IFI)? Instant file initialization is a Windows feature that enables your SQL Server to
Category: Reliability Item: Full Recovery Mode without backup logs Why should you care about it? If you are using a database is in Full Recovery Model or
Why should you care about SQL Server query hints? Hints in SQL queries is like a double-edged sword. While you might find a better query
What is Dynamic management views (DMVs)? Introduced within SQL Server 2005, Dynamic management views (DMVs) are significant features of SQL Server. There are several DMVs
The security model offered by Microsoft SQL Server is highly configurable and very robust when all security best practices are followed. Why should you care