Using SQL Server functions in the WHERE clause of your queries can significantly impact performance. Let us explore that in this blog post.
Running Distinct Counts: Working Around COUNT(DISTINCT) OVER
Your report wants unique customers so far, and SQL Server refuses COUNT(DISTINCT) over a window. Flag each first appearance and add up the flags instead.
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).
Exact Vector Search Cost: Filtering Before VECTOR_DISTANCE
Measure exact vector search with VECTOR_DISTANCE, reduce candidates through indexed filters, and compare plans and measured IO.
Query Store Wait Stats: Why a Query Was Slow, Not Just That It Was
Read Query Store wait stats by query, plan, interval, and category, then compare matched windows with execution counts and capture coverage.
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.