Ññûëêè:
https://www.sqlshack.com/query-optimization-techniques-in-sql-server-parameter-sniffing/
https://www.mssqltips.com/sqlservertip/2734/what-are-the-sql-server-wasys-statistics/
https://www.mssqltips.com/sqlservertip/3257/different-approaches-to-correct-sql-server-parameter-sniffing/
https://www.mssqltips.com/sqlservertip/2766/sql-server-auto-update-and-auto-create-statistics-options/
https://www.sqlskills.com/blogs/kimberly/plan-cache-and-optimizing-for-adhoc-workloads/
https://club.directum.ru/post/1125
http://www.queryprocessor.ru/fast-in-ssms-slow-in-app-part1/