How To Fix Performance Problems With Sorts Without Changing Indexes (In SQL Server)
Going Further
If this is the kind of SQL Server stuff you love learning about, you’ll love my training. Blog readers get 25% off the Everything Bundle — over 100 hours of performance tuning content. Need hands-on help? I offer consulting engagements from targeted investigations to ongoing retainers. Want a quick sanity check before committing to a full engagement? Schedule a call — no commitment required.
Hi Erik
Thank for your great tips, everyday I am learning something new.
One question, when you re-write the query to use CROSS APPLY do you have also WHERE condition Reputation>=10000 as it was in the first query? Does it make difference? Thanks
Both queries should be the same, but it doesn’t ultimately make a difference for what I’m trying to show here, which is how using cross apply lets you split one big sort into many little sorts.
Great video Erik. I’m forwarding the link to our Dev team. The bit of advice on using CROSS APPLY : genius.