Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12345»»»

What, When, Where, How, Who2 Expand / Collapse
Author
Message
Posted Saturday, June 12, 2010 11:24 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 6:00 PM
Points: 17,825, Visits: 15,758
Comments posted to this topic are about the item What, When, Where, How, Who2



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #936452
Posted Monday, June 14, 2010 1:25 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, October 24, 2010 9:40 PM
Points: 6, Visits: 20
Jason

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 not serialize the data for node 'processing-instruction(definition)' because it contains a character (0x0000) which is not allowed in XML. To retrieve this data using FOR XML, convert it to binary, varbinary or image data type and use the BINARY BASE64 directive.

I will try and debug if/when I get time, If any anyone else has a solution already then tell me!
Post #936632
Posted Monday, June 14, 2010 4:13 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 4:28 PM
Points: 4,421, Visits: 10,739
Nice article, Jason.
I haven't tried your code yet, but looks very neat.
Well done.


--
Gianluca Sartori

How to post T-SQL questions
spaghettidba.com
@spaghettidba
Post #936695
Posted Monday, June 14, 2010 6:35 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, October 13, 2014 6:00 AM
Points: 79, Visits: 756
Very nice. Code works fine on our SQL2008 (SP1) - 10.0.2531.0 server. Thanks!


Post #936781
Posted Monday, June 14, 2010 7:55 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, October 8, 2014 2:19 PM
Points: 312, Visits: 409
Very well written, Jason! I appreciate the elimination of the DBCC INPUTBUFFER step after all of my sp_who2 steps.


Post #936845
Posted Monday, June 14, 2010 8:08 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 10:14 PM
Points: 5,364, Visits: 8,952
Good article Jason!

Wayne
Microsoft Certified Master: SQL Server 2008
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links: For better assistance in answering your questions, How to ask a question, Performance Problems, Common date/time routines,
CROSS-TABS and PIVOT tables Part 1 & Part 2, Using APPLY Part 1 & Part 2, Splitting Delimited Strings
Post #936856
Posted Monday, June 14, 2010 9:15 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 6:00 PM
Points: 17,825, Visits: 15,758
John Cuthbertson (6/14/2010)
Jason

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 not serialize the data for node 'processing-instruction(definition)' because it contains a character (0x0000) which is not allowed in XML. To retrieve this data using FOR XML, convert it to binary, varbinary or image data type and use the BINARY BASE64 directive.

I will try and debug if/when I get time, If any anyone else has a solution already then tell me!


First - thanks.

Second, what version and patch level of SQL Server? I have not encountered this in my testing.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #936931
Posted Monday, June 14, 2010 9:16 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 6:00 PM
Points: 17,825, Visits: 15,758
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
Post #936932
Posted Monday, June 14, 2010 9:18 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 6:00 PM
Points: 17,825, Visits: 15,758
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
Post #936935
Posted Monday, June 14, 2010 9:24 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 6:00 PM
Points: 17,825, Visits: 15,758
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
Post #936939
« Prev Topic | Next Topic »

Add to briefcase 12345»»»

Permissions Expand / Collapse