HI..

Thank you so much! I'm going to read this.

Juanita 

Thank you very much to everyone. I've put a job in place to run weekly and i received alot of neat tips from this thread !!

Juanita

Does it in any way hurt to recycle error logs while users are using sql server? i would schedule to recycle periodically on off hours but just curious if i...

Thank you.. actually i did increase the number of logs. I might give the weekly timing a shot.

Thanks again,

Juanita

THANKS !!!

Thanks so much !!!

THIS IS GREAT !!! THANKS !!

Juanita 

Thanks so much. I just want to make sure I'm doing this job to the best of my ablility. 

Juanita

Thank you for the input. I was wondering how often DBA's reboot their sql server boxes? Should this be done on a regular basis or only as needed for upgrades,...

Thank you very much. Can i ask what utility you  use to do the re-index, delete then recreate or just fix in place?

thanks,

Juanita

Frank,

Thanks so much. that is a great idea ! i'll give that a try.

Got it !!! Thanks Greg !

Juanita

Thank you. I will try that !!!

Juanita

Thank you so much !! Got it !

Juanita 

Thanks, I'll playaround with this and give it a try.

Juanita