SQL Server 2016 RTM feature

Lee John Li 1 Reputation point


Does SQL Server 2016 RTM support Table Partitioning?

Thank you.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
9,739 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Seeya Xi-MSFT 16,246 Reputation points

    Hi @Lee John Li ,

    RTM stands for Release to Manufacturing, which is the original release version of the product.
    Cumulative Update (CU): Cumulative update package, which consists of Hotfixes. CU is released every 8 weeks, so there will be CU1, CU2 ......, etc. Each latest CU version contains Hotfixes from the previous CU. CU is installed based on the original version (RTM) or SP.
    Service Package (SP): SP is the package with the most integrated Hotfixes, which are officially and fully tested. SP is the largest patch file for a SQL Server product release, and is released every 12 to 18 months.
    GDR (General Distribution Release) is different from CU in that each latest CU contains cumulative updates based on RTM/SP, while GDR contains only serious updates. They have the same baseline.
    Each latest CU contains fixes for issues integrated with the previous CU, and each SP contains fixes for issues included in the previous SP. Now look at the picture again.
    So, in order for you not to miss any fixes, I suggest you install the latest SP3 first and patch it with GDR. See this document: KB3177312 - SQL Server 2016 build versions.

    Best regards,

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

  2. Bjoern Peters 8,601 Reputation points MVP

    Hi @Lee John Li

    Yes, Table partitioning is a supported feature in SQL Server 2016 RTM.
    BUT there are some exceptions to this feature... regarding edition and availability of sub-features.
    Best will be to upgrade to the latest version of 2016 or at least to SP1



    0 comments No comments