April 14, 2013 at 2:53 pm
Hello Everyone
I hope that everyone is having a very nice weekend.
I am working to create a maintenance plan. I am looking for some great advice on how one could rebuild all indices. Of course using a stored procedure that is executed by a SQL job. I have a query that will return all index names that are fragmented above a set percentage. I would like to use that to get the name. But after that, I am not sure what the best performing code would be to write to rebuild each index in the list returned.
I great appreciate any and all advice, suggestions and comments
Andrew SQLDBA
April 14, 2013 at 3:35 pm
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 14, 2013 at 5:46 pm
Thank You, this is great.
Andrew SQLDBA
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply