理解SQL Server是如何执行查询的---Joe-T :mvp

http://www.cnblogs.com/Joe-T/

http://rusanu.com/2013/08/01/understanding-how-sql-server-executes-a-query/