balasach82 (7/20/2013)

---

We had a linked server from SQL 2008 to SQL 2005 and perfroming inserts/updates/deletes in SQL 2008. Almost always, it was running for 6hrs (data volume doesnt seem to...

As I said, I need to see the deadlock trace, to be able to say...

Without the plan and the query, there is not much we can do. Performance tuning is not about telepathy....

There is. Did you try the UPDATE statement, I gave you?

It's difficult to comment on the deadlock, since I have not seen the deadlock traces.

But I think the query would better be:

UPDATE TableToBeUpdated

SET ColumnToUpdate = @UpdateParam

FROM ...

Could you post query and attach the query plan as a start?

Can you post the actual query and the view definition as a start?

That should work out fine, I think. But take a snapshot of your VM before you go ahead. (If you VM software supports that.)

mikej 14403 (2013-07-20)

---

After creating a csv file, importing it into a Excel spreadsheet and finally importing it into a SQL table I notices white space both left and right of...

No, indexed views does not cut it. You would need a view that performs a UNION ALL of the two tables, but UNION is not a permitted construct in an...

That depends on what you want to do. To remove all leading and trailing spaces, you would do:

UPDATE tbl

SET col = rtrim(ltrim(col))

WHERE col <>...

It is certainly a lot easier to help you if you post the actual SQL statement you use as well as the exact error message.

jallmond (2013-07-19)

---

In the long run, you probably want the same across the board, but of course it will...

Eh, yes, there are concerns, since CONTROL gives them full control on the table. ALTER is slightly better, but that may be bad enough. To you want these users add...

I think the problem is that the question is too open-ended. Whether the script you posted makes sense, all depends on what you want...