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
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
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.
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
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
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
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
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
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
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