Ninja's_RGR'us (5/16/2011)

---

mazzz (5/16/2011)

---

I'd set a separate job to run every Tuesday, use T-SQL to figure out if this Tuesday fulfills the criterion, and then execute the other job or not,...

I'd set a separate job to run every Tuesday, use T-SQL to figure out if this Tuesday fulfills the criterion, and then execute the other job or not, accordingly.

I describe my job as being for databases a bit like what a mechanic is for a car. You check the oils and the air in the tires every so...

A belated congrats from me for your MVP status, Paul - very well deserved!

I read half your article a few weeks ago, and very much enjoyed what I read so...

NB I am no expert, but I will try to respond to a small subset of your questions (I have changed the order in which they appeared)

For example, when she...

I believe (I'm sure someone will correct me if I'm wrong) that version store info is separate to internal objects info (which are more to do with large hash joins...

you could use the sqlcmd command line utility from within a .BAT file, presuming the user has permissions to do whatever DML you want the script to do.

http://msdn.microsoft.com/en-us/library/ms180944%28v=SQL.90%29.aspx

OCTom (3/10/2011)

---

I just noticed that my opening post has the statistic for points @ 1,237 and visits @ 1,663. They total to 2,900, a nice round-ish sort of number. But,...

There's a slideshow about the MySpace set-up here (from 2009, but still):

http://www.slideshare.net/markginnebaugh/myspace-data-architecture-june-2009

I was in awe when I found out, on New Year's day, that 2011 is the sum of 11 consecutive primes: 2011 = 157 + 163 + 167 + 173...

Jeff Moden (3/9/2011)

Heh... it must have been really bad code... normally such a problem with eat the face off of TempDB in just a couple of hours instead of 15....

I had a similar issue a while back.

You could set up monitoring like in this blog post here

You could maybe somehow set it up to alert when the difference...

David Benoit (3/3/2011)

---

Jpotucek (3/3/2011)

---

Mine is Honey. At the time of this pic, she was about 7 months old. Beautiful American Bulldog : )

We lost Honey during the whelping...

I think I've found a future avatar for Lowell

As far as I am aware you can't clear a single wait counter. i.e, you can either clear them all (via that dbcc statement) or not clear them at all.