Share via

I'm curious about the scope of partitioning in the MSSQL program

아름 정 0 Reputation points
2023-04-25T06:32:53.7066667+00:00

Hello
I am a student studying DB such as Oracle and MSSQL. I understand that MSSQL supports Range Partitioning. I would like to ask if MSSQL can use Hash, List, Composite, Round Robin, and Interval Partitioning

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,364 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 43,331 Reputation points
    2023-04-25T07:33:00.2233333+00:00

    Hash, List, Composite, Round Robin, and Interval Partitioning

    Not really one of them. Partitioning is done by the table data, e.g. one could create a partition per year, base on a date column. See Partitioned tables and indexes

    0 comments
  2. PercyTang-MSFT 12,426 Reputation points Microsoft Vendor
    2023-04-26T05:53:35.2633333+00:00

    Hi @아름 정

    In addition to the above answer, you can also refer to these two posts.

    https://www.sqlshack.com/partitions-in-sql-server/

    https://www.sqlshack.com/database-table-partitioning-sql-server/

    Best regards,

    Percy Tang

    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