New from Brent Ozar on My Favorite Query Hints.
One of my favorite uses for dynamic SQL is to use them to inject query hints. Let’s say you’ve got a stored procedure with a bunch of parameters, including a @StartDate and @EndDate date range. And let’s say people usually…