how to identify the sql server edition

select serverproperty('edition')

The result will look something like:

32-bit: Enterprise Edition

64-bit: Developer Edition (64-bit)

Determine Size of a Table in SQL Server

sp_spaceused ‘Tablename’