I'm using the built in
sp_spaceused stored procedure before and after performing a operation in our software to see which tables have row inserts and how the size of each table changes.
What I'm seeing is that out of all the tables that get rows written to them, only a handful show that the table has increased in side. The others that show rows were added show no change in size from this stored procedure.
The only case this is not true is on the first transaction after performing a truncate on all the tables. So to me it appears that instead on storing duplicate data SQL Server is showing rows are inserted but must be just storing pointers to previous identical rows.
Can anyone confirm this please?