Popular Posts

SQLblog.com - The SQL Server blog spot on the web

Tuesday, February 13, 2018

Performance improvement following a disable indexes, shrink, enable indexes - but why?

SQLServerCentral » Latest topics
Performance improvement following a disable indexes, shrink, enable indexes - but why?
I'm stumped and need the assistance of the wider community to understand what is going on.
The database in question has minimal fragmentation, but performance is slow. We go through the following process:Disable all non clustered indexes

No comments: