Post reply

SQL Server data storage type

  • July 18, 2012 at 12:58 am

    #264007

    Hi All,

    What is the storage type for data in SQL Server?

    I found that the MongoDB is using JSON/BSON for data storing, like this what is the storage type for SQL Server.

    Thanks,

    🙂

  • July 18, 2012 at 1:14 am

    #1514029

    Storage type?

    SQL stores data in binary form within the data pages.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • July 18, 2012 at 2:24 am

    #1514066

    Thank you,

    How sql server converts the stored binary information to actual data? Which component of the sql server do this task?

    Thanks,

    🙂

  • July 18, 2012 at 2:34 am

    #1514068

    The binary information is the actual data.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • July 18, 2012 at 2:41 am

    #1514072

    Thanks for you quick reply,

    Suppose when i execute a query (and actual data was entered in English and it was stored as binary data) it will give the result in English (Internally SQL server will convert that binary to English). Which component of the server is converting?

    Thanks,

    🙂

  • July 18, 2012 at 2:49 am

    #1514075

    To be honest, that'll be the client tool, whatever you are using to type in, execute and then read the query results.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • July 18, 2012 at 10:25 am

    #1514343

    Mongo DB provides a JSON/BSON interface to issue commands to retrieve and store data.

    Microsoft SQL Server provides a T-SQL interface to do the same. T-SQL stands for Transact-SQL and is based on ISO and ANSI SQL language standards plus some proprietary Microsoft syntax extensions.

    You connect to a SQL Server Instance using a driver (e.g. Microsoft SQL Server Native Client ODBC Driver, jTDS, FreeTDS, etc.) and send batches of T-SQL (a batch is a collection of one or more T-SQL statements) to the SQL Server database instance on that connection to retrieve or store data.

    Hopefully that helps.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply