Access your Pro+ Content below.
Pros and cons of SQL Server 2012
This article is part of the May 2012, Vol. 10 issue of SQL Server Insider
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 ...
Access this Pro+ Content for Free!
Features in this issue
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.
News in this issue
SQL Server 2012 is here, and the Apache Hadoop integration is making the biggest wave, according to some users.
One of the strongest versions Microsoft has put out in years, SQL Server 2012 first needs to accomplish a monumental task -- overcome database inertia, industry watchers say.