Hi Guys
As far as I know, the table is used as an event logging table and is used only used for inserts
Also, I have rebuilt all the indexes (23 in total) and the space used by this table was dramatically decreased, to 20GB.
sidebar When analyzing indexes using sys.dm_db_index_operational_stats. Why does an update statement show an increase in the leaf_update_count column on the Clustered Index and shows an increase in the leaf_insert_count of the nonclustered indexes?
Do update statements cause an Insert on the nonclustered indexes?
Thanks