REPLACE(@wordlist,'  ',' ') will replace double spaces with single spaces.  You may need to do this in a loop and check for the condition where no double spaces exist as...

Gila,

"As a suggestion, post your table design, index design and long running queries and we can offer suggestions"

Dan has a second thread pertaining to this issue with the table/index...

In EM, right-click on the table and go to All Tasks>>Generate SQL Script.

Can you post test data or create a couple of examples?

How about a few sample rows from Response_1000 and maybe the same for RpsRespondent (along with the DDL)?

FYI... I also placed this same request in your performance tuning thread..

You need to figure out how to get your queries to use an index seek.  On a table with...

"There's already proper indexes, and a lot of my queries require and perform index scans."

The index scans are probably your problem.  Index seeks perform much better than index scans.  You...

Can't you achive the same thing by placing a clustered index on a questionID column in your answers table?  If you know what question that you are working with, you...

Here are some good suggestions:

http://www.sqlservercentral.com/columnists/awarren/copyingdtspackagestoadifferentserver.asp

You would need to use dynamic SQL.  Look in BOL for sp_executeSQL.

Your plan sounds good to me.  It is always nice to be able to stage a server.  I have done it that way and also the not-so-nice way of...

SQL Server is not always able to defag an index.  What happens if you run the DBCC command straight from QA and not in the stored procedure using dynamic SQL? ...

What OS version are you on?  You may consider adding any available OS service packs.

When you say 'normal' P4, I assume that you mean you are using a workstation class machine with a single processor, 1GB of RAM and a single, 222 GB hard...

Right, but using getdate() in combination with month, day, year, or even convert will get you a date only. 

Look up GETDATE() in BOL.