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
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
You may increase your SQL performance enabling optimize for ad hoc workloads
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
Best practices for disk storage on SQL Server
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
Keep your jobs safe using SQL Agent notifications
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
Is your SQL Server database transaction log too large?
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
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
Improve SQL Server performance enabling Instant File Initialization
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
Never use the full recovery model without a backup
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
Be careful with queries forcing index, order, and join hints
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
How to find slow SQL queries using DMVs in SQL Server?
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
Why should you care about users with elevated permissions in SQL Server?
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