How to Search and Destroy Non-SARGable Queries on Your Server - Data with Bert
Sun Aug 16 2020 11:59:20 GMT+0000 (UTC)
The script below looks at cached query plans and searches them for any table or index scans. Next, it looks for scalar operators, and if it finds any it means we have ourselves a non-SARGable query.
https://bertwagner.com/2017/08/22/how-to-search-and-destroy-non-sargable-queries-on-your-server/
Comments