title: Rebuild all indexes in a Database
body: <p>I have a very large SQL Server 2008 R2 database (1.5TB) and will be copying some data from column to column within the same table. I've been told that the schema has a large number of indexes and was wondering if there is a default query or script that will rebuild all the indexes. Have also been advised to update the statistics at the same time?</p>
  
  <p>Each of the 30 tables has one clustered index and 13x non-clustered indexes </p>
  
  <p>Thanks.</p>