Wow, something's broken. I'll log a bug.

I see this post only in your list of posts, but then see your name in the thread.

You could argue that flat file databases don't allow you to join things together at the server level, and perhaps you'd be correct, but really all databases have a way...

Hey, maybe it's this one:

http://www.sillyjokes.co.uk/wacky/weapons/guns/super-cowboy-pistol-12.html

There is a real one: http://www.prices4antiques.com/firearms-edged-weapons/hand-guns/Hand-Gun-Revolver-Walch-Navy-Model-Revolver-12-Shot-Cylinder-36-Caliber-D9911296.asp

Wow, that's a lot! Definitely use the black version if you're a CRT user.

37Signals had a great disdain for Gantt charts and in the talk by Jason Fried, he actually stopped and spent 4 or 5 minutes saying why they're so bad. They're...

I've seen quite a few people virtualize with success, quite a few more with Grant's experience.

If you virtualize, and I like the idea, you can't use the same level of...

Only by searching through your code. SQL Server doesn't know what isn't being called from other applications.

Once you get running, you can run Profiler and look for objects that...

In Management Studio, there are reports for various objects. Right click, select "Reports" and you'll see them.

A couple comments.

1. Don't overwrite yesterday's backup with today's. Use a new file everyday. Here's the reason. The overwrite occurs first and if the backup fails for some reason, you've...

Not in 2000. In 2005 there are DDL triggers.

I used to capture the output of various things, like sp_configure, every day and store it in a table. The compare it...

Grant has some good resources, but before you ask a question, you need to do some research and some work. We are happy to help, but we don't want to...

Concur with the above.

Rebuilding the clustered index will move the data to a new filegroup if you specify it.

From ASP you have two choices. The first is call DTSRUN with the dtsx file as a parameter, but if it takes any amount of time, you'll have a timeout...

The backup transfer time is less of an issue than the log backup sizes. You can easily FedEx the backup, or take 2 days to xfer it if in the...

You need to go into the SQL Agent properties and set a proxy account for xp_cmdshell. Looks like that account might not be properly set.