SQL Server 2016: It's Just Faster

Play SQL Server 2016: It's Just Faster
Sign in to queue

Description

This week's episode of Data Exposed welcomes back Bob Ward and newcomer Bob Dorr to the show. Bob Ward, Principle PM Architect in the SQL Server group, and Bob Dorr, Principle Software Engineer in the SQL Server group, stop by Data Exposed to talk about the great improvements in SQL Server 2016 to allow it to "just run faster" out of the box. A fantastic discussion in this video sheds light on the process the SQL engineering team went through, the different SQL Server internals they looked at, current hardware architecture, and other areas to see where they could improve the design, fix and upgraded things, and also take advantage of newer hardware to significantly improve the native performance of SQL Server 2016. They provide several examples of things the SQL team looked at and changes they made to significantly improve SQL Server 2016. Great discussion with Bob Ward and Bob Door that truly highlights the deep and tremendous work over the last couple of years and how it has also prepared the SQL team for future versions of SQL Server. Great insight!

 

You can find a whole series of "It Just Runs Faster" blogs by both Bob's here: 

https://aka.ms/bobsql

 

Find information on SQL Server 2016 at:

https://www.microsoft.com/en-us/cloud-platform/sql-server

Tags:

FAST, SQL Server

Embed

Download

The Discussion

  • User profile image
    krushna debashram

    Only moving a SQL 2012 Database to SQL 2016 will it improve the performance or have to do some code level change to get benefit of in memory table?

  • User profile image
    Bob Ward

    Thanks for your comment but I'm not sure I understand your question. If you mean can you just upgrade to SQL Server 2016 and a "normal" table becomes an in-memory table the answer is no but it is not difficult to move your "normal" tables to in-memory tables.

    bw

Add Your 2 Cents