March 24, 2010 at 4:15 pm
Chad Crawford (3/24/2010)
I use this on 2K5. I have a job that runs every night and stores it in a table so I can see historical trends - also allows me to see data from before a service restart, which resets the counters: ...
Funny how things happen. I was just working on a nightly process to do something like this. Do you mind if I borrow your code and modify it to work for my enterprise?
EDIT: made it small and fixed my grammer.
---------------------------------------------------------------------
Use Full Links:
KB Article from Microsoft on how to ask a question on a Forum
March 24, 2010 at 4:50 pm
Trey Staker (3/24/2010)
Funny how things happen, I was just working on a nightly process to do something like this...
Yes, agreed. I have seen this several times here at SSC. It (this type of coincidence) has helped me out on several occasions as well.
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
March 25, 2010 at 5:44 am
I always think of it like critical mass, enough people get together and the same ideas start popping up in different places. Always interesting to observe.
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
March 25, 2010 at 6:29 am
What happened? A slow night on the thread? I only had 6 or 7 new notifications (usually 40-50)! Although I did steal the "table usage" script - nice way to start my day, with a new tool in the ol' toolbox! Thanks Chad, Jack and Jason!
-- You can't be late until you show up.
March 25, 2010 at 7:12 am
Here's an interesting opinion on braindumps.
"The software complaints [about the use of braindumps] are more from the elites trying to keep people out."
http://www.sqlservercentral.com/Forums/FindPost889310.aspx
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
March 25, 2010 at 7:51 am
GilaMonster (3/25/2010)
Here's an interesting opinion on braindumps."The software complaints [about the use of braindumps] are more from the elites trying to keep people out."
I read that last night and I just commented on her comment.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
March 25, 2010 at 8:01 am
Alvin Ramard (3/25/2010)
I read that last night and I just commentrd on his comment.
her comment
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
March 25, 2010 at 8:04 am
GilaMonster (3/25/2010)
Alvin Ramard (3/25/2010)
I read that last night and I just commentrd on his comment.her comment
Thanks Gail. Corrected
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
March 25, 2010 at 8:52 am
GilaMonster (3/25/2010)
Here's an interesting opinion on braindumps."The software complaints [about the use of braindumps] are more from the elites trying to keep people out."
Is it me or is she always such a negative nellie?
March 25, 2010 at 8:57 am
Lynn Pettis (3/25/2010)
GilaMonster (3/25/2010)
Here's an interesting opinion on braindumps."The software complaints [about the use of braindumps] are more from the elites trying to keep people out."
Is it me or is she always such a negative nellie?
All I'll say is that it looks like a battle not worth fighting.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
March 25, 2010 at 9:05 am
Alvin Ramard (3/25/2010)
Lynn Pettis (3/25/2010)
GilaMonster (3/25/2010)
Here's an interesting opinion on braindumps."The software complaints [about the use of braindumps] are more from the elites trying to keep people out."
Is it me or is she always such a negative nellie?
All I'll say is that it looks like a battle not worth fighting.
I have to agree. I think this is one I will step away from.
March 25, 2010 at 9:09 am
Lynn Pettis (3/25/2010)
Is it me or is she always such a negative nellie?
It's not you.
Remember the discussions on women in IT and how she reacts in those. There's a reason I commended here but didn't take it up there.
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
March 25, 2010 at 9:38 am
Negative + chip on shoulder = bad combination.
--Jeff Moden
Change is inevitable... Change for the better is not.
March 25, 2010 at 10:24 am
GilaMonster (3/25/2010)
Lynn Pettis (3/25/2010)
Is it me or is she always such a negative nellie?It's not you.
Remember the discussions on women in IT and how she reacts in those. There's a reason I commended here but didn't take it up there.
That editorial thread has really gone sideways. From somebody who apparently writes exams for MS, she is promoting that it is ok to violate the NDA. Now we have others saying that MS encourages it as well.
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
March 25, 2010 at 10:43 am
EDIT:
I removed it and I'm going to post it outside this thread...
This is a fun thread...
2nd EDIT: Link to what was here in the right thread:
---------------------------------------------------------------------
Use Full Links:
KB Article from Microsoft on how to ask a question on a Forum
Viewing 15 posts - 13,291 through 13,305 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply