5 pts.
 SQL Server 2005 or 2008?
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?

Software/Hardware used:
ASKED: December 2, 2008  6:05 PM
UPDATED: December 8, 2008  3:31 PM

Answer Wiki:
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>
Last Wiki Answer Submitted:  December 4, 2008  5:19 pm  by  Randym   1,740 pts.
All Answer Wiki Contributors:  Randym   1,740 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _


 

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 pts.