asked on

SQL 2000 vs 2005, Key differences

Used Ms SQL 7 and SQL 2k.
Now we have some performance issue and the table has grown.
Our total DB size is 10 GB till now and next year may 11 GB. (100 users)

Question is,
If we upgrade to SQL2005 what benefit will we get apart from
security, relibility, scaleablity.
looking some professional answers from exprets........

SOLUTION

Jai S

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

Guy Hengel [angelIII / a3]

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

macentrap

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

MrRobot

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

MrRobot

thanks for warning angelIII, it was intended to keep the answer local as it was more preferable last I was using EE. I'll keep this in mind for the future responses.

MrRobot

greetings imran786,

MS has a document on the key differences at :
http://www.microsoft.com/sql/prodinfo/overview/whats-new-in-sqlserver2005.mspx

But you're probably looking for a review from a user perspective. You can find two different reviews from a DBA's and a developer's perspective here :
http://www.sqlservercentral.com/articles/Administration/2988/

MrRobot

btw, you'll need to register to read the articles on sqlservercentral.com =)

thanks for the info, angel.

Guy Hengel [angelIII / a3]

you are welcome.
glad you understood this in the right way!
angelIII

imran786

ASKER

Thanks everybody,
Comparision between 2k & 2k5 is clear now.
Issue is in performance.
"splitting large tables into parts" is almost already done.
I will also read there source article mention in above.
Any other point is required to trace the reason of slowness.