Table partition for each week
in [Server Configuration]
|
Prev: HOT NEWS FOR EVERYONE!!!
Next: Windows 7 Enterprise x64 + SQL 2008 Enterprise x64 + Oracle Client/Drivers
From: sacgar on 11 Dec 2009 22:57 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!!
From: Jay on 11 Dec 2009 23:32 How many partitions do you currently have? How many hard drives do you have? How many rows will you be inserting each week? "sacgar" <sacgar(a)discussions.microsoft.com> wrote in message news:9F54D0E6-6DF3-4B5A-9F22-81C3BC563D58(a)microsoft.com... > 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!! >
From: Greg Low (MVP) on 13 Dec 2009 02:24 A good resource would be this whitepaper recently published by Microsoft (and written by Ron Talmage from Solid Quality): http://msdn.microsoft.com/en-us/library/dd578580.aspx HTH, Greg "TheSQLGuru" <kgboles(a)earthlink.net> wrote in message news:pfKdnRFYQti_8bzWnZ2dnUVZ_vOdnZ2d(a)earthlink.com... > Note that partitioning is an ADVANCED topic, and you really need to spend > some time/effort knowing what you need and how to best accomplish it or > you will be setting yourself up for some disappointment and/or pain in the > future. Good thing to hire a consultant for a day or two IMHO. > > -- > Kevin G. Boles > Indicium Resources, Inc. > SQL Server MVP > kgboles a earthlink dt net > > > "sacgar" <sacgar(a)discussions.microsoft.com> wrote in message > news:0DCBDA07-7F79-4FAB-A39C-D63B3CCD37E4(a)microsoft.com... >>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!! >> >> > >
From: Hugo Kornelis on 13 Dec 2009 07:28
On Fri, 11 Dec 2009 19:57:01 -0800, sacgar wrote: > 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!! Hi sacgar, You asked the same question two days ago, and you got several good replies. I suggest you read those replies first, then study the information available by following the links you were given. If after that, you need any additional information, you are most welcome to return here and ask your by then more targeted question. -- Hugo Kornelis, SQL Server MVP My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis |