Question : We are using a SQL Server 2005 database. We currently have no maintenance on our databases indexes. Some […]
Index fragementation ? is it unavoidable
Question : This is follow up question to @martin smith excellent answer https://stackoverflow.com/questions/1251636/what-do-clustered-and-non-clustered-index-actually-mean After that i have watched MCM video […]
How can I *actually* defragment my InnoDB tables?
Question : After a recommendation by mysqltuner I’ve run mysqlcheck –optimize –all-databases successfully (all of the tables reported “note : […]
How can I save a severely fragmented database/table?
Question : I’ve recently made a discovery that might explain my slow SQL run times. I found out that the […]
How to prevent daily index fragmentation of 99%
Question : I have a highscore table for 100.000 players that is being inserted into 2 times a day with […]
MongoDB Fragmentation affect the Performance in WiredTiger
Question : Im using MongoDB 3.6 I have a huge number of fragmentation in my collections. 300+ GB on one […]
SQL Server Rebuild/Reorganize Fragmented Indexes causes CRC error or consistency errors
Question : In our test lab I’ve been experimenting with different jobs to keep our critical indexes from becoming too […]
How to lower HEAP Fragmentation in SQL Server?
Question : i recently found out that one heap table had more than 70% fragmentation. So i decided to do […]
Replacing composite key with surrogate
Question : I have the following table that has a couple of million rows in it and is 99% fragmented […]
Defragmentation – Rebuilding Indexes SQL Server 2005
Question : I’m researching defragmenting databases and it seems the following SQL statement is what I’m looking for: ALTER INDEX […]