Hi ,

Any one tell me how calculate the Size of the row?.

regards

Praveen (apveen@gmail.com) writes:
> Any one tell me how calculate the Size of the row?.

In Books Online, look at the topic
Creating and Maintaining Databases
Databases
Estimating the Size of a Database

This applies to SQL 2000. If you are using SQL 2005, you will have to
search Books Online for "row size" yourself. :-)

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

For SQL 2005, lookup 'calculating database size' in the BOL index - I
rewrote the topic for 2005 to make it more understandable.

--
Paul Randal
Lead Program Manager, Microsoft SQL Server Storage Engine
http://blogs.msdn.com/sqlserverstora...e/default.aspx

This posting is provided "AS IS" with no warranties, and confers no rights.

"Erland Sommarskog" <esquel@sommarskog.se> wrote in message
news:Xns98016DDD752Yazorman@127.0.0.1...
> Praveen (apveen@gmail.com) writes:
>> Any one tell me how calculate the Size of the row?.
>
> In Books Online, look at the topic
> Creating and Maintaining Databases
> Databases
> Estimating the Size of a Database
>
> This applies to SQL 2000. If you are using SQL 2005, you will have to
> search Books Online for "row size" yourself. :-)
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/pro...ads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinf...ons/books.mspx