We have 3 tables in a database with single digit page counts and very high fragmentation of 70-90%. When I run a script to do an offline rebuild of indexes with fragmentation higher than 30% we end up with errors and extreme performance issues when accessing data in these tables.
When I right click on the table and do a manual rebuild of the index the performance is back to instantaneous but the fragmentation level stays quite high on the table.
Why am I experiencing such poor performance accessing data in a table with such a low single digit page count like this?
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables.
Make a table:
Update a specific column given a specific row using the UPDATE statement:
Remove a set of values using the DELETE s…