Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Ali.M.Habib
Yak Posting Veteran
54 Posts |
 Posted - 2009-11-16 : 05:49:48
|
| I have 2 sql server sql server 2005 --> xsql server 2000 --> yI run one query on both servers , and found that on y execution fast, while so slow on 2005 I displayed the execution plan on both servers and found that on x , the sorting (distinct sort) take 100% cost , while on y it take 1%what's the problem, and how to solve it |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-11-16 : 07:40:24
|
I think it would be easier to answer if we can see an example query and the related table structure with indexes etc.
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-11-16 : 09:31:22
|
| is data identical on both? hardware?indexes up to date? |
|
|
|
|
|
|
Query run on sql server 2000 faster than on 2005