naga.rohitkumar (11/26/2012)
HI can any one say what is the use of these1 SET SHOWPLAN_ALL ON
2 SET SHOWPLAN_ALL OFF
3 SET STATISTICS PROFILE ON
4 SET STATISTICS PROFILE OFF
Rohit , this is a kind of home work which should have been done by you . 🙂
any ways see the links
http://msdn.microsoft.com/en-us/library/aa259207(v=sql.80).aspx
http://msdn.microsoft.com/en-us/library/aa259203(v=sql.80).aspx
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)