The best thing you can do is set up regular monitoring of your data. You can get third party tools like Idera's Diagnostic Manager or the new one from SQL...

I've found that...

Your previous post scared me. I wasn't entirely kidding about sticking a fork in myself as a comarison. Using CLR is of questionable benefit in most situations. This one is...

So what do I do with these pork chops? Sharpen the bones & throw 'em like a boomarang?

Replaying Trace does work. It's a bit of a pain to set up, but it does work. However, a Trace is dependent on you already having a database and application...

I liked "DBAs of Dawn" better.

I've done a ton of testing of SQL Server 2000 and 2005. I've never tried load testing replication before, so I'm not sure of anything that would help you there.

The...

It's not normal for a single procedure to take all the resources, no. But if the query is really poorly written or designed, it certainly could happen.

I'd make sure you...

Nice post. Good set of rules. But now we'll have to refer to you as Jeff Isaac Rbar Moden. You're starting to sound like a Civil War general.

Is it safe to assume that MovementIdentifierContext, MovementIdentifier and MovementIdentifierContext, while not unique as noted, combined identify a given Movement? Or is it just the IdentifierContext and IdentifierComposite fields, those...

There's not enough information in the question to give you specfic answers, but some general thoughts I would have when faced with the general situation...

Can you test the update against...

You can also need to update statistics on smaller tables where large percentages of the data changes regularly.

No doubt. I wouldn't do it. Ever. I was just pretty sure that it was possible. It's also possible to stick my fork into my thigh... I'm not doing that...

You've got two different issues you're going to be working with. First, the lack of PK & FK in the database could lead to serious integrity issues. That means the...

TRY/CATCH itself has no performance implications. What you do in the CATCH statement could have serious performance implications.