Summary

At this point, it is beginning to become clear that the way a T-SQL query is written and submitted to the server influences how it is going to be interpreted and executed by SQL Server. Even before a single T-SQL query is written, the choice of development style (for example, using stored procedures versus ad hoc statements) can have a direct impact on the performance of the application. 

As we continue our exploration of the internals of SQL Server query processing and optimization, we will find more and more opportunities to write T-SQL queries in a way that encourages optimal query performance.