Posts tagged indexdefrag
SQL Maintenance Tips
Jan 1st
dbcc checkdb (’databaseName’)
Verifies that Index and Data Pages are linked properly,
that Indexes are sorted, that the pointers in the database
are accurate, that the data looks OK, and that there are
proper page offsets.
Advanced checkdb Options:
NOINDEX, REPAIR_FAST, REPAIR_REBUILD, REPAIR_ALLOW_DATA_LOSS
noindex: Checks the database but not it’s indexes. Results in faster operation. If there are problems, make sure to More >
SQL Server Database Maintenance
Nov 12th
So, I’m a new kid on the block when it comes to SQL Server and I was in need of reindexing and defragmenting some tables in a database. I ended up finding a few commands useful for this operation.
dbcc indexdefrag and dbcc dbreindex
After running
dbcc showcontig
to get a report on density/fragmentation. I saw a lot of More >