Since you want to do the "whole" db. Would it not be faster to just script all the tables and associated constraints & settings (or probably the whole DB),...

It interprets/formats data like dates and possibly float/decimals in a certain way.

I can't remember the full details but you can look up BOL, but it definitely can affect the way...

I've just started learning SSIS and had a problem with dates and it came down to setting the locale on the data flow components.. The pitfall is this is hard...

1st thoughts (Note there are probably more elegant ways to do this if I thought about it longer)

1. Get a list of all of the contactids and anniversary dates

2. Generate...

It could be that the csv files loaded had foreign characters or additional formatting characters which could not be blatantly seen and may need to be fixed/filtered?

Not sure if you sorted this out. I had the same problem and noticed in a later version of BOL and other areas, you need to make sure you...

I used to write similar code like this for years and then discovered tally tables made it easier and faster IMHO.

Here's an example:

http://www.sqlservercentral.com/scripts/Miscellaneous/31913/

Useful intro on identifying deadlocks.

The part that concerned me more was:

"As part of the upgrade, the application team performed modifications to the stored procedure code such that every insertion...

eric.gunn (2/4/2009)

---

This can be determined without the loop by employing a tally table.

If not familiar with a tally table, aka number table, it is simply a table with with...

Not sure if this is of any use, but in addition to the nolocks, things to also check are if you are using begin and commit trans for several of...