Software Vendor Mistakes With SQL Server: Not Parameterizing Queries

You Won’t Stop

Continuing a bit on yesterday’s theme of parameterization, another type of mistake I see software vendors make quite a bit is not parameterizing queries at all, or only partially parameterizing them. When you do this, you harm …

A Suggestion To Make Key Lookups Less Of A Performance Problem In SQL Server

Odor Of Gas

One problem with Lookups, aside from the usual complaints, is that the optimizer has no options for when the lookup happens.

If the optimizer decides to use a nonclustered index to satisfy some part of the query, …