How do I determine the size of a SQL Server database?

How do you find the size of a database?

To check the sizes of all of your databases, at the mysql> prompt type the following command: Copy SELECT table_schema AS "Database", ROUND(SUM(data_length + index_length) / 1024 / 1024, 2) AS "Size (MB)" FROM information_schema.

How do I find the database size and free space in SQL Server?

Get a list of databases file with size and free space for a database in SQL Server:1SELECT DB_NAME() AS DbName,2name AS FileName,3size/128.0 AS CurrentSizeMB,4size/128.0 - CAST(FILEPROPERTY(name, 'SpaceUsed') AS INT)/128.0 AS FreeSpaceMB.5FROM sys. database_files.6WHERE type IN (0,1);How to determine free space and file size for SQL Server databases

What is the default size of an SQL Server database?

When you create a database, the default size is 8MB. The autogrowth setting is 64MB at a time with unlimited growth (SQL Server 2016). By the way, the initial size and autogrowth settings are not the same between SQL Server versions. You can see this in the SQL Server 2016 and SQL Server 2008 R2 screenshots below.