Viewing 15 posts - 13,576 through 13,590 (of 19,560 total)
Seth-95001 (6/14/2010)
Very well written, Jason! I appreciate the elimination of the DBCC INPUTBUFFER step after all of my sp_who2 steps.
Thank you.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 14, 2010 at 9:24 am
Gianluca Sartori (6/14/2010)
Well done on the "Mentor" thread, Gail.Hope he stops.
It seemed to me that the argument was coming from one side today. It appeared that Jeff bailed on...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 14, 2010 at 9:24 am
andycao (6/14/2010)
Very nice. Code works fine on our SQL2008 (SP1) - 10.0.2531.0 server. Thanks!
Thanks - and you're welcome.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 14, 2010 at 9:18 am
Gianluca Sartori (6/14/2010)
Nice article, Jason.I haven't tried your code yet, but looks very neat.
Well done.
Thanks Gianluca
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 14, 2010 at 9:16 am
John Cuthbertson (6/14/2010)
Looks like you have done some good work.
However, I tried to run the stored procedure and got....
Msg 6841, Level 16, State 1, Procedure who4, Line 28
FOR XML could...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 14, 2010 at 9:15 am
Peach (cobbler)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 12, 2010 at 9:33 am
bitbucket-25253 (6/11/2010)
Default port 1,433
UDP Broadcaster 1,434 ...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 11, 2010 at 9:16 pm
cherries
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 11, 2010 at 8:14 pm
crookj (6/11/2010)
CirquedeSQLeil (6/11/2010)
bananaSplit
Joe
Whipped cream
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 11, 2010 at 3:46 pm
banana
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 11, 2010 at 1:47 pm
The Dixie Flatline (6/11/2010)
fudge
magic shell
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 11, 2010 at 1:18 pm
cluster
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 11, 2010 at 12:38 pm
Lynn Pettis (6/11/2010)
Lynn Pettis (6/11/2010)
I know we have several MVP's here on SSC, but most of you don't advertise it, and perhaps...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 11, 2010 at 11:41 am
Thanks
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 11, 2010 at 8:16 am
GilaMonster (6/11/2010)
Oops.
Ouch - poor unfortunate soul
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 11, 2010 at 8:16 am
Viewing 15 posts - 13,576 through 13,590 (of 19,560 total)