4.4 Tuning usp_SearchPostsByLocation

This one is gonna look familiar – it’s the stored procedure that we’ve been struggling with the whole week. In the first ten minutes, I walk into it cold as if I haven’t been seeing it all week, grabbing a set of parameters that produce different plans. Then, I spend 30 minutes working on: Improving…

This one is gonna look familiar – it’s the stored procedure that we’ve been struggling with the whole week. In the first ten minutes, I walk into it cold as if I haven’t been seeing it all week, grabbing a set of parameters that produce different plans. Then, I spend 30 minutes working on: Improving...