|  | Posted by Dan Guzman on 06/14/07 12:40 
To add on to Erland's response, see the Books Online for topics on estimating table and index size.  In addition to the storage requirements of
 individual columns, you'll need to add additional overhead for row, page,
 etc.
 
 --
 Hope this helps.
 
 Dan Guzman
 SQL Server MVP
 
 "visu" <k.visube@gmail.com> wrote in message
 news:1181746030.311842.326400@o11g2000prd.googlegroups.com...
 > Hi i want to know how much bytes will sql server take to store a
 > single alphabet like  "a". i need to know similarly for all data types
 > (including images).here i am doing a application where i need to
 > predict the amount of space required in sql server to store the user
 > fed dynamic data.
 >
 > Give me a handy  solution.
 >
 > Regards
 > visu
 >
  Navigation: [Reply to this message] |