THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » fragmentation   (RSS)
  • Webinar 2.6 - Fragmentation

    Slides and scripts are now up from today's webinar. https://www.dbbest.com/blog/webinar-2-6-followup-episode-9-fragmentation/   Thanks to all who attended!  
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on November 28, 2017
  • Ola Hallengren adds STATISTICS support to his solution

    Last week, Ola published a very useful update to his Backup, Integrity Check and Index Optimization scripts: the solution now supports updating statistics.  There are several options, such as only updating when the data has been modified and using the RESAMPLE and NORECOMPUTE options.  An example call: EXEC ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on December 13, 2010
  • SQLFool has updated her index maintenance scripts and needs testers!

    Michelle Ufford (@SQLFool) has just announced some shiny new updates to her popular index maintenance scripts.  Read about them and contact her if you're interested in beta testing:http://sqlfool.com/2010/01/index-defrag-script-updates-beta-testers-needed/
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on January 26, 2010
  • Geek City: Fragmentation and Forwarded Records in a Heap

    I know it's been a while since I had a technical post, and I've got 3 of them started and saved as drafts. I keep waiting for spare time. Now that PASS is over, and I've crawled partway out from under the TO-DO pile that accumulated while I was preparing for PASS, I'm going to pull one of the drafts and and get to work on it. After I had posted ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on November 11, 2009
  • Geek City: Fragmentation Internals

    Yet another fragmentation post, to answer a question asked in response to a previous answer.... SQL_Girl is still confused about DETAILED vs LIMITED, and I don't blame her. She reported that the BOL says:  ''The nonleaf levels of indexes are only processed when mode = DETAILED. ''  But I had said: ''The second misunderstanding involves ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on March 6, 2008
  • Did You Know? Fragmentation, revisited....

      A couple of questions arrived regarding my earlier post about fragmentation on the system tables, and since the questions really don't have anything to do with system tables, I felt they deserved a new post. 1) Using the DETAILED option includes the non-zero index-levels as well (non-leaf pages).  According to many source, this ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on February 28, 2008
  • Geek City: Fragmentation on the System Tables

    It's my first post of the new year. I hope it's starting out well for all of you! New year, but sometimes the same old questions. I got another email asking about defragging the system tables. It seems to be in the Hit Parade of FAQs. First of all, WHY do you think you would need to defrag a system table? Fragmentation is only a problem when you ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on January 17, 2008
Privacy Statement