Ask a Question
Ask Question Login
Corporate Training
  1. Community
  2. SQL Server
  3. Question
SQL Server

Does SQL Server 2016 Standard Edition support table partitioning?

Asked by Anna Ball Jul 31, 2021 2.8K views 1 answer
Share

About this question

I want to upgrade my SQL Server 2008 Enterprise Edition to SQL Server 2016 Standard Edition; however, one database makes use of table partitions over multiple file groups (used on a large logging table, each day is a partition) I see in Editions and Supported Features for SQL Server 2016 under the section "RDBMS Scalability and Performance", that it says that Standard Edition supports Table and index partitioning, but it does not support Partitioned Table Parallelism. I am not sure that I fully understand the consequences of this. What exactly does it mean in my case, and how will it affect the database's performance?

Your answer

1 Answer

More SQL Server discussions

Learn & Explore

Free tutorials and interview questions from industry experts — learn the skill, then get ready to prove it.

Latest SQL Server Blogs

Guides, tips and career advice on SQL Server from JanBask experts.