07. How to React to Parameter Sniffing Emergencies
Remember the things we discussed in the last module? Restarting the service, rebuilding indexes, updating stats, and freeing the entire plan cache? Yeah, don’t do that. You solve the parameter sniffing emergency forone query, but youcause a parameter sniffing emergency for the rest of ’em – because now all the other queries are suddenly getting […]