Product has been added to your cart.

04. Lab: Write a Query that’s Susceptible to Parameter Sniffing

Now, it’s your turn: using the Stack Overflow database: Write a query that’s susceptible to parameter sniffing. Try to use just one table, and NOT the Users table. Let’s mix it up. You’ll need to create at least one index to give SQL Server tough choices. Build the list of parameters that will produce wildly…

To access this incredible, amazing content, you gotta get Recorded Class Season Pass, Fundamentals of Parameter Sniffing – Live Classes + Instant Replay, 1 Year Access or Fundamentals of Parameter Sniffing – Instant Replay Recordings Only, 1 Year Access, or log in if you already shelled out the cash.

Now, it’s your turn: using the Stack Overflow database: Write a query that’s susceptible to parameter sniffing. Try to use just one table, and NOT the Users table. Let’s mix it up. You’ll need to create at least one index to give SQL Server tough choices. Build the list of parameters that will produce wildly…

To access this incredible, amazing content, you gotta get Recorded Class Season Pass, Fundamentals of Parameter Sniffing – Live Classes + Instant Replay, 1 Year Access or Fundamentals of Parameter Sniffing – Instant Replay Recordings Only, 1 Year Access, or log in if you already shelled out the cash.