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…

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...
Menu