Mr. Duster
Thanks for watching!
Going Further
If this is the kind of SQL Server stuff you love learning about, you’ll love my training. I’m offering a 75% discount to my blog readers if you click from here. I’m also available for consulting if you just don’t have time for that and need to solve performance problems quickly.
Great post Erik! We use this trick, often it’s really effective! Sometimes it also runs loads faster because when we do this we also remove the ORDER BY when we do the SELECT INTO.
This is exactly the same trick I came up with for my developers two weeks ago. It does really help!