Based on this being related to leads, how large are the tables involved?

Please provide the execution plan too!

removing your question makes it very hard to help.

2000 records should take very little time at all to update.

Please provide the trigger definition.

GilaMonster (1/10/2012)

---

If I got those from a company prior to an interview, I would think twice (or more) about whether I wanted to work there. Whoever wrote those questions has...

This msdn article explains that.

http://msdn.microsoft.com/en-us/library/ms252109(v=vs.80).aspx

K - I see you on all three....

SQL Kiwi (1/10/2012)

---

Almost usable, perhaps, at a stretch. 2008 was a big...

This should prove useful.

http://technet.microsoft.com/en-us/library/ms178310.aspx

In short - Cycle the log.

megablocks

Thanks for the update.

Ninja's_RGR'us (1/10/2012)

---

Hey guys, what ressource can you recommend for worldwide list of countries, provinces, zip code, etc. The more the better. We ship to over 100 countries so...

SQL Kiwi (1/10/2012)

---

The site is usually pretty good at handling spam reports so my personal view is we don't need moderators, in general. Judging from an automated out-of-office email...

EZ PZ

The query in this article shows how to combine those in essence

http://www.sqlservercentral.com/articles/sp_who2/70222/

It uses the new dmvs and the tran_locks as suggested by Gail.

I have seen that a few people have implemented mirroring for this. I have used logshipping or transactional replication to accomplish this.