SET STATISTICS PROFILE ON
For example, in the above plan (zoomed out), it’s tedious to figure out where cardinality estimation has gone bad. You hover the mouse cursor over every arrow to see the numbers …
SET STATISTICS PROFILE ON Read More
SQL Server Education (by the geeks, for the geeks)