The hidden costs of using TOP versus TOP PERCENT clauses. Even if the results appear the same, the underlying performance can vary.
SQL in Sixty Seconds – CPU Threads and Uneven Workload
When SQL Server executes a query in parallel, CPU threads often share the workload unevenly. Some handle a significant portion of the rows, while others manage much less.
Functions and Missing Indexes – SQL in Sixty Seconds 204
In this blog post, we will discuss the relationship between Functions and Missing Indexes Hints in SQL Server. Functions can reduce query performance.
3 ChatGPT Tricks to Tune SQL Server – SQL in Sixty Seconds 203
Here are 3 ChatGPT tricks to tune SQL Server: quick, practical methods to optimize your queries, with a SQL in Sixty Seconds video.
Function in the WHERE Clause – SQL in Sixty Seconds 201
Few even asked me to build a video on this topic. Hence, I decided to make a Function in the WHERE Clause – SQL in Sixty Seconds 201.
Parameter Sensitive Plan optimization in SQL Server 2022 – SQL in Sixty Seconds #200
SQL Server 2022 introduces Parameter Sensitive Plan Optimization (PSPO), a feature that revolutionizes the performance of parameterized queries.
Swap Columns – SQL in Sixty Seconds #199
Today we will see a quick video on how to swap columns in SQL Server. It is a widespread request. We will learn that in this video.