• SQL Server Management Studio is a tool that allows you to manage SQL Server databases.
• To enlarge the size of a database, connect to an instance of the SQL Server Database Engine in Object Explorer and then expand that instance.
• Expand Databases, right-click the database you want to expand, and then select Properties from the drop-down menu.
• Select the Files page in Database Properties.
• Increase the value in the Initial Size (MB) column for an existing file to increase its size. You must expand the database's size by at least one megabyte.
• To expand the database's size by adding a new file, click Add and then enter the new file's values. See Add Data or Log Files to a Database for further details.
• Click the OK button.

Read More: What are joins in MS Access?