Browse by Tags

Rebuild some fragmented indexes - problem with Extent Scan Fragmentation value

Published 24 August 7 6:24 AM | SSQA.net

This was the question from SSP forums, I’m trying to rebuild few fragmented indexes on a table that is updated on regular basis. The “dbcc showcontig” gave this result: Table: 'Confidential' (999999999); index ID: 5, database ID: 5 LEAF level...

Filed under: sql server, performance, security, dbcc, index, table, fragmentation, showcontig, defrag

FIX: When you run the "dbcc dbreindex" command or the "alter index" command, some transactions are not replicated to the subscribers in a transactional replication in SQL Server 2005

Published 22 May 7 12:54 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition KBA - FIX: When you run the "dbcc dbreindex" command or the "alter index" command, some transactions are not replicated...

Filed under: sql server, dbcc, kba, transaction, index, dbreindex