The noise from those things is annoying. I wish they'd block them from the broadcast. I watched a touch of US/Ghana and Eng/Ger and it was very, very annoying. I'd...

It happens in basketball as well. People flopping, which annoys me just as much. I like it when the referees let them play more, but what I don't like is...

And add a couple more referees to watch out for it. You'll never get away from it completely, someone will gamble they'll get a call. But if you have 3...

The question comes out in email, but we cannot edit that. If we find a typo, which fix it on the site, which contains the updated question and the answers....

Excellent! I'll see you there, ALZDBA!

I have removed "great" from the question as it does depend. There is some performance impact, but how much is debatable.

You can view the code in master and just copy it. It's a simple cursor.

I tend to use names in this case, avoiding specific system names.

Me for sure. THe officials are just making mistakes.

I agree that it's hard to charge for a DBA as a support person in many cases. There are companies that just don't want to pay for this from a...

I was thinking

Server A - SQL 2000 (licensed)

Server B - SQL 2008 (unlicensed) - log ship secondary

Server C - SQL 2008 - new server for reporting

However, as George mentioned, the...

vo-confused-erous

My pleasure. It's a trick an admin showed me for scripting something from the command line. Add in a column for server and you have a great SQLCMD script generator.

I think most of the general SQL books are about the same. I might start with one of those, then move on to specific areas you are working on.

Database Weekly...

Here's how I did it with Excel. You could drop this code in a one cell, easily fill your db names in another, and create a quick script with

use dbname

go

create...

More here: http://www.sqlservercentral.com/search/?q=remove+old+backup+files&t=s