Well, the issue is that the client needs to extract data from two tables and merge the resultsets together after filtering out some records. I've managed to remove other...

Thanks for the reply, but it's not quite what I'm asking. If you add an ORDER BY clause and look at the execution plan, you will see there is...

Jorg, that link is very helpful. I was looking for a more general solution for 2000 but that's great for 2005. My big problem is interpretting the lock...

When I go to Surface Area Config and look at Services and Connections -> Remote Connections I see that Local and Remote Connections for both TCP/IP and Named Pipes is...

Thanks for the info, I'm kind of surprised there's not some DBCC command to just reset them all. Perhaps there's a good reason...

We use the aggregate counters for performance statistics after changes are made to the application databases. We would like to reset them after changes are deployed. It would...

Can you give more examples about what to look for with the SAN configuration? Specifically, what would cause a problem like this besides the disk not being NTFS.

Also, do...

I'm not sure the SAN configuration is the issue because if that was the case then I think all of them might have an issue, but I do think you...

I'm seeing the same issues. Anyone know what might cause this?

SQL Ver 9.0.3186

That's great dlcook, thanks!

We have a system suffering from the same issue. It's actually the only one of our systems suffering from it because all of the others are using StateServer (so...

Okay, I'm having a similar issue and I've done extensive research on this problem. First I'd like to say that if you have encryption functioning through your native client...

The links provided above in Frank's response no longer work, can someone post the new links?