Reindex the database with high fragmentation using "DBCC DBREINDEX"
October 1st, 2010
No comments
DBCC is one of the most commonly used commands by DBAs across the globe. Today I will introduce a simple way to reindex a specific or all indexes in a table using DBCC.
The command used for this is
DBCC DBREINDEX
General Sytax
DBCC DBREINDEX
(
table_name
[ , index_name [ , fillfactor ] ]
)
Categories: DBCC, SQL Queries, SQL Server, SQL Server, T-SQL, T-SQL DBCC, functions, index, reindex, sql query, SQL Server, SSIS, T-SQL, Transact SQL