Index Fragmentation

  • Comments posted to this topic are about the item Index Fragmentation

  • I am using this one a lot, thanx for the question.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

  • Thanks a good question on a very useful DMV. Hopefully it gives people who don't know about it something new to learn for today.

  • Thanks for the question.

    Glad to see over 80% got this right (so far)

    ---------------
    Mel. 😎

  • Hany Helmy (3/11/2015)


    I am using this one a lot, thanx for the question.

    +1 Great question.



    Everything is awesome!

  • Hany Helmy (3/11/2015)


    I am using this one a lot, thanx for the question.

    + 1

    I create a process to rebuild or reorganize indexes that are too fragmented. The process uses this table.



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • Easy one, thanks.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Thanks for the question.

  • Alvin Ramard (3/11/2015)


    Hany Helmy (3/11/2015)


    I am using this one a lot, thanx for the question.

    + 1

    I create a process to rebuild or reorganize indexes that are too fragmented. The process uses this table.

    Seems to me a part of the complete maintenance solution done by Ola Hallengre http://ola.hallengren.com

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

  • Alvin Ramard (3/11/2015)


    Hany Helmy (3/11/2015)


    I am using this one a lot, thanx for the question.

    + 1

    I create a process to rebuild or reorganize indexes that are too fragmented. The process uses this table.

    Seems like part of the complete maintenance solution done by Ola Hallengren

    http://ola.hallengren.com

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

  • Alvin Ramard (3/11/2015)


    Hany Helmy (3/11/2015)


    I am using this one a lot, thanx for the question.

    + 1

    I create a process to rebuild or reorganize indexes that are too fragmented. The process uses this table.

    Seems like a part of the complete maintenance solution done by Ola Hallengren http://ola.hallengren.com

    Nice work though 🙂

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

Viewing 11 posts - 1 through 10 (of 10 total)

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