Pages

Thursday, August 22, 2013

SQL SERVER – ReIndexing Database Tables and Update Statistics on Tables | Journey to SQL Authority with Pinal Dave

SQL SERVER 2005 uses ALTER INDEX syntax to reindex database. SQL SERVER 2005 supports DBREINDEX but it will be deprecated in future versions. When any data modification operations (INSERT, UPDATE, or DELETE statements) table fragmentation can occur. DBCC DBREINDEX statement can be used to rebuild all the indexes on all the tables in database. DBCC… Continue Reading...

Source: SQL SERVER – ReIndexing Database Tables and Update Statistics on Tables | Journey to SQL Authority with Pinal Dave