zi (12/30/2012)

---

Thanks for replying

Do you have a script to know the fragmentation size for the whole database not only table by table.

Thanks lot

GilaMonster (12/26/2012)

---

zi (12/26/2012)

---

1-1-How to know the fragmentation size for whole database not only for certain table, to decide if it exexceeds 30% to re-build index or re-organise.

Databases don't have fragmentation. Indexes do. Talking about the fragmentation level of an entire DB is completely meaningless.