August 23, 2010 at 9:02 am
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.
August 23, 2010 at 9:48 am
ALI-408105 (8/23/2010)
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.
Origin of the query makes no difference - parse, execute and fetch.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.August 23, 2010 at 12:10 pm
I don't believe I've ever seen a flowchart of what happens. Please let us know if you run across one.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 23, 2010 at 12:23 pm
Check out this white paper on Query Recompilation... it might answer some of what you're looking for:
http://technet.microsoft.com/en-us/library/cc966425.aspx
Note about halfway thru the paper there is a flowchart that illustrates what happens behind the scenes when a query is submitted.
--Brad
August 23, 2010 at 12:33 pm
Is this what you were looking for?
http://www.pinaldave.com/best-sql-server-download.cfm?Download=Logical-Query-Processing-Poster
Thanks & Regards,
Nakul Vachhrajani.
http://nakulvachhrajani.com
Follow me on
Twitter: @sqltwins
August 23, 2010 at 12:38 pm
This is very good poster to have. I think this is what happens after a query plan is created. I am looking for sql engine components that are involved in creating query plan. I got lots of text info thoug. I am looking for nice little image/slide to include in my presentation on SQL SERVER PERFORAMNCE.
August 23, 2010 at 1:59 pm
Can I post image from my local PC?
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply