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!

Published 17 January 2008 07:49 by Andy Warren
Filed under: ,

Comments

# re: Partitioning Part 4 Posted on SSC

17 January 2008 10:29 by Don Reinhard

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?

Thanks.

# re: Partitioning Part 4 Posted on SSC

28 January 2008 13:11 by joe

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.