You know the one: that stored procedure with fifty different parameters, all optional, and users want a perfect execution plan no matter what they pass in. It’s a parameter sniffing nightmare, and you need easy solutions. Brent will start with a bad design, then gradually try different ways of making it go faster, finishing up...
