Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
safderalimd
Starting Member
32 Posts |
 Posted - 2010-08-23 : 10:58:25
|
| I am looking for one page image to show what happens when a query is submitted. Showing the difference between dynamic sql and stored proc will be a plus.I didnt find any related images in google search. I will appreciate any help I can get from here. |
|
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
Posted - 2010-08-23 : 11:20:51
|
| Looking at the execution plan is a good place to start.JimEveryday I learn something that somebody else already knew |
 |
|
|
safderalimd
Starting Member
32 Posts |
Posted - 2010-08-23 : 11:33:14
|
| I am looking for steps/process/procedures involved at sql engine level. Process involved at relational and storage engine. What does SQL server do with your query bfore spitting out the results?. |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-08-23 : 16:07:07
|
| Parse, optimise, execute.Try Itzik Ben Gan's book, Inside SQL Server 2005: T-SQL querying. It has an entire chapter on this.--Gail ShawSQL Server MVP |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2010-08-23 : 16:28:21
|
| There's also:http://sqlblog.com/blogs/paul_white/archive/tags/Query+Optimiser/default.aspx |
|
|
|
|
|
|
What happens when a query is submitted?