To determine size of table in a database or size of database, we have simple syntax in SQL Server which is SP_SPACEUSED. Syntax is simple enough as shown below 1) If we want to determine size of the database then we have to write below statement and execute Use DatabaseName GO SP_SPACEUSED GO 2) …