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
[Case study] Preventing future performance problem. How did we do it?
This is an excellent example of what you can get by teaming up with our part-time SQL DBA Service provider. Our daily checks include many
[Case study] Stored procedure is now running 181 times faster. How did we do it?
Here is another significant improvement. Problem summary Slow procedure killing SQL Server performance. The client was experiencing severe issues with the application stability. What we
[Case study] SQL Performance Tuning using indexes
Problem Summary The client is experiencing issues with SQL server performance. Two stored procedures that are run hundreds of times per hour were taking a
[Case study] SQL query hint removal makes TSQL run five times faster
Here what can be done when you have one of our DBA plans. The procedure below was extracted from a stored procedure that was found
[Case study] Performance tuning a slow report. How did we do it?
Problem summary A report was taking a long time to complete. It was also causing deadlocks during the execution. What was done We started monitoring
[Case Study] Fixing SQL Server Deadlocks by tuning SQL performance
Problem Summary Two procedures were involved in 80% of deadlocks related to a third-party application. Deadlocks are a common problem handled by SQL Server automatically.
[Best Practices] SQL Server Installation
SQL Server installation does not often repeat, especially if you are using on-premises servers. In this article, you will see a few settings that are
Microsoft SQL Server Management Studio (SSMS)
What is SSMS? SQL Server Management Studio (SSMS) is an integrated environment for managing any MS SQL Server infrastructure, from on-promise to an Azure SQL
Database Engine Tuning Advisor (DTA) in Microsoft SQL Server
What is a database tuning advisor (DTA)? Changing database design to a proper one makes it to perform better. One of the performance-critical areas of
Choosing the right encryption feature for SQL Server
Encryption is the process of encoding information to protect data from unauthorized access in different scenarios. There are many different encryption technologies offered by SQL Server and
SQL Performance Tuning by Tuning Indexes – 600% speed improvement on disk reads! How did we do it?
SQL Server Index Tuning Example Speed improved by 600% Some SQL Server Consulting clients chose to tune databases periodically. Once we tune, I noticed sometimes
SQL Performance Tuning – Disk reads are now 35 times faster! How did we do it?
Some customers care about SQL Performance Tuning so much that they use our database administrators for continuous Microsoft SQL Server performance tuning. This one of