Get size of tables in SQL Server

TSQL: Generate random string of desired length