I use columnstore indexes on SQL 2014. What would be the advantages of upgrading to SQL 2016?

I use columnstore indexes on SQL 2014. What would be the advantages of upgrading to SQL 2016?

SQL Server 2016 really represents a drastic change for the better in regards to general performance. And the proof is that, thanks to the engine changes, this is the first SQL Server version where Microsoft actively provides a widespread increase in performance levels by simply upgrading. But what impact can it have in your daily loads if you use columnstore indexes in SQL server 2014 datawarehouse? There was already an amazing increase in performance levels with SQL Server 2014 and the columnstore indexes. Is it worth upgrading to SQL 2016? (more…)

SQL Server 2014– In-Memory OLTP for insert performance (1/3)

SQL Server 2014– In-Memory OLTP for insert performance (1/3)

SQL Server 2014 has been released last week, isn’t that great? Sure it is! But what’s in it for you? should you run to your CTO to get the upgrade budget right now? Do you start building the new servers immediately? Are you one of those people that wait for service pack <fill in> before you consider going to production? To make the right decision, you need to make sure the value proposition of the upgrade is worthwhile and will give you a positive return. In the next few blog posts, we will cover some of the exciting new technologies that SQL Server 2014 has to offer, what bottlenecks they were designed to solve, and provide general guidelines regarding their actual benefit and where these might be a good fit. (more…)