• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 103
  • Last Modified:

Partitioning a SQL table based on a column in another table

Hello Experts,

I have a very large table with more than 100 million records, which is part of a Data Warehouse System on a SQL Server 2012 Enterprise edition.

I need to partition this table based on a date column, but the date column is stored in another table and both tables are related via a meaningless Primary Key.

Is there any way I can do the partitioning based on the Date column in the other table?

FYI, I made a quick search on the internet, and one solution is to add a redundant date column to the table that needs to be partitioned, but I'm not quite thrilled with this option and I hope there is a better way.

Thanks for your help,
Hani
0
Mehawitchi
Asked:
Mehawitchi
1 Solution
 
Scott PletcherSenior DBACommented:
No other way.  You need to include the date column in your other table as well, denormalizing that date.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now