Rebuild all indexes on a Table(s) – SQL Server

Posted: July 18, 2012 in SQLServer
Tags: ,

Rebuild all indexes on one table …

ALTER INDEX ALL ON <Table Name> REBUILD

Following link has code to rebuild all indexes on all tables of a DB …

http://blog.sqlauthority.com/2009/01/30/sql-server-2008-2005-rebuild-every-index-of-all-tables-of-database-rebuild-index-with-fillfactor/

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s