Thanks for the reply.

In my case, the account I am using is sysadmin on the machine and instance, so I cannot fathom it not having adequate permissions locally.

Roy Ernest (5/8/2008)

---

When ever I have high I/O operation on queries, I get multiple threads for single SPID (Ofcourse it shows CXPacket as the wait type). One thing I also...

Thanks all for your responses.

Steve, yes, there are triggers running.

Matt, I hate cursors too... 🙂

Gail, thanks for the info, I've wondering about this for quite some time...

Apologies if it has been mentioned in this thread already, but you will want your tempdb data files isolated on their own physical device (RAID 1 if possible), let them...

Is this discussed in the link you sent...

colin Leversuch-Roberts (5/5/2008)

---

I've remarked a number of times that whilst the amount of information available on the various ms blogs is fantastic it doesn't always link up team to team,...

colin Leversuch-Roberts (4/29/2008)

---

you should not use the raw data in the dmv's for index analysis, always port the data to a table at regular intervals and analyse from there. I...

Thank you all for your responses.

Steve, what I am looking for is a way to tell how long the data stored in DMVs has been kept for so I...

If your data transfer can be a strictly scheduled process, then SSIS is preferable. Performance-wise, SSIS has some built-in optimizations (I believe) that make it superior to linked servers.

If, on...

chileu17 (4/25/2008)

---

About the upgrade advisor, it's done 😎 and all the implementations it asks for. But there are some warnings like the networks connections that aren't supported anymore by 2k5...

chileu17 (4/25/2008)

---

Hi everyone, so there is not a known answer for this topic yet :crying:

Do you guys think if Microsoft has an answer for this?

I have to migrate a...

Actually, this works like a charm, thank you!

Query returns 500,000 records in a fifth of the time of what it did before.

thank you, I should have seen that....:)

Actually, I tried to simplify a more complex query for the original posting.

I will try to find out what I missed when I trimmed...

thanks guys, much appreciated.

...and I thought I had seen it all! :w00t: