Words aren't necessarily bad and plenty of people prefer using those to autonumbers since they might better represent a real key. An identity is a surrogate key.

If you want to...

Backup your databases in a test environment and run it there. you should have a test environment. If you don't, install a VM system and create a test environment.

The idea...

Sure, enable full mode, run log backups, note size.

There's no downside to doing this. Change it during the day, set up backups every 15 minutes and keep track of the...

Run Profiler and trace the username trying to connect.

Are you sure the user is connecting with Windows auth? Can you connect from that workstation with your credentials?

I'm not sure if this works without being sysadmin. You might be able to kludge it, but after all that, why not just give sysadmin? This should only be on...

The rollback will occur if you trap an error, but you'd need to check for an error after every statement to ensure it gets handled.

If you post the error, we...

George, they should be placed according to some standard when you install, but two issues. One is people not familiar with SQL, or perhaps with your standard (or as part...

I thought that data was compressed in memory for read aheads, but once it needed to be compared to something else it was uncompressed.

That's great compression, but it is...

Is this every night, or regularly, or did this happen last night? It's possible something hung up. If it happens often, either you have hardware issues or you have resource...

The question was a bit tricky as it mentions moving, but doesn't ask that. It asks for system databases, the idea being to clue people in to the fact there...

I'm with Grant, heat, heat, heat.

I like skiing, but other than that, I'd like warm weather all the time.

Ice Age, global warming, the latter winning in CO today. 56F and sunny. Short sleeves outside!!!

i think this is a fairly common problem in code. I see Amazon do this, but they display 4 pages, so if it's 5, you see "1, 2, 3, 4,...

I'm sure you're no worse off than most other states. Seems like civilization in general is declining a bit.

How long did it take you to figure it out, David? If it's not long, and you document it so this isn't repeated, perhaps it is worth going without documentation.

It's...