tosscrosby-60625 (3/12/2010)

---

If that's the case, I can spin some 45s or LPs (even a few cassettes)...

Chad Crawford (3/12/2010)

---

That was EXACTLY my thought too. Update AuthorPostCount SET Posts = Jeff+3000...

george sibbald (3/12/2010)

---

Jason, excellent article, in particular your second method for tracking growth. Thanks for taking the time to develop this and then share it with the community.

In your SQL...

I know. Time for dba.sleep(8)

Paul White (3/12/2010)

---

Jason...CTRL + SHIFT + R!...

The current admin account, are you referring to an account in the format of a domain account (yourdomain\yourlogin)? Or did you type in 'SA' for the user account and...

Nice article.

Hah - Paulpatine spinning like the MCP before Tron obliterates it with the...

Books Online

There are also some good books/resources in the Books section here at SSC.

Is this server clustered or a VM?

Try the following if clustered:

---

You may need to put a couple of entries for the short and FQDN cluster names in the hosts file...

dheer (3/11/2010)

---

Hi i m having a requirement where i need to include all the months between two date for ex:

select DATEDIFF(mm,'10/1/2009','1/1/2010') gives us 3

because its taking the diff of...

I think the disconnect reconnect method is about the best way to refresh it. It seems to be most consistent for me.

Straightforward answer for a straightforward question.

Thanks.

Even if this must be done in a prod environment, you may be able to use the shrinkfile and do it in chunks. Of course pay attention to performance...

Some of the things we have done include:

Paintball

Kart Racing

Basketball

Nerf Guns

Throwing a football around

Chair races around the office

Miniature Golf

It may be a little relaxed to do things like that, but it...