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
visu (k.visube@gmail.com) writes:
> Hi i want to know how much bytes will sql server take to store a
> single alphabet like "a".
If you use varchar, that's one byte. If you use nvarchar, it's two bytes.
> 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.
Look up the "Data types" in Books Online. With this as a starting point,
you should be able to find the storeage consumption fo every data type.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downlo ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books .mspx
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"
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
>
On Jun 14, 5:40 pm, "Dan Guzman"
> 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"
>
> 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- Hide quoted text -
>
> - Show quoted text -
thanks for all the replies...
I dont find any useful books in online..
Can u people suggest some useful URL regarding to my problem ?
Regards
visu
visu wrote:
> I dont find any useful books in online..
> Can u people suggest some useful URL regarding to my problem ?
They are referring to what is (perhaps confusingly) named "SQL Server 2005
Books Online", as noted at the end of Erland's message.
http://technet.microsoft.com/en-us/sqlserver/bb428874.aspx
Andrew
In addition to the web URL, the documentation is also available via local
help. One method to find the relevant topic is by entering "estimating
table size" in the index search.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"visu"
news:1181912433.105526.223140@x35g2000prf.googlegroups.com.. .
> On Jun 14, 5:40 pm, "Dan Guzman"
>> 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"
>>
>> 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- Hide quoted text -
>>
>> - Show quoted text -
>
> thanks for all the replies...
>
> I dont find any useful books in online..
> Can u people suggest some useful URL regarding to my problem ?
>
> Regards
> visu
>