This query helps you identify your tables and calculate size/rowcount ratio easily: USE [DatabaseName] -- replace your GO SELECTs.NameASSchemaName,t.NameASTableName,p.rowsASRowCounts,CAST(ROUND((SUM(a.used_pages) / […]
Assume that all we know why we are using IDENTITY column in a table. It you are inserting any row […]