http://www.microsoft.com/Sqlserver/2005/en/us/Compare-Features.aspx

In standard.

It's nothing amazing. You could set it up yourself with a few jobs that backup, copy and restore.

It should be fine during normal workloads.

You can set up linked servers, which will be there and allow you to do updates. More admin work here.

you can set up an openquery/openrowset statement to do the work,...

Interesting responses and I hadn't really considered the social aspect much. I don't get the updates on my phone because it is too distracting for me, but I do get...

I can see where the question is a little ambiguously worded. I shall add a "select all" and award back points to people for this one.

How are you getting the list of doctors? Is it passed in or is it in a table.

Please do not post links to places that discuss actual questions or answers. This is a violation of the exam NDA.

Announcement tomorrow, but it will be 8-10, room 615 in the Convention Center, right after the opening.

There shouldn't be sharing of plans, but I could be wrong.

I know people that have had hundreds of duplicate databases (different data) on an instance, but not 2000. It depends...

Are you saying physical structures or logically if you have things set up in RI?

The constraints are enforced, as are unique indexes if you didn't allow dups when you built...

You could have 2 different IPs, one on each node (active / active), or you could have 1 with different ports (active/passive), but not 3.

If you had 3 nodes, you...

And on every instance. Usually I have things scripted out, but still I shouldn't have to implement this every time.

Ah, but the problem is the way the option is there. It shouldn't be an offline operation. Making this an enterprise only feature was ridiculous. I understand most of them,...

Yikes, a smell sensor?!?!

Not sure I want to handle data quality on that one

You can't, but if it's a daily load, why do you care? The space will get reused tomorrow.