Thanks John, that really helps.

Thank you Colin. Our specific issue is that we are pushing over 800 IO Operations/Sec with the current configuration and it is only rated at 400 and we can not...

Well now that things have had 8 hours + to stabilize I rechecked the proc cache. It is up to 330 MB of which Ad Hoc queries occupy about 220...

Can you explain more about RASDIAL and it's use? I've never seen that before?

Thanks,

dab

This is a classic example of an exclusion list and point sout the limitiations of the inequality operator. What is presented in this example is that members in one are are to...

If it runs quickly using with ( nolock ) then try this. Execute the original query without the lock hint and in another window execute the following:

create table #locks

(

spid ...

I've used it many times if I want a quick and easy way to copy the schema of one table to one on another server. Try

select * from RemoteServer.DB.owner.table1...

Thanks for everyones help. The DSTBACKUP2000 did the trick.

dab

K....

I did read in another post on another site that the hotfix fails in a clustered environment if Task Scheduler is turned off.

dab

What about column "g" in table A? Use the Show Estimated Exection Plan to see if the query performing a table scan or an index scan/seek.

dab

I have been on both sides of this issue. I spent 14 years as a letter carrier while working on my degree. There, the attitude was "I am getting...

Frequent appendages to my email:

The generation of random numbers is too important to be left to chance.

Robert R. Coveyou

Fallacies do not cease to be fallacies because they become fashions....

I have additional information to add. I finally found the sp3_serv_uni.out file and it contains the following: Invalid login for user 'sa'. Reason: server is in single user mode and...

None. That's the problem. CLR has been widely touted so I thought I try a few examples. My previous post was just a rant against CLR: wrong tool/solution.

govinn, that was our original plan. We built the staging table with varchar fields and performed an INSERT INTO staging select * from OpenRowset. However, that caused a conversion error...