HI can any one say what is the use of these in detail

Question

HI can any one say what is the use of these in detail

naga.rohitkumar

SSCertifiable

Points: 5738
More actions
November 26, 2012 at 2:51 am

#149559

HI can any one say what is the use of these
1 SET SHOWPLAN_ALL ON
2 SET SHOWPLAN_ALL OFF
3 SET STATISTICS PROFILE ON
4 SET STATISTICS PROFILE OFF
Thanks
Naga.Rohitkumar

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Bhuvnesh SSC Guru Points: 59351 More actions · Answer 1

naga.rohitkumar (11/26/2012)
HI can any one say what is the use of these
1 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;-)

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 2

Google down?

http://www.google.com/search?q=SET+SHOWPLAN_ALL

http://www.google.com/search?q=SET+STATISTICS+PROFILE

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

Bhuvnesh (11/26/2012)
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

Those are for SQL 2000.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

naga.rohitkumar SSCertifiable Points: 5738 More actions · Answer 4

i done this in help---index in ssms

but i want the simple meaning in common words

Thanks
Naga.Rohitkumar