Get all SQL Statements with "table scan" in cached query plan

This Transact-SQL statements filters the cached query plans for existing table scan operators and returns the statement and query statistics. An additional filter is set on the attribute "EstimateRows * @AvgRowSize" = "Estimate size" to filter out scans on small tables.

4.1 Star
5,494 times
Add to favorites
E-mail Twitter Digg Facebook
Sign in to ask a question

Be the first to ask a question.