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,134 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Olaf Helper 42,576 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 No 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 No comments