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 – Stored procedure 181x faster

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 – Tuning a slow report

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 – Dealing with deadlocks

Problem Summary Two procedures were involved in 80% of deadlocks related to a third-party app. Deadlocks are a common problem handled by SQL Server automatically.