Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2008 Forums  Transact-SQL (2008)  Dynamic Partitioning

Author  Topic  gady.hp Starting Member 3 Posts Posted - 2010-04-13 : 09:52:03 Hi, I am newbie to SQL server and I would appreciate if you could assist me with the following: I have a question regarding dynamic partition. Let say I have the following: I need to store sentences from books in the following table: book_id (int) - name of the book page_id (int) - the page number sentence_id (int) - some temporary id (for example, the first sentence in each page will get id 1 and so on) sentence (varchar) primary key(book_id, page_id, sentence_id) As you can see the table can be divied to different partition based on the book_id How do I create a new partiton dynamically in the table for each book_id. I would apprecaite if you can also give me a code sample on how to do that. Thanks, Gady