SQL Server 2022 introduces a powerful new feature called Degree of Parallelism (DOP) feedback as part of the Intelligent Query Processing (IQP).
SQL SERVER – Locking, Blocking, and Deadlocking: Differences, Similarities, and Best Practices
Understanding SQL Server Deadlocks: A Beginner’s Guide, and after reading it, lots of people have asked me the difference between Locking, Blocking, and Deadlocking.
Understanding SQL Server Deadlocks: A Beginner’s Guide
Welcome to this introductory blog post on SQL Server Deadlocks. In this post, we’ll help you understand what deadlocks are, and how they occur.
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.
Heap or Clustered Index: When a Heap Table Is the Right Choice
The heap or clustered index choice changes the reads of every scan. The demos measure forwarded records in a heap, a range query on both kinds of table, and the size of a nonclustered index on a wide key, and says when a heap is the right choice.
Configuring Parallel Index Operations in SQL Server
MAXDOP limits supported parallel index operations without changing unrelated instance settings. I choose the ceiling from the maintenance workload.
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.







