By the way I have a 2000 & 2005 solution. It's just the right thing to do!

Kurt

I'm a big fan of a index manager solution. I have 3 production SQL Server boxes that my index manager runs. Each production box is slightly different. ...

I selected profiler too. Will I get credit for my answer?

... never good practice to use a SELECT * anyway. Do you know how many applications have broken because the developer used an SELECT * and someone came along...

What was the outcome?

Kurt

You guys left me hanging... What was the final result of the changes? Did it work, or did it work better?

Inquiring minds want to know!!!

Kurt

This is how I spend my time off. I head to a sod farm and put model gliders up to 1000'... been doing it for almost 35 years.

http://scts.rchomepage.com/

That's me...

Thanks Steve for your input. I received the Microsoft Press Sql Server 2005 Database Administrator Core Requirements textbooks as a gift. Included with it are not only the...

Thanks for your reply. Yes, I know the classes are rather expensive. I was just wondering if the class was required. I'm much like you, I'd rather...

Just wondering if any of the any of them require class time. I just received the study guides from Microsoft Press as a birthday gift. Planning on digging...

I am tracking down issues why my custom thesaurus isn't working. I found this article: http://support.microsoft.com/kb/923317 and I saw that I had an invalid character in my Thesaurus. ...

Just wondering what the build # is for SP2a?

Kurt

Thanks Grant;

That does help me. I can see that there are certain jobs that could more than likely benefit to be moved to a SProc. ...

If your use the WITH SCHEMABINDING option you can index the view as well. I would suggest you look at things like DTA to see if your views &...

I just got finished reading a white paper from Quest Software: http://www.quest.com/landing/?ID=979

I read this thread with a great deal of interest. I will assume all indexes & stats...