MS SQL Server 2008 R2 vs 2012 Version

sglee
sglee used Ask the Experts™
on
Hi,
 
 I would like to know if there are significant differences between 2008R2 and 2012 SQL server Standard version.
 We have less than 20 users and 2008R2 is much cheaper than 2012 in purchasing cost.

Thank you.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
here is a nice list stating the diferences between the two

https://www.cdw.com/content/software/microsoft/sql-2012/sql-compare.html

differences list

Author

Commented:
One thing that I see is that if you get a single CPU with 4-6 core, it does not matter in SQL 2008 because they go by number of CPUs where as in SQL 2012, you will pay a lot more because it goes by each core? Am I right?

If there is anyone out there who actually used 2008 version and migrated to 2012, is there a noticeable difference in terms of performance?
1. yes

2. nothing really performance wise
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Author

Commented:
Thank you. I think I will save money by going with SQL 2008 R2 Standard version.
your very welcome :)

enjoy your weekend and reward me points.. woohoo more free t-shirts :)

Author

Commented:
You do the same and here are the points.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial