hii, I want to know why sql server database storage is exceeded to 5 times of data.
e.g. Version: SQL Server 2008 R2 Following things I have done: 1. Create test DB 2. Create test table with single column varchar(10) 3. Inserts approx 1,50,000 rows of 5 chars (i.e. 'ABCDE') 4. Now as per my knowledge a row contains 5 bytes of data 5. So the size of DB would be 5 bytes * 1,50,000 rows = 0.71 MB or may be 1 MB 6. But when I check the size of DB it shows near 5 MB !!! This is strange for me. How it happen ? where it used additional 4 MB. Is there any setting to free up 4 MB ? Pls reply soon. Thanks -- You received this message because you are subscribed to the Google Groups "DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web Services,.NET Remoting" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/dotnetdevelopment?hl=en?hl=en or visit the group website at http://megasolutions.net
