I'd like to hear. Only time I've seen problems with this is when there was a ton of data piled up and it was just performing poorly in general.

Can you post the query plan for the slow update?

More RAM is a good place to start, 1G isnt as much as it used to be!

Most of the the work on a distributor is disk io, what do you have...

Thats an interesting idea, but I bet they hold 'hold' the book for you - and so no real cost to them.

I'm also not sure that just omitting from the...

I think its easy enough to change your filegroups around after the initial restore, though I would ask why? I typically only use filegroups if I cant fit all the...

I have a couple questions on that. If not triggers, what auditing technique - something along the C2 switch & profiling? And in the case of SOX, it would seem...

Let's try to stay on topic. Cluttering up discussions attached to content with stuff that doesnt directly pertain just makes it hard on the next person. Standards, identities, all good...

Interesting. Im beginning to wonder if dateadded shouldnt fall into the special case of auditing, and auditing in my experience is best done via trigger, omitting it from the base...

Robert, I salute you for the first sentence of your reply! I think some reply comment was merited without it devolving into flaming or worse and you managed it well.

Joe,...

For those interested, here is the link Joe mentioned: http://www.dbazine.com/ofinterest/oi-articles/celko35

Joe, it's an interesting technique and one I haven't applied at the db level - yet! I'll be looking for...

Patience Colin:-)

It's not where I start either, but it will be a good learning exercise and may well lead to something worth fixing.

Agree with that answer. Replication load is based on usage, typically you'll feel the pain on disk performance first, network usually not an issue unless running a really slow WAN...

Bill, thats a great post - do you have the name of the book by chance?

Masking with views is a interesting approach to combine with defaults though unwieldy I guess, you need an 'insert' view and an everything else view. Colin, I'm kinda with you,...

Index scans are not necessarily bad, but worth checking. For example, let's say you have a table with 10 rows in it, SQL could easily opt for a scan instead...