Changes to a Writable Partition May Fail Unexpectedly

(Paul White) If you use table partitioning with one or more partitions stored on a read-only filegroup, SQL update and delete statements may fail with an error. Of course, this is the expected behaviour if any of the modifications would require writing to a read-only filegroup; however it is also po

Read More - Register for Free Membership