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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 difference

Author  Topic 

AAAV
Posting Yak Master

152 Posts

Posted - 2010-03-23 : 16:37:51
what is the difference between
set showplan_xml on
and
set statistics xml on

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-03-23 : 18:20:04
showplan is without executing
http://www.google.de/#hl=de&q=sql+server+set+showplan_xml+on+&meta=&aq=&aqi=&aql=&oq=sql+server+set+showplan_xml+on+&gs_rfai=&fp=b8186e96374faff8

http://www.google.de/#hl=de&source=hp&q=sql+server+set+statistics+xml+on&meta=&aq=f&aqi=&aql=&oq=&gs_rfai=&fp=b8186e96374faff8


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page
   

- Advertisement -