SQL Server 2005 or 2008?

5 pts.
Tags:
Microsoft Access
SAS
SQL
SQL Server 2005
SQL Server 2005 vs SQL Server 2008
SQL Server 2008
SQL Server Version Comparison
I am a database user going back many years and have used several different platforms from the high-end (NCR's Teradata) down to MS Access. I work for a Marketing Service Provider and we do alot of Marketing Database building with associated reporting and analysis and also use SAS for statistical modelling and analysis. We also build Marketing Databases using SAS and a niche Marketing analysis tool called Alterian. I have recently led the way in a push towards using a middle tier (and cheaper) tool such as SQL server to carry out data processing and database building but as no-one else in the company has any experience, I am largely relying on what information I can gleam from the internet. I have worked out that as a company, for our needs we need to get the Standard Edition of the product (I can't see at this stage that the Enterprise version is necessary - comments welcome?) but as SQL Server 2008 is quite new I'm struggling to find anything that directly compares 2005 and 2008. It's obvious that there is a large community of 2005 users and experience/knowledge that has been published to the web which seems like a good reason to start with SQL 2005 but what I can't tell is if the functionality of 2008 is that more advanced, that it makes it worthwhile commiting us to the newer technology. Can anyone offer advice or point me in a helpful direction for comparative info?
ASKED: December 2, 2008  6:05 PM
UPDATED: December 8, 2008  3:31 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

Others may have more information; but an article that I read indicated that standard edition 2008 has no additional benefits over 2005. The enterprise edition does have newer features however. I wanted to provide a link to that article; but I couldn’t find it. I’ll add to the discussion if I find it.

************ technochic
Here is an excellent article about <a href=”http://technet.microsoft.com/en-us/magazine/cc434690.aspx”>SQL 2008.</a>

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Dreid03
    The overall performance in the SQL Server 2008 database engine has improved with some of the new features specific to Enterprise Edition. However I would probably look at it slightly different and compare the editions of Analysis Services. As your business use Analysis Services you may the improvments, to your advantage and perhaps this may be the deciding factor.
    10 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following