Not sure on the restores, based on the "get it out as quick as possible", my guess is the deleted data is in the restore, marked as free.

Very interesting requirement and thought here.

Honestly I'm not 100% sure, though I'll ask the question of some experts.

My understanding is that when you delete a row, it's marked as deleted...

Based on the way I worded the question, msdb is the only answer, and my apologies for the error.

I have awarded back all points to this time on this.

I meant...

That one's been suggested, but people tend not to like pop-ups, and really questions or comments on the articles should be with the articles on other sites.

I know I prefer...

I'll disagree slightly with Grant.

Split your backups from the log and data first if you can. If you lose the data and logs, you'll have your backups. Next, depending on...

There's a lot to check. Do you know what queries will be run? Are they efficient given your design? You have to look at the joins and information you pull...

They work the same, but have different options. As Chris mentioned, one appeals to the standard, but they're functionally the same for most things.

One interesting note I noticed from my company. The HR group at Red Gate will send around a note a few times a year when they notice someone coming into...

Yep, had the numbers switched. With my tax credit, I think I've paid off the hybrid extra cost (about $4k) and am doing better now every month.

With the new tires...

Chris has it correct, scope_identity is what you want.

Deleting it in chunks is actually faster, not huge. When you are trying to drop 10mm records at once, it starts to eat up resources. I've seen deletes that are...

I'm not sure how well this would work. It's one thing when someone intentionally writes for a level, which is what MSDN does, but another when someone is just writing...

Thanks for the update.

Good idea, and I'll add this one to the list. Would be good to see # of replies.

I'll add that one to the list. I think it's saved in your cookie.