You'd have to move the child, disable the FK, or drop the FK. My guess is they are moving the child to another record, or a holder record.

Or they don't...

Why not? Just curious. If it really helps you, is it...

I don't think they're substituting diseases. As I read it, they don't differentiate down when the sample size is small, so you don't get Diabetes I or II for small...

You should go buy a book on the topic. There are plenty of them to help guide you along.

http://www.amazon.com/s/ref=nb_sb_noss?url=search-alias%3Daps&field-keywords=SQL+Server+&x=0&y=0

I don't believe so. The indexes would need, potentially, to have the updated information in them. I'd hope that an increase in the varchar size, without new data, wouldn't touch...

The difference between a VM and physical server is the resources allocated to it. So you can functionally do anything in a VM (perhaps not some USB stuff), but it...

I tend to agree with you on SQL Intellisense. I don't want it to figure out objects for me, especially with functions mixed in. For those of us that like...

Might have someone else at work head over here and compare experiences. It would be good to have multiple experiences to share back with your team.

Dive

You can parse out things possibly that can't run. There aren't a lot of commands. I would question the need for this particular command.

Snapshots are still an issue of disconnection for users, and in my mind, that's still an issue.

Replication is an issue if it breaks. It should pick up itself, or you...

I think your solution is likely a good one given your constraints. In people that I've known with this issue, the SAN is always started first, before anyone punches on...

Using SQL 2000 there isn't a good way, other than a trace, to track this down. You won't see previous changes, but you can track future ones with a trace.

Very...

You should read the white papers on how this works to better understand. DB Mirroring is designed for DR and the clients can be configured in the connection string to...

I think you'd have to execute some of these steps separately. These commands aren't usually meant to be run in a proc, or often, as they make a substantial change...