This should work.

update TableName set Column = replace(Column, ' ', '')

Hope that helps

Fraggle.

A UNION statement would work. I just hate using them. Always try to find a different way of doing something as I don't think they are very efficent.

Fraggle

Is the view going to return more than records from 1 table only or is it going to return values from table2 and table3?

As an example:

table1 (col1 int, col2 name)

table2...

Just so long as well all know that we agree and disagree about the same thing we are agreed upon. 😀

Have you checked to see if the log file size is getting larger over the course of time?

Fraggle

You could get a file corrupter and use it on the files to simulate them. Just make sure you have a good full copy of the database before you...

Maybe this is wrong, and I am sure someone will correct me if I am, but I would try adding columns A & B to the clustered index. Then...

Matt, I agree with you. I have never seen a PIVOT help in performance, but I hestitate to say that this will always be the case. When ever...

Try using the BULK RECOVERY backup model. It sounds like when you are coping all of the data over, it is writing each of the rows to the log....

The only way to truly know is to try it on your server and see how it works. Start with your execution plans for each of them and go...

Would it be possible for you to give us the table design as well as a general idea on how often each of the indexes are used (i.e. index 1...

Glad to help.

Fraggle

It would be in the BOOT.INI.

Follow what Tim said above.

Fraggle.

Is the /3GB swith active? If so, this could explain it.

If not, then I am clueless.

Fraggle

You are correct Gail. I just saw it was in binary format and automatically figured the cast function would work. Didn't even test it. After testing it,...