0
kicks
SET STATISTICS IO ON
The graphical query plans introduced in the latest SQL Server versions give you great inside info on how your query is executing. Downside: sometimes they are difficult to read and they take time to fully understand.
Enter: SET STATISTICS IO ON