Posted by Paul S Randal [MS] on 07/15/06 18:23

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

[Back to original message]