August 10, 2009 at 11:55 am
Isn't there an option to defrag a table in the GUI (Management Studio)?
August 10, 2009 at 12:00 pm
defrag your indexes yes.
YouDB->Tables->Indexes-> right click there are option rebuilds.
Victor Alvarez
http://sqlpost.blogspot.com
August 10, 2009 at 12:10 pm
I knew it was there somewhere. Thanks for pointing the way.
August 11, 2009 at 6:09 am
I don’t know if you know it or not, but when you rebuilding an index takes it offline while it is being rebuild. If it is a cluster index, then the table is taken offline. If you have enterprise edition, then it can be done online (but I don’t know if the GUI does it online). If you can’t take the index/table offline, then you’ll need to reorganize it instead of rebuild it.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
August 11, 2009 at 7:14 am
I appreciate the help. I have around 450 indexes that are over 50% fragmented. From what I have read I need to rebuild rather than reorganize. I do not have enterprise edition so I will have to do this when everyone is out of the system. Thanks again.
August 11, 2009 at 5:15 pm
bpowers (8/11/2009)
I appreciate the help. I have around 450 indexes that are over 50% fragmented. From what I have read I need to rebuild rather than reorganize. I do not have enterprise edition so I will have to do this when everyone is out of the system. Thanks again.
And you are going to do this manually? One at a time? Through the GUI?
Sorry, but that is just way too much work for me. I would create a maintenance plan, add the Rebuild Indexes task, select the indexes needing to be rebuilt - schedule the job and let it rip.
But, then again - I am absolutely one of the laziest DBA's you will find. :w00t:
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 13, 2009 at 7:06 am
That sounds like a plan. I appreciate the guidance. By the way, that is not being lazy it is being smart. Thanks again.
August 13, 2009 at 9:25 am
Glad I could help 🙂
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply