November 16, 2009 at 3:48 am
I have 2 sql server
sql server 2005 --> x
sql server 2000 --> y
I 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
November 16, 2009 at 7:04 am
Have you done index maintenance and updated statistics on both servers?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
November 16, 2009 at 8:02 am
Yes I did but the same eror appear, is this a problem in collation and if yes how to get the windows collation and sql server collation
Jack Corbett (11/16/2009)
Have you done index maintenance and updated statistics on both servers?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply