Table partition for each week

Question

Table partition for each week

sqlquery-101401

SSCarpal Tunnel

Points: 4951
More actions
December 9, 2009 at 7:48 pm

#207336

I am looking to partition my table for 52 weeks (Per week) , could you please help the best way to achieve that in SQL 2005/2008?
Thanks!!

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1004363 More actions · Answer 1

sqlquery-101401 (12/9/2009)
I am looking to partition my table for 52 weeks (Per week)

Sure... let's start off by asking the single most important question about this... Why? Knowing "why" may help us give you the correct recommendation.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

SQLRNNR SSC Guru Points: 281334 More actions · Answer 2

In addition to the why that Jeff posted, are you really sure you want to do this? 52 partitions for one table, have you considered the implications - what about subsequent years? Administration? Hardware?

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

sqlquery-101401 SSCarpal Tunnel Points: 4951 More actions · Answer 3

thanks for your reply ,the ask is weekly archival process , as of now we are in testing phase and considering all the negative points pointed out before we implement the soln, here i am just looking the way to achieve that ,we may not consider the soln or may land to Monthly but we want to test that our.

Thanks.