how to List out all tables indexes having index fragmentation more than 50% of databases.

Question

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply

Neeraj Dwivedi SSCertifiable Points: 6768 More actions · Answer 1

My mistake.

Get database id from from sys.sysdatabases and pass that as first parameter.

David Knapp SSC Enthusiast Points: 177 More actions · Answer 2

Thank you! I am not in the office for a few days but will try it out when I get back.

Duran SSChampion Points: 13259 More actions · Answer 3

Hey,

Yes its an old thread, but it helped me out today. Thanks for posting!

Regards,

D.