A Little About Sorts In SQL Server Query Plans

Become a member! / @erikdarlingdata If you like what you see here, you'll love my advanced performance tuning training:
training.erikd... Click here for 50% off a health check: training.erikd...

[@andreysamykin1143]

Thanks for your efforts sharing the knowledge!

[@artbart9080]

Thanks for video. It would be nice to watch video about memory grants and out of memory conditions.

[@birdasaurusrex]

This may be obvious to some given that Erik mentioned 'SELECT DISTINCT' in the video, but another place where sorts come up is 'UNION'. I have definitely seen places where people (including myself at some point) have used 'UNION' instead of 'UNION ALL' even though the individual sets of data they are selecting have no way of producing duplicate rows.

[@ErikDarlingData]

Ooh yeah, good point.

[@OhhBabyATriple]

Audio much better in this video