SQL Joins Archives - Page 16 of 16 - SQL Authority with Pinal Dave

SQL SERVER – ReIndexing Database Tables and Update Statistics on Tables

January 31, 2007

Best Practices, SQL Constraint and Keys, SQL Cursor, SQL Index, SQL Joins, SQL Scripts, SQL Server DBCC, SQL Stored Procedure

SQL SERVER 2005 uses ALTER INDEX syntax to reindex database. SQL SERVER 2005 supports DBREINDEX but it will be deprecated in future versions. Let us learn how to do ReIndexing Database Tables and Update Statistics on Tables.