|
by mssqlisv via SQL Programmability & API Development Team Blog on 5/18/2009 8:57:00 PM
Recently I worked with a partner who was seeing some interesting behavior. Upon rebuilding their indexes they noticed that the total space used by all indexes increased significantly. The table has no clustered index but does have a total of nine non-clustered indexes.
The sequence of events is as follows:
ยท Step 1: Approximately 12 million rows are inserted into an existing table via some batch loading of the data.
... [ read more ]
|
