Guru's Guide to SQL Server Architecture and Internals, The

Chapter 12. Query Processor

I believe in the equality of man; and I believe that religious duties consist in doing justice, loving mercy and endeavoring to make our fellow creatures happy.

—Thomas Paine^[1]

^[1] Paine, Thomas. The Age of Reason, ed. Philip S. Foner. New York: Citadel Press, 1974, p. 50.

Query processing and performance is so important to optimal SQL Server usage that I've included a chapter on it in each of my SQL Server books. In this book, I'll update the coverage from my last book, The Guru's Guide to SQL Server Stored Procedures, XML, and HTML, and continue the discussion of query optimization internals begun in that book. While providing a boatload of individual performance tips would certainly have some short-term benefits, ...