Have a client whose SQL Server 2008 (Express) DB is very close to the 10GB hard limit. Upgrading to Full SQL Server is not an option.
I have told them we need to remove some data, and that it is likely that the photos that are stored with each contact are the issue. However they refuse to remove data unless I can prove that will resolve the issue (and even then I am not sure if they will do it)
I have confirmed with SSMS that the table containing the photos is 9.8GB but as it also holds all the other relevant contact data I can't prove it is the photos.
This is a commercial program so I can't alter any of the DB tables etc.
Is there an SQL command I can use to show the total size (MB,GB) of all the data stored in a column in a table so I can prove it is the photos?