• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 384
  • Last Modified:

SQL Server Rebuilding Indexes

I'm looking for a very easy way to rebuild the indexes on my sql server without causing degraded performance or excessive memory consumption.

I don't mind indexing each index on its own, just don't want to use custom stored procedures.
0
koossa
Asked:
koossa
1 Solution
 
TempDBACommented:
There was an article sometime back from one of our script with the scripts. Check if that might help you:-
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/A_4383-MICROSOFT-SQL-SERVER-REBUILD-REORG-ALL-INDEXES-ON-ALL-DATABASES-10-FRAGMENTED.html
0
 
koossaAuthor Commented:
Thank you, I saw that article today, but I want something simpler and preferably not as a stored procedure, but as SQL that I can call from an application?
0
 
Omid OmarkhailSenior Technical ConsultantCommented:
0
 
koossaAuthor Commented:

...but as SQL that I can call from an application?
0
 
Jared_SCommented:
ALTER INDEX ALL ON <MyTable> REBUILD

This is as simple as it gets.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now