locked
SQL Varbinary(Max) storage RRS feed

  • Question

  • Hello,

    I am planning to use Varbinary(max) in SQL server 2008 R2 for the images in my Application. But the question is how much of images or storage in GB can SQL handle? There's THOUSANDS of images that will be inserted into SQL, and the size of each image is no more than 500 KB. I can't use filestream because i am planning to have database mirroring. There's no article on the internet that talks about the maximum storage.

    Please advice,

    Thanks in advance,

    Thursday, January 27, 2011 12:14 PM

Answers

  • maximum storage depends on your disk space capacity..as  your table will be growing pretty fast....

    A varbinary(MAX) column that is less than 8000 bytes, but that won't fit
     within the row is stored on LOB pages, not row-overflow


    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    • Marked as answer by Sadirov Monday, January 31, 2011 10:04 AM
    Thursday, January 27, 2011 12:24 PM
    Answerer
  • maximum database size is : 524,272 TeraBytes....       

     

    http://msdn.microsoft.com/en-us/library/ms143432.aspx


    Vishal Gajjar
    • Marked as answer by Sadirov Monday, January 31, 2011 10:04 AM
    Thursday, January 27, 2011 12:52 PM

All replies

  • maximum storage depends on your disk space capacity..as  your table will be growing pretty fast....

    A varbinary(MAX) column that is less than 8000 bytes, but that won't fit
     within the row is stored on LOB pages, not row-overflow


    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    • Marked as answer by Sadirov Monday, January 31, 2011 10:04 AM
    Thursday, January 27, 2011 12:24 PM
    Answerer
  • maximum database size is : 524,272 TeraBytes....       

     

    http://msdn.microsoft.com/en-us/library/ms143432.aspx


    Vishal Gajjar
    • Marked as answer by Sadirov Monday, January 31, 2011 10:04 AM
    Thursday, January 27, 2011 12:52 PM
  • Dear Uri,

    Thanks for your reply.

    Could you please explain what do you mean by " A varbinary(MAX) column that is less than 8000 bytes, but that won't fit
     within the row is stored on LOB pages, not row-overflow"

    I didn't get it, i am able to store an image size about 500 KB inside a varbinary(MAX) field. And when the overflow will happen?

     

    Dear Vishal, thank you for the info.

     

    Regards,

    Thursday, January 27, 2011 5:51 PM