December 13, 2011 at 7:20 am
Unintended cartesian product is likely culprit here. You need to catch it while it is running however. sp_whoisactive can show you the currently executing query plan and statements as well as tempdb utilization.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
December 13, 2011 at 9:04 am
sp_whoisactive == ?
Does not seems to be familiar procedure.
can anybody post the code for this procedure.
December 13, 2011 at 9:07 am
chetanr.jain (12/13/2011)
sp_whoisactive == ?Does not seems to be familiar procedure.
can anybody post the code for this procedure.
Damn google, always down when you need it! 😉
December 13, 2011 at 9:08 am
chetanr.jain (12/13/2011)
sp_whoisactive == ?Does not seems to be familiar procedure.
can anybody post the code for this procedure.
Just a TYPO...
sp_who [ [ @loginame = ] 'login' | session ID | 'ACTIVE' ]
December 13, 2011 at 9:10 am
Ninja's_RGR'us (12/13/2011)
chetanr.jain (12/13/2011)
sp_whoisactive == ?Does not seems to be familiar procedure.
can anybody post the code for this procedure.
Damn google, always down when you need it! 😉
damn... There is a SP with this name :hehe:
December 13, 2011 at 9:14 am
Dev (12/13/2011)
Ninja's_RGR'us (12/13/2011)
chetanr.jain (12/13/2011)
sp_whoisactive == ?Does not seems to be familiar procedure.
can anybody post the code for this procedure.
Damn google, always down when you need it! 😉
damn... There is a SP with this name :hehe:
Hell of a lot better than anything you can do with sp_who<n>
December 13, 2011 at 12:55 pm
Dev (12/13/2011)
chetanr.jain (12/13/2011)
sp_whoisactive == ?Does not seems to be familiar procedure.
can anybody post the code for this procedure.
Just a TYPO...
sp_who [ [ @loginame = ] 'login' | session ID | 'ACTIVE' ]
That would be one HELL of a typo! 8 extra characters that actually spell out 2 appropriate words!?! 😎
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
December 13, 2011 at 5:03 pm
TheSQLGuru (12/13/2011)
Dev (12/13/2011)
chetanr.jain (12/13/2011)
sp_whoisactive == ?Does not seems to be familiar procedure.
can anybody post the code for this procedure.
Just a TYPO...
sp_who [ [ @loginame = ] 'login' | session ID | 'ACTIVE' ]That would be one HELL of a typo! 8 extra characters that actually spell out 2 appropriate words!?! 😎
Go easy on the kid <new born>. He's not an old(ish) fart like the 2 of us. :hehe:
December 14, 2011 at 12:53 am
Ninja's_RGR'us (12/13/2011)
TheSQLGuru (12/13/2011)
...That would be one HELL of a typo! 8 extra characters that actually spell out 2 appropriate words!?! 😎
Go easy on the kid <new born>. He's not an old(ish) fart like the 2 of us. :hehe:
100% agree to Remi (first time :-P). I am new kind in town (SSC & SQL Server).
Kevin, actually I assumed you wanted to write this. Thus I can safely count it as typo. 😉
EXEC sp_who 'active'; --sp_whoisactive
December 14, 2011 at 4:42 am
Dev (12/14/2011)
Ninja's_RGR'us (12/13/2011)
TheSQLGuru (12/13/2011)
...That would be one HELL of a typo! 8 extra characters that actually spell out 2 appropriate words!?! 😎
Go easy on the kid <new born>. He's not an old(ish) fart like the 2 of us. :hehe:
100% agree to Remi (first time :-P). I am new kind in town (SSC & SQL Server).
Kevin, actually I assumed you wanted to write this. Thus I can safely count it as typo. 😉
EXEC sp_who 'active'; --sp_whoisactive
Adn tha'ts 5ive errors in less than then letters. That's doesn't qualify as a typo by most definitions.
Sometimes you're wrong too, you need to be able to live with that 😉
December 14, 2011 at 6:48 am
Ninja's_RGR'us (12/14/2011)
...Adn tha'ts 5ive errors in less than then letters. That's doesn't qualify as a typo by most definitions.
Sometimes you're wrong too, you need to be able to live with that 😉
I am lost...
December 14, 2011 at 6:58 am
Dev (12/14/2011)
Ninja's_RGR'us (12/14/2011)
...Adn tha'ts 5ive errors in less than then letters. That's doesn't qualify as a typo by most definitions.
Sometimes you're wrong too, you need to be able to live with that 😉
I am lost...
I know. :hehe:
December 14, 2011 at 9:07 am
Dev (12/14/2011)
Ninja's_RGR'us (12/13/2011)
TheSQLGuru (12/13/2011)
...That would be one HELL of a typo! 8 extra characters that actually spell out 2 appropriate words!?! 😎
Go easy on the kid <new born>. He's not an old(ish) fart like the 2 of us. :hehe:
100% agree to Remi (first time :-P). I am new kind in town (SSC & SQL Server).
Kevin, actually I assumed you wanted to write this. Thus I can safely count it as typo. 😉
EXEC sp_who 'active'; --sp_whoisactive
I can't see you being new with almost 900 visits to the site and well over 1000 points on the forum! 🙂
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
December 14, 2011 at 9:11 am
TheSQLGuru (12/14/2011)
Dev (12/14/2011)
Ninja's_RGR'us (12/13/2011)
TheSQLGuru (12/13/2011)
...That would be one HELL of a typo! 8 extra characters that actually spell out 2 appropriate words!?! 😎
Go easy on the kid <new born>. He's not an old(ish) fart like the 2 of us. :hehe:
100% agree to Remi (first time :-P). I am new kind in town (SSC & SQL Server).
Kevin, actually I assumed you wanted to write this. Thus I can safely count it as typo. 😉
EXEC sp_who 'active'; --sp_whoisactiveI can't see you being new with almost 900 visits to the site and well over 1000 points on the forum! 🙂
Almost all of it in the last 6 weeks.
Not consulting 80 hours / week like you :-D.
December 14, 2011 at 9:17 am
TheSQLGuru (12/14/2011)
...I can't see you being new with almost 900 visits to the site and well over 1000 points on the forum! 🙂
Kevin, what will you buy?
•I was trying to be humble (failed) :Whistling:
•I was trying to be argue on my bad post (failed) 😛
Well, you should consider me a kid coz I just crossed 1K points milestone. Many guys here crossed 10K (also 20K).
Viewing 15 posts - 16 through 30 (of 33 total)
You must be logged in to reply to this topic. Login to reply