SQL Server跟踪每一列的修改计数(二)

UPDATE STATISTICSt1;
GO

UPDATE t1 SET c1= 7;
UPDATE t1 SET c1 = 8;
UPDATE t1 SET c2 = 4;
UPDATE t1 SET c2 = 5;
UPDATE t1 SET c2 = 6;
UPDATE t1 SET c2 = 7;
CHECKPOINT;
GO

object_id  index_id    rscolid     rcmodified
———–         ———–      ———–         ——————–
277576027     0          1           6
277576027     0          2           9
277576027     0          3           2
277576027     2          1           0
277576027     2          2           0
277576027     2          3           0
277576027     3          1           0
277576027     3          2           0

name            rowmodctr
—————-             ———–
NULL               9
t1_c1_c2           2
t1_c3              0