Time to Go to Class
#sqlserver #sql #dba #database #azure #microsoft #tips #brentozar #pollgab #computerscience #computerconsulting #database #databaseadministrator #careergoals #spanishsubtitles #Postgres #Postgressql
00:23 Andrea Hardesty: Do you have any recommendations for reproducing parameter sniffing issues? I have a copy of a production DB. I want @param=222 to use the plan compiled with @param=111 like it did in production. In my test it compiles a new plan for @param=222 every time. Suggestions?
Time to Go to Class