<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by Jason Brimhall
»
What, When, Where, How, Who2
50 posts, Page 2 of 5
««
1
2
3
4
5
»
»»
What, When, Where, How, Who2
Rate Topic
Display Mode
Topic Options
Author
Message
SQLRNNR
SQLRNNR
Posted Monday, June 14, 2010 9:25 AM
SSCoach
Group: General Forum Members
Last Login: Yesterday @ 10:25 AM
Points: 18,754,
Visits: 12,337
WayneS (6/14/2010)
Good article Jason!
Thanks Wayne.
Jason
AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008
SQL RNNR
Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #936943
bitbucket-25253
bitbucket-25253
Posted Monday, June 14, 2010 11:11 AM
SSCertifiable
Group: General Forum Members
Last Login: Today @ 12:39 PM
Points: 5,103,
Visits: 20,220
Jason
Thanks for a job well done. Now to add this new tool to my tool box.
If everything seems to be going well, you have obviously overlooked something.
Ron
Please help us, help you -before posting a question please
read
Before posting a performance problem please
read
Post #937018
Roy Ernest
Roy Ernest
Posted Monday, June 14, 2010 11:16 AM
Hall of Fame
Group: General Forum Members
Last Login: Yesterday @ 6:27 AM
Points: 3,280,
Visits: 6,623
Hey Jason,
Good Job there. I already have this version running in QA right now.
-Roy
Post #937021
Trey Staker
Trey Staker
Posted Monday, June 14, 2010 12:20 PM
Ten Centuries
Group: General Forum Members
Last Login: Wednesday, May 01, 2013 4:52 PM
Points: 1,379,
Visits: 2,626
Nice article Jason! I haven't tested the code yet but can't wait to have a chance to do this. You did a really thorough job.
---------------------------------------------------------------------
Use Full Links:
KB Article from Microsoft on how to ask a question on a Forum
Post #937054
SQLRNNR
SQLRNNR
Posted Monday, June 14, 2010 12:48 PM
SSCoach
Group: General Forum Members
Last Login: Yesterday @ 10:25 AM
Points: 18,754,
Visits: 12,337
bitbucket-25253 (6/14/2010)
Jason
Thanks for a job well done. Now to add this new tool to my tool box.
Thanks
Jason
AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008
SQL RNNR
Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #937065
SQLRNNR
SQLRNNR
Posted Monday, June 14, 2010 12:49 PM
SSCoach
Group: General Forum Members
Last Login: Yesterday @ 10:25 AM
Points: 18,754,
Visits: 12,337
Roy Ernest (6/14/2010)
Hey Jason,
Good Job there. I already have this version running in QA right now.
Thanks Roy.
Jason
AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008
SQL RNNR
Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #937066
SQLRNNR
SQLRNNR
Posted Monday, June 14, 2010 12:49 PM
SSCoach
Group: General Forum Members
Last Login: Yesterday @ 10:25 AM
Points: 18,754,
Visits: 12,337
Trey Staker (6/14/2010)
Nice article Jason! I haven't tested the code yet but can't wait to have a chance to do this. You did a really thorough job.
Thanks
Jason
AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008
SQL RNNR
Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #937068
dma-669038
dma-669038
Posted Monday, June 14, 2010 1:57 PM
Old Hand
Group: General Forum Members
Last Login: Monday, November 12, 2012 6:46 AM
Points: 312,
Visits: 1,024
Very nice article Jason. I must try the code, it looks neat. I would also recommend to anyone Adam Machanic's sp_whoisactive, we use that extensively. Thanks.
Post #937108
Adam Machanic
Adam Machanic
Posted Monday, June 14, 2010 2:41 PM
Ten Centuries
Group: General Forum Members
Last Login: Yesterday @ 9:43 AM
Points: 1,137,
Visits: 670
dma-669038 (6/14/2010)
Very nice article Jason. I must try the code, it looks neat. I would also recommend to anyone Adam Machanic's sp_whoisactive, we use that extensively. Thanks.
For reference, the URL for that is:
http://tinyurl.com/WhoIsActive
Seems the author of this article uses it too, since he has copied my XML technique (with no attribution, and not as well as I've done, I won't hesitate to add
)
--
Adam Machanic
SQL Server MVP
SQLblog.com: THE SQL Server Blog Spot on the Web
Post #937135
SQLRNNR
SQLRNNR
Posted Monday, June 14, 2010 6:43 PM
SSCoach
Group: General Forum Members
Last Login: Yesterday @ 10:25 AM
Points: 18,754,
Visits: 12,337
Adam Machanic (6/14/2010)
dma-669038 (6/14/2010)
Very nice article Jason. I must try the code, it looks neat. I would also recommend to anyone Adam Machanic's sp_whoisactive, we use that extensively. Thanks.
For reference, the URL for that is:
http://tinyurl.com/WhoIsActive
Seems the author of this article uses it too, since he has copied my XML technique (with no attribution, and not as well as I've done, I won't hesitate to add
)
ermmm, nope didn't get it from WhoIsActive. However, I do like your code too. I guess I will have to look even closer at your proc.
Jason
AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008
SQL RNNR
Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #937199
« Prev Topic
|
Next Topic »
50 posts, Page 2 of 5
««
1
2
3
4
5
»
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
