The clustered index of a row is included in every row of the non-clustered index.

SQL developers should know that. The DBAs, too.

#sqlserver #performance #didntknowthat #needmoretimetoinvestigate