Monday, December 18, 2017
SQL Server Alerts and Notifications
Term: Bug with Index Rebuild
1 post(s)

SQL Alert - Index Rebuild Can Cause Data Corruption

By Saleem Hakani on 8/25/2014

The online index rebuild can cause index corruption or data loss when it is used together with concurrent queries that modify many rows.

Example Scenarios:

1.Replication updates many rows on a table when the online index build is running on the same table concurrently.

2.Heavy DML activity happening on the table while index is being rebuilt

Alter Index
Bug with Index Rebuild
Online Index Creation
Remove Index Fragmentation
Copyright [2014] by SQLCOMMUNITY.COM