I play with Ola Hallengren's indexoptimize from inside the a somewhat tailored way The limited by step 3 circumstances towards the weeknight's and certain huge indexes is actually excluded. Those individuals try processed toward Saturdays where it’s simply for from the 8 circumstances. In both windows We create an excellent temp desk regarding analytics you to definitely have been changed, ordered having large modification ratio basic And you will Bullet(CAST(a hundred.0 * sp.modification_stop / sp.rows Since the Quantitative(18,2)),2)>.5 And you may sp.rows>50000 Purchase By the Bullet(CAST(a hundred.0 * sp.modification_avoid / sp.rows Once the Quantitative(18,2)),2) DESC,last_updated Do you really become willing...
