as per point,
1) DB initial size is not huge, it is by default 13 MB .mdf and log file is 10% of mdf.
2) file size growth also same as created, there were no any large size of existing space.
3) yes, but only one table has large value type columns(Text datatype) which has inserted and deleted record log.
but as i said other client production server same applications are running but i did not face such kind issue.
executed by DBCC CLEANTABLE command spaces are available in Database that means its reclaim for memory where ever drop table and column,
but no any alteration in any table.
commented on Aug 18 2012 6:25AM