October 12, 2010 at 5:41 am
Hi,
what is the query execution process?i.e, when we write the query and press f5 what internally happens. will it be different in versions 7.0/2000/2005/2008
thanks,
🙂
October 12, 2010 at 5:48 am
The answer to that could fill a book. I saw Conor Cunningham at SQLBits earlier in the year - his presentation was a very good overview:
http://sqlbits.com/Speakers/Conor_Cunningham/Default.aspx
To answer the second part of the question, yes 🙂
October 12, 2010 at 6:36 am
In regards to the question, it does fill books. I'd take a look at the first two chapters of Itzik Ben-Gan's book, Inside T-SQL Querying. It's a good overview of how things are resolved. For drill down, you'd need to hit other books such as Bren Ozar's SQL Internals, or Kalen Delaney's Inside SQL Server. It's a huge topic.
Was there something in particular you were curious about?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply