Maybe I missed it, but can I ask WHY you are doing 5 instances on one server? There is some significant downside to that so I am curious about...

Yes, you should expect better (often extraordinarily so) performance when using temp tables and joins instead of table variables.

Forums are typically used for simple, quick question/answer problems or questions. That is NOT what is requested here. People who are donating their time to help others could...

Accessing, sending, receiving and rendering that amount of data (regardless of actual data size of the 8 columns) is going to take a long time. Period. Either accept...

karthikeyan (8/12/2009)

---

Hi

I have one transactional table called message in my prod db. It is around 15 GB for 5 days data in the table. The data in message table...

I gotta say that without knowing some more justifications and reasonings I think you are embarking upon a lot of effort for little to no gain - actually potentially problems....

matt stockham (8/12/2009)

---

Unless it has changed within the year, a restore-only server does requires a license and you pay...

Have you tried to do the update directly on the server you are updating, using linked servers out to the other parts of the query?

1) VERY IMPORTANT: no one on this site should EVER feel constrained to mention, inquire, recommend, discuss, etc. non RedGate products here simply because they 'own' SQLServerCentral.com.

2)...

I think you should find out what the slowness truly is. Search web for SQL Server 2005 Waits and Queues, a marvelous best practices white paper from Microsoft. ...

Paul White (8/10/2009)

---

TheSQLGuru (8/10/2009)

---

Well, I think (hope) I prefaced my initial stomp on UDFs with that "ancillary data access" statement as the real bugaboo. Perhaps I missed it.

Paul, you...

Paul White (8/10/2009)

---

TheSQLGuru (8/10/2009)

---

Clearly if your logic REQUIRES complex data access/processing PER ROW of output then a UDF is quite possibly the correct tool for the job. You are...

Clearly if your logic REQUIRES complex data access/processing PER ROW of output then a UDF is quite possibly the correct tool for the job. You are definitely correct that...

GSquared (8/10/2009)

---

I've actually built very performant scalar UDFs. The problem with them is when you start using them in join criteria or Where clauses, and kill any possibility of...

To my knowledge, the...