SQL Server: Schema Discovery Without Admin Access
Querying sys.* catalog views to map schemas, tables, columns and datatypes; getting row counts without a full scan; and using SET STATISTICS as a stand-in for an execution plan you cannot open in SSMS.
Updated sqlsql-serverdatabasecheatsheet
Alex Garbiak