SQLServerProgrammability
74 TopicsXML Data Type Limitations
First published on MSDN on May 23, 2006 I'd like to take some time today to explain some of the seemingly arbitrary limits placed on the XML data type, specifically those related to ID/IDREF validation, complex XML Schema types, the depth limit for XML data, and the enigmatic "XSD schema too complex" error.4.1KViews0likes1CommentSQL Server 2005 / 2008 table partitioning : Important things to consider when switching-out partitions.
First published on MSDN on Apr 10, 2009 An ISV recently found an anomoly in their implementation of a "drop table partition" function which could lead to unexpected partitions being switched out.1.1KViews0likes0Comments