Well, we're already not comparing apples to apples then. That just makes it harder. No differences in the connection settings, both using the same driver (albeit, different versions)?

I haven't seen...

Good catch Lowell. I didn't see that at all.

Instead of SSMS or Trace, try using the DMV's.

sys.dm_exec_requests will show open, active requests, not just open connections. If you have an uncommitted transaction, it'll be there.

Are you getting an error or is there missing/incorrect data?

So you're saying that the 2008 instance moves more data locally and then processes faster than the 2005 instance...

Are there other differences? More memory, better/more cpu's? Are the connection settings...

You mean that the exact same amount of data is moved regardless of which side you run the query from? Are you sure that one side or the other isn't...

Yep, absolute...

You might be able to find a free software that could help you here: http://www.supershareware.com/sql-server-comparison-free/

I'd go for something like that rather than try to write it myself.

Do you have Visual...

Yep. A linked server query will move all the data across the wire and then perform filtering. You're better off using OPENQUERY to pass the processing to the remote machine...

First off, nesting views frequently leads to performance problems. I recommend against it.

Based on the info in the spread sheet, it looks like you have out of date statistics. You've...

Yep 10gb

You can't segregate the data within a table. If your client has to be completely isolated, then you have to move them to another table. The only other option you...

You can run it for 24 hours, you just have to be prepared for the fact that you're going to get a whole lot of data. Plan accordingly, run a...

Bhuvnesh (9/22/2010)

---

Thanks grant, can you brief about the execution plan difference between these two. can we have the different plan for a view and query ( included into the view...

Brandie Tarvin (9/22/2010)

---

I'm so glad you put those last two words on that sentence. Otherwise, I would feel...