Many time it happens we were wrong with the Estimation of Table Size, wrong estimation of Row Size can trouble us with the growth of the database and ultimately we are ending up with the space crunch, and all this because of wrong Estimation of Table Size. So what we should consider the most with Estimating Table Sizing!!! Nullbitmap is the most important criteria here to take into consideration whenever you do a Estimation of Row Size, here is an excellent article on Row Size Estimation http://msdn2.microsoft.com/en-us/library/aa933068(SQL.80).aspx and http://msdn.microsoft.com/en-us/library/ms175991.aspx
05 October 2007
Estimating the size of Table
10/05/2007
calculate table size, estimate table size, estimating table size, Estimating the size of Table, Estimating the size of Table in sql server, MS Sql server, null bitmap, row size estimation
No comments
About Author:
Hemantgiri S. Goswami is a SQL Server consultant based in Surat, INDIA. He is an active community member, moderator and author of book SQL Server 2008 High Availability








0 comments:
Post a Comment