WhiteLotus (10/27/2016)
Thanks for the reply . Much appreciated .Only 1 filegroup which is primary and 1 data file
The result of your query is as below ( I cut some information but I feel below are the info that you need)
[font="Courier New"]Type.....SizeMB...........SizeUsedMB.......FreeMB
ROWS.....213198.250000....213197.625000....0.625000
LOG......29620.000000.....951.687500.......28668.312500[/font]
The figures above show you have indeed no free space in the DATA file.
Did you do the INDEX maintenance as Jeff Moden suggested?
Can you (double) check if the rows are indeed deleted? Perhaps the delete statements failed and were rolled back. Please check the number of rows in the tables? Are they what you expect it to be after the removal?
Thinking out-of-the-box: has there been a restore of the database after you have deleted the rows?