Live Insert Counts Without Disturbing Running Transaction

There are times long running insert transactions are annoying and we don’t get direct details of running transaction like how many rows inserted and how many are pending. Following query gets estimated rows inserted for the specific table mentioned. SELECT     TableName = t.NAME,    TableSchema = s.Name,    RowCounts = p.rowsFROM     sys.tables tINNER JOIN     sys.schemas s ON t.schema_id = s.schema_idINNER JOIN          sys.indexes i ON t.OBJECT_ID = i.object_idINNER JOIN     sys.partitions p ON i.object_id = p.OBJECT_ID AND i.index_id = p.index_idWHERE     t.is_ms_shipped = 0 and t.name=’Table Name’… Read More