Daily Archive: April 8, 2011

Index all tables in one shot 0

Index all tables in one shot

Here’s a nice little snippet of T-SQL code that will reindex all tables in the database with one line of code: EXEC sp_msForEachTable @COMMAND1= ‘DBCC DBREINDEX ( “?”)’ Keep in mind that the DBCC...