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.

No, the backup log command does not work with simple mode.

You would use dbcc shrinkfile.

This is like saying you forgot your Windows sign on and what can we do? There's nothing we can do. You need an admin to help as noted above.

You should set your maintenance plans to log, they can do this in text files and don't necessarily need to send to the SQL Server error logs.

Go search for another file, who knows what name, but a .bak file with the same timestamp as this one.

If you are loading often, you're creating a hot spot on the disks. Logs could be an issue here.

I'd get the logs onto separate disks, a small R1 array could...