I'm not sure it was a plug as much as Tony was inspired by the book.

However I agree with Jeff. I'd bet that often people without a lot of experience...

That's a horrible bug, even if it were unlikely to occur, that's the type of thing...

Great story, David, and I think that's a problem in many companies, including our vendors. They want features/enhancements in products I'm sure in order to meet bonus targets.

It says something...

I loved restaurant jokes, not limited to Apr1. We used to regularly send newbies out for a left-handed oyster knife.

I think some of you are missing the point here. Chargebacks aren't occurring at BP, and I'm not advocating them. Instead it's visibility by the business into costs, and then...

Here?

Tom,

you're probably right that there should be a one-click unsubscribe. The forum software is old enough that it wasn't required when we bought it. I'll add a note in the...

The identity property, if that's what you are referring to, is optimized and will be faster than a routine you write.

That being said, this is a simple CLR routine...

If you lose the MDF, not sure you can take a tail log backup.

The MDF is the data, the LDF is the log records SINCE the last checkpoint. It's not...

If you lose an NDF, if it's in a separate filegroup and you have performed filegroup backups, you can restore just that one, potentially.

If you lose an NDF, likely you...

Chaniging the isolation level? Move that table to faster disks? Not sure what you can do here, Seth.

I'd argue that a large CRM/ERP application without FKs is just poorly designed. There are all sorts of support/administrative contracts in place to prevent you from working with the data...

I would think that it could delete the backups, but perhaps it's looking in msdb for something.

What I'd suggest is that you look for a script with Powershell or VBScript/FileSystemObject...

The CONVERT or a CAST as shown above is what you need in the query to change the data types so that you can group them.

you might want an ORDER BY at the end as well.

Grouping by multiple columns allows you to count unique values.