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.
Performance Tuning Mistakes in SQL Server: 11 Habits to Fix
Performance tuning mistakes are habits, and each one has a check. Eleven sit in one table, and five are measured on a demo database: a missing index, stale statistics, a row by row loop, a giant delete and a type that cannot be indexed.
Indexing for Delete – SQL in Sixty Seconds #197
Today, we will see another interesting topic where the index affects the delete statement. Let us start watching the video Indexing for Delete.
Remove Key Lookup – SQL in Sixty Seconds #194
Today, we are going to see one more trick from the book – Remove Key Lookup and improve the performance of queries.
One Default Row per Customer With a Filtered Unique Index
Two browser tabs, two default addresses. Here is how a filtered unique index keeps the rule in the database and how to switch defaults safely.