'Different size of files on the disk and in MS SQL database
As an exercise I've inserted some image files into MS SQL database. They are occupying approx. 3.9GB on disk but when I look at data increase from storage size on volume where database is located I see increase of 1008MiB only. Can someone explain why it's like that? I have actually no experience in SQL and this test with SQL was just to test storage under the database, not db itself.
This is how I insert images:
insert into graphics (id, picture) SELECT '9974', BulkColumn FROM Openrowset( Bulk 'F:\dist\img_1643140662.349239.jpg', Single_Blob) as picture
When looking at database space usage with SQL queries I see that database grown by 985MB.
On the other hand table size is over 1GB... (before insert it was 0KB)
Can someone please explain this in simple words why there is different info in each place?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|