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. 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 database performance problems quickly. You can also get a quick, low cost health check with no phone time 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.