http://www2.sqlblog.com/blogs/merrill_aldrich/archive/2013/01/14/updated-warehouse-re-index-script.aspxAs I talked about in my last post , I just went through a re-indexing project that took the partitioned fact rows from our warehouse and relocated them into new files. There are a lot of tables and indexes involved, so I have a PowerShell “helper” scriptenCommunityServer 2.1 SP2 (Build: 61129.1)http://www2.sqlblog.com/blogs/merrill_aldrich/archive/2013/01/14/updated-warehouse-re-index-script.aspx#47163Tue, 15 Jan 2013 09:01:21 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:47163Gonçalo Ferreira<p>Something like the following would probably be more readable.</p> <p>$indexCreateScr = $indexCreateScr -replace `</p> <p> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'ALTER TABLE (.+?) ADD &nbsp;CONSTRAINT (.+?) PRIMARY KEY CLUSTERED', `</p> <p> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ('/* $&amp; */' + &quot;`n&quot; + 'CREATE UNIQUE CLUSTERED INDEX $2 ON $1')</p>