A Self-Tuning Fill Factor Technique for SQL Server – Part 1

  • Comments posted to this topic are about the item A Self-Tuning Fill Factor Technique for SQL Server – Part 1

    Mike Byrd

  • Very interested to try your technique. should line 386 end in air1?

  • Had some trouble getting it to work though.

    First of all, as stated in the above comment, line 386 has the wrong alias and should be air1 indeed. And I'd like to suggest three small adjustments on lines 463, 476 and 535 to put a QUOTENAME around the @indexname ...

    ALTER INDEX ' + QUOTENAME(@indexname) +' ON [' + @schemaname

    It appeared that someone in our organization came up with the excellent idea to put dots (.) in a couple of indexnames, obviously resulting in a failing command.

    Looking forward to see what's going to happen over time and can't wait to read part 2.

    Cheers

  • Actually the script has evolved some since I wrote the article.  Have attached latest script (currently in production on one of client's databases).  (Change file extension from txt to sql)

    • This reply was modified 2 years, 1 month ago by  Mike Byrd.
    • This reply was modified 2 years, 1 month ago by  Mike Byrd.
    Attachments:
    You must be logged in to view attached files.

    Mike Byrd

  • I'll ping Mike for updated images.

  • I'm trying to use this on SQL Server 2014 Std. I'm using the most recent script listed above. However it keeps crashing with:

    Msg 25704, Level 16, State 1, Line 8

    The event session has already been stopped.

    Is this happening to anyone else? I'm going to try the original script in a moment.

  • This is the script I reworked to run on SQL Server 2014 STD taking into account everything mentioned in this thread up to this point. It uses the code base from the original posting.

    UPDATE: Forgot to rename the extension from .SQL to .TXT 🙂

    • This reply was modified 2 years, 1 month ago by  ThatSteveCena. Reason: Forgot to fix file extension
    • This reply was modified 2 years, 1 month ago by  ThatSteveCena.
    Attachments:
    You must be logged in to view attached files.
  • I'm not seeing your attachment. 🙁

    Mike

    Mike Byrd

Viewing 8 posts - 1 through 8 (of 8 total)

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