If you need to use languages outside English, then use Unicode. If you are sure you won't, then stick with regular varchar.

There are lots of ways to do this, but most of them come down to being organized and standardized in how you approach deployments.

I wouldn't give anyone Visual Studio...

Use a production backup and obfuscate the data.

Buy a tool. Red Gate has a data generator you can use.

In this case GUIDs are a better choice. You can use identities, but pick ranges for each system, large ranges, if you do.

Don't cross post.

Answered here: http://www.sqlservercentral.com/Forums/Topic511041-146-1.aspx

How true, how true.

The measure of a person is how well they do the work and...

Project Management is a big part of it, but it's also how we want to be perceived by other groups and people in general. I think IT has a fly-by-night,...

The download has been updated to correct a few bugs, courtesy of Mr. Bird.

I probably didn't do a good job explaining the analogy, but I think that looking at other professions might help us decide if we should change the way we do...

:), I was going to suggest what you posted. Single user mode usually helps here.

Terry,

Good advice.

OP,

You would restore the full, the diff, and logs, and with the final log, go as long as you can. You have to practice those tasks. I'm not sure...

That's a good question. I know xp_delete_file is called, with the filename and time base on tracing things.

In testing, I also saw a call like this:

exec sp_executesql N'RESTORE LABELONLY FROM...

2 instances meaning active/active or 2 instances on one node in active/passive?

Are you adding another server (3 nodes) for the instance or a third instance somewhere else?

Config Mananger, is it connecting to the virtual node or one of the individual nodes?

It might not be cluster aware. I wouldn't be surprised there if you had to manually...

Marios,

That's an interesting scenario. I haven't dealt with it, but my thoughts are that you enable AWE on all instances. With 2-3GB for each instance, I think you would not...