Examining SQL Server 2016

  • Steve Jones - SSC Editor

    SSC Guru

    Points: 719198

    Comments posted to this topic are about the item Examining SQL Server 2016

  • Gary Varga

    SSC Guru

    Points: 82166

    Currently working in a Oracle shop so working with ANY version of SQL Server would be refreshing (2000 and above if I am truly honest as I can't imagine going back to 7.0).

    I would use some spare time but I am currently refreshing my .NET skills. I have to prioritise otherwise I don't get enough from anything.

    Gaz

    -- Stop your grinnin' and drop your linen...they're everywhere!!!

  • Eric M Russell

    SSC Guru

    Points: 125088

    The addition of primary keys, foreign keys, and non-clustered indexes to Clustered ColumnStore makes it more of a mature candidate for data warehousing tables. Also, our department may be implementing AlwaysOn availability groups for one of our larger enterprise replication servers. The Microsoft guy who came to spend a couple of days training on AG advised us that v2016 has some significant improvements over v2014 and v2012.

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • Jo Pattyn

    SSC-Dedicated

    Points: 31393

    The most exciting part for us is the revamped reporting services and Query Store

  • chrisn-585491

    SSCoach

    Points: 15896

    We're excited that we may see it in shop by 2021, if we can afford the license costs! 😀

    I'm wondering if we will run it on Windows, Linux or Linux in Windows? 😎

  • Eric M Russell

    SSC Guru

    Points: 125088

    Live Query Statistics, the ability view the execution plan of a running query, that just awesome.

    https://msdn.microsoft.com/en-us/library/dn831878.aspx

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply