Saturday, August 19, 2017
 
SQL Server Alerts and Notifications
 
     
Term: Remove Index Fragmentation
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
HOME   |   SQL ARTICLES   |   SCRIPTS   |   DISCUSSIONS   |   SQL TEAMS   |   JOBS   |   ABOUT US
Copyright [2014] by SQLCOMMUNITY.COM