SQL Server 2016 May update
SQL Server 2016 SP1 is better. Why? It is more efficient, quicker, thus more economical. How? Thanks to row compression, your SQL Server database requires less storage capacity to execute the same processes. This allows it to be faster than before.
Besides that, in-memory tables, one of the new features, ensure that your data is processed, inside the memory. This means that you no longer require saving on your drives, decreasing the memory work load, again resulting in more efficient and faster use and processing of your data. This eventually leads to your enhancing your productivity and SQL Server environment.
Subject: SQL Server 2016 May update
For: DBAs, developers, IT management, system engineers, …
Topics:
Standard vs enterprise edition
Column store index
Row compression
In-memory tables
Partitioning
12 May 2017
