Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

SQLAndy

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.

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!

Comments

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?

Thanks.

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.