SQL Server XML Typed Column Size variance
In Sql server if we create a xml column with a schema associated to it (typed XML) will this help开发者_开发问答 in reducing the space required to store the actual data.
Example if i create 2 tables with XML column considering the data is same in both the tables one table is created with typed xml and other with untyped xml will there be any difference in space occupied by the tables ???.
The answer to this question depends on the particular datatypes and schema involved, apparently. This conversation has more details for you.
精彩评论