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 to troubleshoot a slow running query using wait stats in the MS SQL server?
SQL Server Performance Tuning is a vast topic. Tuning can can get complicated and struggle is real. Fixing a slow query and solving performance problems
PROS and CONS – AWS RDS SQL Server vs. Azure SQL Database
Amazon AWS and Microsoft Azure are great options for deploying MS SQL Server databases. Some use both clouds to get each cloud’s unique feature set.
7 T-SQL Development Tips for Faster Queries
Today I will let know some essential techniques that never change to make your queries run faster in the Microsoft SQL server! It is excellent
Top 10 SQL Server Performance Tuning Mistakes
It’s not enough that your code is readable: it must perform well too. In this post, I will show a list of common antipatterns in
Azure SQL: How to choose the right service database
What is Azure SQL? In the recent past, Microsoft introduced Azure SQL, bringing all the SQL Server products in one suite. Microsoft is grouping all
[Case Study] We Tuned SQL Server Performance and now TSQL runs 589 times faster(not a typo)! How did we do it?
Case study #16 Here is another recent SQL Server performance tuning report. The stored procedure below was one of the most called on the client’s
[Case Study] We did SQL Server Performance Tuning and now its 3,187% faster(not a typo)! How did we do it?
Real sample #15 Here is another recent SQL Server performance tuning report. Improvements achieved CPU from 125 to 18 Reads from 21,737 to 18,411 Duration
[case study] SQL performance tuning report and how we made TSQL run 13 times faster! How did we do it?
Today I am sharing another MS SQL Performance tuning report from recent tuning. Improvements after Red9 SQL Server tuning After making a couple of small
SQL Server objects created with SET Options
Objects created with SET Options What are the set options? SQL Server backward compatibility SET options allow legacy T-SQL code to run on newer SQL
Are you using stored procedures with recompile option?
Stored Procedures (SPs) with RECOMPILE option What is the RECOMPILE option? The compilation is the process when a query execution plan of a stored procedure
Page life expectancy & why should you care?
What is the SQL Page Life Expectancy (PLE)? PLE is the expected time (in seconds) that a data file page read into the buffer pool
Wasting CPU for implicit conversions in SQL Server
What is SQL Server implicit conversion? It occurs when SQL Server needs to convert the value of variables or columns to another data type for