Small Business IT Consultant

Lionel MM

<div>
Its not a great idea to just blindly go and reindex every table in your db w/o checking to see how fragmented it is, by the way. &nbsp;
</div>


Its not a great idea to just blindly go and reindex every table in your db w/o checking to see how fragmented it is, by the way.  

<div>
Thanks for your help, this will at least give me somewhere to start :)
</div>


Thanks for your help, this will at least give me somewhere to start :)

<div>
<div class="content wysiwyg-content">
Experts,<br />
<br />
Can someone please provide me with the command to Rebuild Indexes for every table in a database rather than going one by one? &nbsp;The name of the database is EVEREST_TMA. &nbsp;Is there even one available or do I need to do it each table at a time? &nbsp;I am not very knowledgeable of SQL so anything would help.<br />
<br />
Thanks,
</div>
</div>


Experts,

Can someone please provide me with the command to Rebuild Indexes for every table in a database rather than going one by one?  The name of the database is EVEREST_TMA.  Is there even one available or do I need to do it each table at a time?  I am not very knowledgeable of SQL so anything would help.

Thanks,

Rebuild Indexes SQL 2000

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.