how much bytes needed in sql server

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
visuvisu (k.visube@.gmail.com) writes:

Quote:

Originally Posted by

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.

Quote:

Originally Posted by

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/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/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" <k.visube@.gmail.comwrote in message
news:1181746030.311842.326400@.o11g2000prd.googlegr oups.com...

Quote:

Originally Posted by

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" <guzma...@.nospam-
online.sbcglobal.netwrote:

Quote:

Originally Posted by

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.vis...@.gmail.comwrote in message
>
news:1181746030.311842.326400@.o11g2000prd.googlegr oups.com...
>
>
>

Quote:

Originally Posted by

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.

>

Quote:

Originally Posted by

Give me a handy solution.

>

Quote:

Originally Posted by

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:

Quote:

Originally Posted by

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/...r/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" <k.visube@.gmail.comwrote in message
news:1181912433.105526.223140@.x35g2000prf.googlegr oups.com...

Quote:

Originally Posted by

On Jun 14, 5:40 pm, "Dan Guzman" <guzma...@.nospam-
online.sbcglobal.netwrote:

Quote:

Originally Posted by

>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.vis...@.gmail.comwrote in message
>>
>news:1181746030.311842.326400@.o11g2000prd.googlegr oups.com...
>>
>>
>>

Quote:

Originally Posted by

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.

>>

Quote:

Originally Posted by

Give me a handy solution.

>>

Quote:

Originally Posted by

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
>

How generate documentation ?

Hi All
I need genrate documentation of SqlServer DB and I heard about programs
which let you genrate documentation including yours comments of fields,
tables etc. to chm file.
Do you know that program and how can I find it ?
Regards
MichalHello,
Please look at this product
AGS SQL Scribe Documentation Builder
www.ag-software.com
kind regards
Greg O
Need to document your databases. Use the first and still the best AGS SQL
Scribe
http://www.ag-software.com
"Michal" <michalb77@.gazeta.pl> wrote in message
news:dfovl8$3g1$1@.nemesis.news.tpi.pl...
> Hi All
> I need genrate documentation of SqlServer DB and I heard about programs
> which let you genrate documentation including yours comments of fields,
> tables etc. to chm file.
> Do you know that program and how can I find it ?
> Regards
> Michal
>
>|||Michal
Another SQL Server documentation tool that may be worth a look is ApexSQL
Doc (http://www.apexsql.com/sql_tools_doc.asp). The documentation is
produced in a searchable CHM (HTML Help Compiled Help File).
- Peter Ward
WARDY IT Solutions
"Michal" wrote:

> Hi All
> I need genrate documentation of SqlServer DB and I heard about programs
> which let you genrate documentation including yours comments of fields,
> tables etc. to chm file.
> Do you know that program and how can I find it ?
> Regards
> Michal
>
>
>|||From what I've seen, auto generated database documentation is of limited
use. By that, I mean that if it gives you a list of each object and what
objects are related to it, then it is really nothing that can't be seen
directly in Enterprise Manager or queried from Query Analyzer. Also, not all
databases use referentual integrity constraints, so the application cannot
determine how the objects are related. However, it may be useful for the
purpose of system metrics.
"Michal" <michalb77@.gazeta.pl> wrote in message
news:dfovl8$3g1$1@.nemesis.news.tpi.pl...
> Hi All
> I need genrate documentation of SqlServer DB and I heard about programs
> which let you genrate documentation including yours comments of fields,
> tables etc. to chm file.
> Do you know that program and how can I find it ?
> Regards
> Michal
>
>