Premium Content

Access "Pros and cons of SQL Server 2012"

Published: 13 Oct 2012

More on SQL Server 2012 Check out our SQL Server 2012 guide What you need to know about SQL Server 2012 Looking at column-store indexes in SQL Server 2012 Another even-numbered year brings another new version of SQL Server to consider. Microsoft has already doing a good job of communicating why it thinks you should upgrade, but their reasons are largely based on features. The other side to the upgrade story has less to do with features and more to do with your business. So let’s consider some of the non-feature-related pros and cons behind a SQL Server 2012 upgrade: Pro: Performance. Whether they advertise it a lot or not, Microsoft invests heavily in SQL Server’s core database engine in every new version. Back in the old days, a nine-table join was a recipe for disaster; now it’s no big deal. The same holds true for SQL Server 2012: You can expect better overall performance when compared side-by-side to older versions, and “better performance” is always a reason to consider an upgrade. Con: Changes. This new version of SQL Server brings some significant ... Access >>>

Access TechTarget
Premium Content for Free.

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

What's Inside

Features
    • Pros and cons of SQL Server 2012 by Don Jones, Contributor

      Performance and support top the lists of pros for going to SQL Server 2012. But application compatibility and “the unknown” might keep you away for now.

More Premium Content Accessible For Free