I have a DB which is reporting the following.
The Primary File where I have the Tables is 143670656 KB.
The Indexes are in their own FG's..
What I can't understand is when I run sp_spaceused on all tables it adds up to about 80gb. taking the unused space into AC I'm still 'missing' 31 gb .
If rebuilt all the Indexes. I've ran dbcc updateusage
Is there anything I'm missing.
It's driving me nuts !!!
I'll answer it myself ,
name rows reserved data index_size unused sysxmitqueue 282 72141880 KB 72141792 KB 32 KB 56 KB
answered Jul 13, 2017 at 12:34 PM