Posted by Erland Sommarskog on 06/13/07 22:08

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/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: Deadlock within stored procedure - need help
• Prev in forum: Re: Establishing Precedence In ORDERBY Condition Causing Problems.
• Thread view: Re: how much bytes needed in sql server

[Reply to this message]