I have a small doubt on how this works. We came to know last night one of our sql databases had bulk load operation done with vendor giving that data of approx 300 GB would be bulk loaded.
Before and after when i checked the space used within database using gui as well as sp spaceused i can hardly see any decrease in unused space as free space has merely went down below 10 Gb.
Also I thought may be ldf, if not mdf and ndf growths but did not find anything there. Please help me understand how this works
database is in full recovery model