SQL-Server: sp_spaceused gives zero rows but big dataSize for cleaned table
DELETE does not reclaim space, it deletes rows.

Space can remain allocated for several reasons, 3 of which are:


ghost clean up is still running
the table has no clustered index
the system tables are not updated yet


Try


EXEC sp_spaceused 'MyTable', 'true' to force a space used update
TRUNCATE  TABLE which deallocates space, rather then deleting rows
DELETE  myTABLE WITH (TABLOCKX) if no clustered index and can't use TRUNCATE


Don't run DBCC shrinkdatabase because it adds no value and it will simply grow again