On Thu, Sep 29, 2011 at 11:22 PM, Ronak <[email protected]> wrote: > 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 ? -----------------------------
Because that is the way SQL Server operates. <http://thesqlagentman.com/2010/06/top-13-sql-server-mistakes-and-missteps-10-default-database-autogrowth-settings/> If you worry about the 4 meg you are using the wrong container. -- Stephen Russell 901.246-0159 cell -- 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
