SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Partitioning Part 4 Posted on SSC

Partitioning Part 4 concludes the series with a look at 'real' partitioning in SQL 2005 Enterprise Edition. Overall the series worked out reasonably well, accomplished my goal of introducing the technology and options without getting into dense technical detail. There is definitely more to explore in partioning than I've covered!


I'm Andy Warren, currently a SQL Server trainer with End to End Training. Over the past few years I've been a developer, DBA, and IT Director. I was one of the original founders of SQLServerCentral.com and helped grow that community from zero to about 300k members before deciding to move on to other ventures.


Posted by Don Reinhard on 17 January 2008

Great Article!

Just wondering if there is a way to create the partitioning function with a dynamic calculation rather than a static list of dates?


Posted by joe on 28 January 2008

I agree about the article. It is very interesting an I would like to try it.

Is their a way to partition a table using a column from a table that we have a foreign key relationship with. We would want to partition both tables using the store_no values. That column can only be found on the orders table.

Orders (orderid int, store_no int, data etc)

OrderDetail (orderid int, data etc)

Is there a way to do this for the OrderDetail since it does not have this column? I was originally thinking of some sort of computed column or do we need to add the Store_no column to the OrderDetail.

Leave a Comment

Please register or log in to leave a comment.