Press "Enter" to skip to content

Avoding Blocking via Effective Indexing

Andy Brownsword removes a blocker:

Blocking in SQL Server will reduce throughput. Excessive blocking can be cause bottlenecks on our environments so helping to mitigate it. Here we’re going back to basics to look at how it happens and how having effective indexes can reduce it.

The word “effective” is the critical one there.