Changes to a Writable Partition May Fail Unexpectedly

SQLPerformance.com

Published On: March 22, 2016

Categories: T SQL, Query Plan Analysis 0

Paul White (@SQL_Kiwi) shows how an update may fail when a partition has some data on a read-only filegroup, and explains several workarounds.

Continue reading...

SQLPerformance.com is about providing innovative and practical solutions for improving SQL Server performance. Whether you are running a 3rd party application database where very little can be changed, or you are a DBA at a site where getting the application developers to change anything is next to impossible, industry experts including Paul Randal, Jonathan Kehayias, Erin Stellato and Paul White will cover both the "how" and the "why."


Comments

SentryOne Monitor Ad