tag:blogger.com,1999:blog-5849265.post116326578431476312..comments2023-10-29T20:45:15.971+05:30Comments on Vadivel's blog: Example for Creating and using Partitions in SQL Server 2005Vadivelhttp://www.blogger.com/profile/13387133927257826888noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-5849265.post-1168539427640724362007-01-11T23:47:00.000+05:302007-01-11T23:47:00.000+05:30Your split partitioning example has helped me alot...Your split partitioning example has helped me alot.<BR/><BR/>There is one problem that I was wondering about.<BR/><BR/>I'm using a modified version of table partitionig where there will no sliding window or merging of partitions. We just keep adding on partitions and file groups based on a monthly date range.<BR/><BR/>With that said I'm a junior programmer, and I have just modified your code a Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5849265.post-1163606911570462862006-11-15T21:38:00.000+05:302006-11-15T21:38:00.000+05:30Thanks!Just a thought regarding your problem:1. Cr...Thanks!<BR/><BR/>Just a thought regarding your problem:<BR/><BR/>1. Create an empty table of similar schema and on the same file group<BR/><BR/>2. Load data to this new table<BR/>3. Use 'Split Partition' to create a new partition<BR/>4. Use 'Switch To' to push records from the new table to the new partition.<BR/><BR/>Hope this helps!Vadivelhttps://www.blogger.com/profile/13387133927257826888noreply@blogger.comtag:blogger.com,1999:blog-5849265.post-1163530507156890312006-11-15T00:25:00.000+05:302006-11-15T00:25:00.000+05:30Great Information Vadivel!I am working with an exi...Great Information Vadivel!<BR/><BR/>I am working with an existing database with large tables and have been searching on the best method of partitioning an exisiting table full of data. I have yet to find info with regards to either altering the table or if you need to create a temp table to load the data, drop existing table, create a new partitioned table and then reload the data.<BR/><BR/>I Anonymousnoreply@blogger.com