Post reply

Using BLOB in SQL Server 2005

  • October 4, 2006 at 2:29 pm

    #69252

    Hello!
     
        I am doing initial research on usage of BLOB datatypes in SQL Server 2005. I was wondering if anyone can tell me what major improvements have been made in terms of performance, easy of use in regards to BLOB data types in SQL Server 2005. Will it be more efficient to use other alternatives, such as VARCHAR(MAX) and VARBINARY(MAX)  in terms of storage,performance, etc. Are there any comparison benchmarks? I would like to present some numbers to my boss when comparing BLOB with other approaches.
     
       Any help is greatly appreciated.
     
      Igor

  • October 6, 2006 at 7:45 am

    #664596

    According to MS, "ntext, text, and image data types will be removed in a future version of Microsoft SQL Server. Avoid using these data types in new development work, and plan to modify applications that currently use them. Use nvarchar(max), varchar(max), and varbinary(max) instead"

    So we don't have choice here.

    varchar(max) , nvarchar(max) etc are easier to use than BLOB, actually they can be used in the same way as nvarchar(n), n is a number.

    In terms of performance, I don't see any benchmark. But they should be comparable if not better I guess.

     

     

  • October 6, 2006 at 12:25 pm

    #664665

    Thank you, peterhe!

    Igor

     

Viewing 3 posts - 1 through 2 (of 2 total)

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