Домашнее задание
Оптимизируем запрос
Используем DMV, хинты и все прочее для сложных случаев

Ссылки:
https://www.brentozar.com/archive/2013/10/index-hints-helpful-or-harmful/
https://www.eversql.com/
https://blog.sqlauthority.com/2010/03/15/sql-server-maxdop-settings-to-limit-query-to-run-on-specific-cpu/
https://www.mssqltips.com/sqlservertip/2475/sql-server-queries-with-hints/
https://blog.sqlauthority.com/2009/11/19/sql-server-understanding-table-hints-with-examples/
https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2005/ms190727(v%3dsql.90)
http://www.mssqlgirl.com/paging-function-performance-in-sql-server-2012.html
https://sqlperformance.com/2015/01/t-sql-queries/pagination-with-offset-fetch
https://docs.microsoft.com/en-us/sql/t-sql/queries/hints-transact-sql-query?view=sql-server-2017
https://statisticsparser.com/