tag:blogger.com,1999:blog-5849265.post116333510870194984..comments2023-10-29T20:45:15.971+05:30Comments on Vadivel's blog: Different Types of Partitioning Operations in SQL Server 2005Vadivelhttp://www.blogger.com/profile/13387133927257826888noreply@blogger.comBlogger9125tag:blogger.com,1999:blog-5849265.post-86509149591728514042008-07-28T20:20:00.000+05:302008-07-28T20:20:00.000+05:30Hello.Taking your demo further, how can I switch i...Hello.<BR/><BR/>Taking your demo further, how can I switch in data into partition #3 which you already switched out. I have been trying to do just that but it is coming up with different error messages. The staging table I have from which I am trying to pull data has same structure with regard to fields, constraint, index, etc. However, it is just not working out.<BR/><BR/>Thanks,<BR/><BR/>shaht.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5849265.post-42709845931382189112008-03-13T05:58:00.000+05:302008-03-13T05:58:00.000+05:30Hello!This was a wonderful post. I would like to a...Hello!<BR/><BR/>This was a wonderful post. I would like to add that in the switch partition, if the source table had a clustered index created on it then the staging table must also have the same.<BR/><BR/>Thanks,<BR/>GBM<BR/><BR/>Also, other helpful post was:<BR/>http://www.sqlskills.com/blogs/kimberly/PermaLink.aspx?guid=cf223632-c93b-4242-b0f2-af493e051266Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5849265.post-54703236482867125532007-06-19T13:07:00.000+05:302007-06-19T13:07:00.000+05:30Hi Vadivel!Your article is very useful for my anal...Hi Vadivel!<BR/>Your article is very useful for my analysis. Thank you very much.<BR/><BR/>Cheers!<BR/>Jako Vijay.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5849265.post-1168428947950799672007-01-10T17:05:00.000+05:302007-01-10T17:05:00.000+05:30Hi there,Amazing....!You are providing great help ...Hi there,<BR/>Amazing....!<BR/><BR/>You are providing great help to the SQL community.<BR/><BR/>Thanks.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5849265.post-1168349318604781942007-01-09T18:58:00.000+05:302007-01-09T18:58:00.000+05:30Thank you for explaining partitions whith a helpfu...Thank you for explaining partitions whith a helpful example.Can you also put some lights on list partition in the same fashion?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5849265.post-1166165568056973342006-12-15T12:22:00.000+05:302006-12-15T12:22:00.000+05:30Hi,Your article is really useful for us. How to pa...Hi,<BR/><BR/>Your article is really useful for us. How to partition the existing table with relationship keeping the partition key as the column dtCreaion(datetime) and the primary key as ID(Int).Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5849265.post-1164901331499559402006-11-30T21:12:00.000+05:302006-11-30T21:12:00.000+05:30Hi,Why No posts for a looong time ?? :)Hi,<BR/>Why No posts for a looong time ?? <BR/>:)Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5849265.post-1164615352197142932006-11-27T13:45:00.000+05:302006-11-27T13:45:00.000+05:30Hi! We are Eagerly Awaiting your Next Post.....Hi! <BR/>We are Eagerly Awaiting your Next Post.....Gauravhttps://www.blogger.com/profile/00640966274225668859noreply@blogger.comtag:blogger.com,1999:blog-5849265.post-1163522951005828962006-11-14T22:19:00.000+05:302006-11-14T22:19:00.000+05:30good article please join us at sqlcon we need yo...good article please join us at sqlcon we need your expertise there as well<BR/><BR/>just send an email to sqlcon-subscribe@yahoogroups.comAnilhttps://www.blogger.com/profile/13015926757239162956noreply@blogger.com