Not saying that at all. We use stored procedures when it makes sense. I was just making sure that no one was implying they were the only way to solve...

From my experience, it's how you write the LINQ query that makes the biggest difference. Whether you are using lambda expressions or writing from selects, etc... I have been able...

Thanks for the reply! We have actually seen that happen in the past as well and it's one of the first things we check and in the case I've specifically...

We have RedGate SQL Monitor so making sure we know when the problem occurs isn't really an issue. We were just hoping someone else may have seen this problem before...

We went down the path of commonality, but nothing jumped out. We could always find something that was different that would make the case against commonality.

We didn't see any patches that would be related to this problem. There aren't any error log or windows event logs that indicate there is something causing the IOPS to...