Post reply

Partitioning

  • July 15, 2008 at 10:24 am

    #193908

    Hi,

    I would like to know if it is possible to partition a datafile within sql server 2000. I am familiar with partitioning tables. But I would like to partition my datafile based on the system date. I am obviously new to this role as a DBA, but I would appreciate any help anyone can give me.

    Thanks in advance,

    Erik

  • July 15, 2008 at 11:02 am

    #843259

    Not sure what you mean about partitioning a data file based on date, as opposed to partitioning data in tables. The only thing in data files is tables.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • July 15, 2008 at 11:35 am

    #843284

    Sorry, let me try to be more clear.

    I want to create partitions on the whole data file not just individual partitions on the tables. I want to be able to partition all of the data within the file in monthly partitions. Kind of like you can do in analysis services on the cubes.

    I hope that clears up my request.

    Erik

  • July 15, 2008 at 11:42 am

    #843291

    You cannot tell SQL Server how to store the data within the data file itself. You can, however, use SQL Server 2005's table partitioning to store each table partition in it's own data file. You can create a data file for each filegroup in your Partition Scheme and you've effectively partitioned your data at the file level.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • July 15, 2008 at 11:47 am

    #843293

    Thanks for the quick response.

    Since my only option is table partitioning, which is fine, can I partition the tables in SQL Server 2000?

  • July 15, 2008 at 12:05 pm

    #843306

    Yes, you can. The keyword here is 'you' because you'll have to do it manually in SQL Server 2000. SQL Server 2005 does it all for you. To partition your tables SQL Server 2000, you'll have to create the filegroups and files and then create seperate tables (with unique names) and bring them together in a view. There is much info on this in books online and on the web. Search through BOL for Partitioned Views.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • July 15, 2008 at 12:10 pm

    #843312

    Thank you for pointing me in the right direction. I sincerely appreciate the knowledge.

Viewing 7 posts - 1 through 7 (of 7 total)

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