A SQL Server Express database hit the 10GB limit. I cleared a lot of orders over a certain age. Is this cleared space available for other tables in the same database? I don’t need to reduce the database file itself, I don’t mind having allocated the 10GB, as I’d rather be out of space for other files than out of space for the database.
Do I need to release empty space in tables to be used for other tables?