Here is a good script I shamelessly ripped from here:
use [Insert DB Name]
select
a.FILEID,
[FILE_SIZE_MB] =
convert(decimal(12,2),round(a.size/128.000,2)),
[SPACE_USED_MB] =
convert(decimal(12,2),round(fileproperty(a.name, 'SpaceUsed')/128.000,2)),
[FREE_SPACE_MB] =
convert(decimal(12,2),round((a.size-fileproperty(a.name, 'SpaceUsed'))/128.000,2)) ,
NAME = left(a.NAME,15),
FILENAME = left(a.FILENAME,30)
from
dbo.sysfiles a
This is good because it will give you the free space in each DB file (you might have multiple files and perhaps someone set it up to put some objects in each) as well as the free size.
For example, you have have a 4GB data file which has 3GB of free space. Maybe you have 1 MDF without a lot of data but a NDF with lots of data. This query will tell you the free size in each file and what DB that file is allocated to. Remember to add up all the 'SPACE_USED_MB' for each DB to get the total size.
Good luck!
Edit:
Removed a unsupported and buggy command that I thought I could get away with posting in here for this query. :(
Do I need to upgrade to SQL Standard Edition?
Our website has been very slow and unreliable lately
Depends.
If your sites are still working then that implies that SQL server hasn't stopped accepting new data. I would expect exceptions along the lines of "Could not allocate space because the '<FG_NAME>' filegroup is full"
if you were hitting the 10Gb limit already.
The 10Gb is per database not per server, so if your 38Gb is from several databases you may not have hit the limit yet. Also it doesn't count transaction log files so you might have massive log files (because your backup and other maintenance plans are not suitable for your recovery model for instance) that are responsible the majority of the space consumed.
Is it expensive to upgrade?
This is not the right place for licensing/pricing information - such information changes regularly so any answer would quickly become obsolete and therefore incorrect. For current absolute prices consult your preferred software dealer(s) or the manufacturer directly. For a view on what is expensive and what isn't consult your accountant!
Would the web hosting company be able to provide us with the license?
Depends. You'll have to ask them that. Some will, some won't. We don't even know what sort of hosting arrangement you have so we wouldn't be able to help even if we were the right people to ask.
Best Answer
No it will not follow, you will be able to utilize the migrated database up until the 10GB limit.
I've written an article on maximizing space savings with regard to SQL Server Express, which may also be of interest to you to help reduce the your periodic data pruning further.
You may also want to consider upgrading again after 2014 to 2017 or 2019 to keep up with the latest advances in SQL Server features, stability, etc.