tag:blogger.com,1999:blog-5485181488522668586.post677457669300078298..comments2024-02-21T07:46:27.287-05:00Comments on SQLBalls: Partitioning a HeapBradley Ballhttp://www.blogger.com/profile/08229829101131724200noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-5485181488522668586.post-4273436697482419512012-07-06T10:21:31.275-04:002012-07-06T10:21:31.275-04:00Hi Kevin, I don't think you would want to use ...Hi Kevin, I don't think you would want to use a partitioned heap on a table that you would have insert and update activity on.<br /><br />In an insert/update scenario it would be negative. However I could see partitioning a Heap on a Data Warehouse or some other database if it was large enough and it was read only.<br /><br />This way you could load data only to one partition at a time instead of locking the entire table from read operations while a bulk load occurred, like on a data warehouse.<br /><br />I had originally written this as a way to test and learn what Paul, Grant, Aaron, Amit, and Dave where all talking about. I still have yet to actually partition a heap in production. As I get exposed to more data warehousing and BI client operations I expect that will eventually change.Bradley Ballhttps://www.blogger.com/profile/08229829101131724200noreply@blogger.comtag:blogger.com,1999:blog-5485181488522668586.post-82132388847948942122012-06-28T16:17:56.213-04:002012-06-28T16:17:56.213-04:00Great post!!! I am quesitoning about partition on ...Great post!!! I am quesitoning about partition on heap, here is answer. Thank you for sharing, just wonder how's insert/update impact on partitioned heap vs paritioned table on clustered indexKevin Maohttps://www.blogger.com/profile/10723317717962430296noreply@blogger.com