Yes, it matters where you put it. I generally put it first.

Nah, the performance will be the same with either one of them.

Is there any part of that process that can not be done entirely within a single stored procedure? I believe that it could be.

It is very good performance wise. Much better than returning the entire row.

That doesn't complicate it much at all. I could actually do it in 2 steps without disabling the foreign key, but the update query would be overly complex, and I...

When SQL Server converts a date stored as a string without a time value to a datetime, it assumes the time to be 00:00:00.000 AM. So even if you do...

Wow, such complex solutions!!

It is a simple process. The 4 steps are:

1. Disable foreign key
2. Delete duplicates in Respondent
3. Delete entries in RespondentLOV that do not exist in Respondent
4. Enable foreign key

Alter Table RespondentLOV...

If you are going to be doing this on a regular basis, create a Linked Server to use.

Did you upgrade the SQL client tools on the client side as well? They all have to be upgraded together.

Use sp_helptext. The text column in syscomments is nvarchar(4000) and stored procedures can be up to 128 MB in size. If the procedure is longer than 4000 characters, the output...

Does the table have a column to track update times? If so, you can simply query the table for anything with an update time newer than the last time you...

This information is stored in the registry so you have to manipulate teh registry to do this. That's not something I would recommend to anyone unless they really know what...

Native mode refers tot he way that SQL Server interacts with external databases. SQL Server Native mode means that it is using a language that only SQL Server understands. For...

It sounds to me like locking is the most likely cause. Some query or process had row # 32753 locked in a transaction. If you select just the first 32752...

You can use DBCC FlushProcInDB to fee the proc cache within a single database. There are a couple of good articles on SQL-Server-Performance.com that you should read:

http://www.sql-server-performance.com/dbcc_commands.asp

http://www.sql-server-performance.com/rd_data_cache.asp