We have a table with a number of indexes inc a primary key (int). The table rows are being update a lot. Why would the Primary Key become fragmented? it's running at 61% but has been up to 98% fragmentation. I can understand why the other indexes would become fragmented but why the PK? Do you have any suggestions on how the fragmentation can be minimised? We need the indexes to speed up the read part of the process.
Any pointers would be most welcome.....
Microsoft SQL Server 2008SQL
8/22/2022 - Mon
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.