How to check SQL Server Database size

1) Open "Microsoft SQL Server Management Studio Express"
2) Open "New Query" window
3) Fire below query to select database whose size we want to check
     use {database name};
4) Execute above command via pressing "f5"
5) So far, we have selected database whose size we want to check.
6) Fire below query to get size
            "    SELECT
              database_name = DB_NAME(database_id)
            , log_size_mb = CAST(SUM(CASE WHEN type_desc = 'LOG' THEN size END) * 8. / 1024 AS DECIMAL(8,2))
            , row_size_mb = CAST(SUM(CASE WHEN type_desc = 'ROWS' THEN size END) * 8. / 1024 AS DECIMAL(8,2))
            , total_size_mb = CAST(SUM(size) * 8. / 1024 AS DECIMAL(8,2))
            FROM sys.master_files WITH(NOWAIT)
            WHERE database_id = DB_ID() -- for current db
            GROUP BY database_id"
6) You will see result in below format
    "database_name" : "log_size_mb" : "row_size_mb" : "total_size_mb"

Cheers!
Henal Saraiya