var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Rebuilding indexes
For normal periodic maintanence, should I rebuilt the indexes each month? Or should I use reorg?
Some 6 Gb database (2 Gb data, 4 Gb indexes)
I have 442 tables with all together some 1200 indexes (clustered and non-clustered) to maintain. Any suggestions?
If all your tables are having datarows or datapage level locking, then its better to use reorg otherwise the std drop and re-create index will do.
I do have all tables in datarow lock scheme. So a reorg can best be used. Thank you very much!