I just did this: Delete FROM MyTable WHERE ScopeValue = "" Delete FROM G_Scope WHERE ScopeValue is '' Delete FROM G_Scope WHERE ScopeValue = empty Delete FROM G_Scope WHERE ScopeValue is empty ...

I try to understand how SQL Server 2008 store xml columns in an attempt to estimate table size in our product. I'm using DATALENGTH(xml_column) to run some test and results are disturbing : Xml d...

I would like to use SQL Server xml type as a column type for an entity class. According to this thread it's possible to map such a column to string type: public class XmlEntity { public int Id {...

Is it possible to use Sql Server XML columns as a substitute for a real Document DB (such as Couch or Mongo) ? If I were to create a table with a guid PK Id and an XML column for the document. Wha...