SQL Server 2019 table partitions

Bassam Geagea 40 Reputation points
2023-03-19T16:21:10.21+00:00

Hello,

I have multiples tables and I need to partition them using partition function and partition scheme.

Can i use the same partition function and scheme for all the tables that i want to partition?????

the partition is on daily basis for all tables.

I need to know also if there is any impact in using same partition function and scheme in future regarding management and performance ??

Thanks,

Bassam Geagea

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

0 comments

Answer accepted by question author

Erland Sommarskog 135.6K Reputation points MVP Volunteer Moderator
2023-03-19T17:27:04.53+00:00

You can do use the same partition function/scheme for multiple tables. One advantage is you only need to change one partition function and not many. But the day you want to do SPLIT/MERGE RANGE in a way that it leads to data movement, you may get second thoughts....

Was this answer helpful?

0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-03-20T02:20:41.1833333+00:00

    Hi @Bassam Geagea

    Multiple tables can share the same partition function and partition scheme.

    I think you need to think before you create, as Erland said, there are advantages and disadvantages to using the same partition function and partition architecture.

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.