Itzik Ben-Gan
sqlperformance.com/author/itzikbengan
Itzik Ben-Gan is a T-SQL trainer at and co-founder of Lucient. He is a Microsoft Data Platform MVP, author of many T-SQL books, and a regular speaker at SQL Server related conferences.
SQLBits 2019
Ordering woes
This session covers situations where the SQL Server query optimizer does not rely on index order and provides tips and tricks to solve those.
There are cases where you create indexes to support query elements that rely on order, but the query optimizer seems to not realize this, and ends up applying a sort. This session demonstrates a number of such situations and provides workarounds that enable the optimizer to rely on index order and this way avoid unnecessary sorting.