Evening.
Executing "USE MYDB DBCC SHOWFILESTATS" on a SQL 2005 DB shows me:
10682368 TotalExtents
10298044 UsedExtents
The DB in question contains 90% of data in a single table of 1,000,000,000 ish rows.
After 12 hours of a delete process whereby 10% (100,000,00 rows ish) were removed my UsedExtents appears to be more or less the same (few inserts in this time).
-DB is manually grown periodically.
-I never use SHRINK.
I could have sworn in the past this delete process reduced UsedExtents.
Thank you in advance for an explanation.
Scott