Using SQL Server functions in the WHERE clause of your queries can significantly impact performance. Let us explore that in this blog post.
SQL Server Deadlocks – Interview Q and A
Earlier this week, I wrote a few blog posts on SQL Server Deadlocks. Lots of people asked me if I could convert them into Interview Questions and Answers
50 Minutes vs. 4 Hours for Database Performance Health Check
the On-Demand (50 Minutes) consultation and the Comprehensive Database Performance Health Check (4 Hours).
SQL Server 2022 – Thread Management for Performance Improvement
I had a great discussion about Thread Management for Performance Improvement with my client, who recently hired me for Comprehensive Database Performance Health Check.
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.
SQL SERVER 2022 – Parameter Sensitive Plan Optimization (PSPO)
SQL Server 2022 introduces an exciting new feature called Parameter Sensitive Plan Optimization (PSPO), which aims to improve the performance.
Find Database File Latency – SQL in Sixty Seconds #198
Lots of people asked me to create a video on my earlier blog post SQL SERVER – Script to List Database File Latency. Here is the video.