Please confine the discussion to the article and not attack each other.

Debating whether or not the terms used are appropriate, accurate, or even necessary is one thing. Saying that the...

I would think snapshot isolation would help, but I'm not a replication expert. With that many changes coming through, I suspect you are going to have issues. It's like packing...

So here's what I suggest. When things are slow, check for locking/blocking. I would be concerned that someone has not setup transactional replciation and instead setup some snapshot replication, or...

That was good, Paul.

I think we win the Olympics, though we should. Lots of $$$ and people. No excuse for not doing well.

I was thinking of the same thing as Lowell, a central table with an identity used to seed the other tables.

Thanks for the update. That is an interesting behavior, makes me wonder how they are building connection strings in the plans.

Five of six years ago Microsoft published some surveys that showed about 100,000 MCDBAs, but closer to 1,000,000 people calling themselves SQL Server DBAs. Most people don't have certs, in...

I'm confused what you mean by the subscriber is not accessible? Replication runs continuously, so is the subscriber never accessible? Or do you have scheduled subscription pull/push?

I haven't seen...

Irony indeed.

I don't think it would be that hard to enable some features in Enterprise edition. I would love to be able to buy a few of the high end...

There's no way to do this automatically. You would have to write code, either with triggers that handle things, or with some other management from your application. Even with triggers,...

Ah, good catch, jcncarter.

In 2000, only 2GB is supported for Std. This was a 2005 forum, so I wasn't thinking. Won't matter in that case.

I was searching for as reference, but can't find one. I believe Jason is correct, SQL Server, 32 bit, needs AWE to access more than 2GB of RAM.

Both scary and reassuring. You can make a mistake and keep your job, but why wouldn't this be a terminating offense?

Identity could be tough. What about someone that purchases, say beer, and wants to remove that? Not sure that's a valid removal item. Some places are also required to have...