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

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy