Post reply

Index Fragmentation

  • March 10, 2015 at 8:35 pm

    #75714

    Comments posted to this topic are about the item Index Fragmentation

  • March 11, 2015 at 12:28 am

    #1783134

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

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

  • March 11, 2015 at 5:23 am

    #1783208

    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.

    Tally Tables - Performance Personified
    String Splitting with True Performance
    Best practices on how to ask questions

  • March 11, 2015 at 6:19 am

    #1783241

    Thanks for the question.

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

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

  • March 11, 2015 at 7:31 am

    #1783270

    Hany Helmy (3/11/2015)

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

    +1 Great question.


    Everything is awesome!

  • March 11, 2015 at 7:56 am

    #1783290

    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]

  • March 12, 2015 at 3:10 am

    #1783524

    Easy one, thanks.

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

  • March 12, 2015 at 3:26 pm

    #1783731

    Thanks for the question.

  • March 15, 2015 at 6:28 am

    #1784098

    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

  • March 15, 2015 at 6:34 am

    #1784100

    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

  • March 15, 2015 at 6:37 am

    #1784101

    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