This query helps you identify your tables and calculate size/rowcount ratio easily: USE [DatabaseName] -- replace your GO SELECT s.Name […]
Assume that all we know why we are using IDENTITY column in a table. It you are inserting any row […]