<div>
for on-going maintenance you may want to check ou this:<br />
<br />
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance<br />

<blockquote>
The SQL Server Maintenance Solution comprises scripts for running backups, integrity checks, and index and statistics maintenance on all editions of Microsoft SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, and SQL Server 2012. The solution is based on stored procedures, the sqlcmd utility, and SQL Server Agent jobs. I designed the solution for the most mission-critical environments, and it is used in many organizations around the world. Numerous SQL Server community experts recommend the SQL Server Maintenance Solution, which has been a Gold and Silver winner in the 2012, 2011, and 2010 SQL Server Magazine Awards. The SQL Server Maintenance Solution is free.
</blockquote>
Ola Hallengren<br />
<a href="http://ola.hallengren.com/" rel="ugc">http://ola.hallengren.com/</a><br />
<a href="http://sqlbits.com/Sessions/Event9/Inside_Ola_Hallengrens_Maintenance_Solution" rel="ugc">recommended video:</a><br />
<br />
also refer to<br />
<a href="https://www.experts-exchange.com/questions/28163719/Best-time-to-rebuild-indexes-on-the-database.html?anchorAnswerId=39265474#a39265474" rel="ugc">https://www.experts-exchange.com/questions/28163719/Best-time-to-rebuild-indexes-on-the-database.html?anchorAnswerId=39265474#a39265474</a>
</div>


for on-going maintenance you may want to check ou this:

SQL Server Backup, Integrity Check, and Index and Statistics Maintenance


> The SQL Server Maintenance Solution comprises scripts for running backups, integrity checks, and index and statistics maintenance on all editions of Microsoft SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, and SQL Server 2012. The solution is based on stored procedures, the sqlcmd utility, and SQL Server Agent jobs. I designed the solution for the most mission-critical environments, and it is used in many organizations around the world. Numerous SQL Server community experts recommend the SQL Server Maintenance Solution, which has been a Gold and Silver winner in the 2012, 2011, and 2010 SQL Server Magazine Awards. The SQL Server Maintenance Solution is free.

Ola Hallengren
http://ola.hallengren.com/ [http://ola.hallengren.com/]
recommended video: [http://sqlbits.com/Sessions/Event9/Inside_Ola_Hallengrens_Maintenance_Solution]

also refer to
https://www.experts-exchange.com/questions/28163719/Best-time-to-rebuild-indexes-on-the-database.html?anchorAnswerId=39265474#a39265474 [https://www.experts-exchange.com/questions/28163719/Best-time-to-rebuild-indexes-on-the-database.html?anchorAnswerId=39265474#a39265474]

<div>
Thanks, PortletPaul.<br />
<br />
I appreciate the extra assistance.
</div>


Thanks, PortletPaul.

I appreciate the extra assistance.

<div>
<div class="content wysiwyg-content">
Does anyone have a script that will rebuild all indexes and work in SQL Server 2008 and higher?
</div>
</div>


Does anyone have a script that will rebuild all indexes and work in SQL Server 2008 and higher?

Script to Rebuild All Indexes

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.