SQL Server Performance

New feature in SQL 2005 Server

Discussion in 'SQL Server 2005 General Developer Questions' started by SQL2000DBA, Apr 3, 2006.

  1. SQL2000DBA New Member

    Hi,
    I was informed by vendor that there is one feature in SQL 2005, which will allow us to store any form of data i.e. txt,xml,excel etc.. in our database. I wanted to know, do we really have anything more than Text data type in SQL 2005 or any advanced feature to store just type of large data in database.
    Please provide your inputs.

    Thanks and Regards
    Ravi K
  2. satya Moderator

    Yes XML data type is available on SQL server 2005

    The original approach was to store XML documents as character large objects (CLOBs), which requires adding columns containing extracted atomic values or full-text searches to locate specific document instances, nodes, or values. Shredding documents into a set of relational columns is another alternative, but involves complex hierarchical-to-relational mapping. All major players in the relational database management market now have strategies for implementing Part 14 of the ANSI SQL 2003 standard. Part 14, "XML-Related Specifications (SQL/XML)," defines a modified XML Infoset data type that has sets of operators, publishing functions, and rules for mapping SQL to XML components but doesn#%92t support association with an XML schema.


    SQL Server 2005 will enable queries to portions of an XML document, validation of the document against an XML schema, and even modification of the XML document in place. As for the underlying representation, the XML data is stored as a binary large object (BLOB), which enables the database to perform compression whenever possible.

    Refer to the books online for more information and please post thread in relevant forums only.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page