Parameters In TOP Are Sniffed, Too

Thank You For Your Business

In yesterday’s post, we looked at how row goals affected performance when data matching our join and where clauses didn’t exist.

Today we’re going to look at something similar, and perhaps a workaround to avoid the same issues.

Here’s our index setup:

Now we’re gonna wrap our query in a stored procedure.

Video Killed MTV

You know what? I don’t wanna write all this stuff. Let’s do a video.

Thanks for reading!

3 thoughts on “Parameters In TOP Are Sniffed, Too”

Leave a Reply

Your email address will not be published. Required fields are marked *