If you take a look into sppurge.sql script you can see that "delete" command used. Therefore hwm does't move and storage still allocated. If you really want to deallocate storage - use sptrunc.sql instead. But that will drop 100% statistics data.
|
Results 1 to 2 of 2
Threaded View
|
Click Here to Expand Forum to Full Width |