03. Mo Choices, Mo Problems

We’ll talk through the WHERE, FROM, SELECT, JOIN, GROUP BY, and ORDER BY components to understand how they affect parameter sniffing. Then, we’ll layer on more complexity to our parameter sniffing problem by first adding an index (which backfires catastrophically), and then adding more parameters (making SQL Server’s choices even tougher.) Demo Script Transact-SQL /*…