In SQL Server, the database can be stored in different files and filegroups. If your database is small (100 MB or less), you do not need to worry too much about files and filegroups. But if you have a ...

My allocated SQL Server space is 400MB; however, the DB regular goes beyond that (650MB most recently) and I need to connect to the server using Studio and do a manual shrink on the database.