title: How to reduce mdf and ldf size through statistics in sql server 2005/2008
body: <p>i have an issue, that is i found my <strong>mdf size:13 GB</strong> and <strong>ldf size:96 GB</strong> ,i deleted all the records from the database tables to reduce size in mdf as well as ldf,i did <strong>use DATA_AQUA
  go
  exec sp_updatestats
  go also</strong> even though the <strong>DBCC SHOW_STATISTICS</strong> command gives null values,
  my expectation is i deleted all records but it should show the size less but it is still showing old size, how to resolve this please help me on this.</p>