Database, Data Warehouse & Business Intelligence Architect....How do you obtain these credentials? I've been doing these forever...maybe it's time for a raise (as I'm only a lowly DBA)!!! By the way Cat, loved your response....http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=101272Flipping amazing........I guess if we can't laugh at each other, we're in serious trouble....

I have actually found tables with indexes for every column on a database that the other dba has forbidden me to look at. He's very territorial and this prod machine is his baby and it has more problems than any other server in the company(and it's the newest, with the most RAM, CPUs and Storage). I was recently granted rights to the server in question and curiosity overwhelmed me and I took a peek. Most of the tables use 3 times the storage in indexes than they do in data. There isn't a single instance of a covering index that I could find. I found clustered indexes on tables with the another index on the same column defined as a non clustered index. And of course the one index per column "rule".

He actually told me he couldn't run profiler to tell what the problem was with the server during business hours because it would bring the server to its knees. So he was going to run profiler while it wasn't under load to determine the problem.

He's right that SQL Profiler could bring the servers to its knees. This is why it is highly recommended to trace your data to a file rather than to a SQL table. I've seriously impacted production when I've saved it to a table. That's when I started doing research on SQL Profiler performance on found the recommendation on MS' site.

You have to laugh about it otherwise it'd make you cry. I'm lucky in that I started my job about 12 weeks ago. They look to me for suggestions and we actually implement some of them. Quite the opposite of what I had become accustomed to (used to be reactive as opposed to proactive). I'm very territorial as well (my data, my database, my job) but always open to suggestions. I can understand profiler bringing the system to it's knees but when's the best time to run it? Ah, after the fact..."all looks good boss, no problems here". Three times the storage on indexes, gotta love that too, especially during peak processing times. And duplicate indexes...your users have to be going NUTS (one day they're going to grab him by the short hairs)! Glad to see you can find some joy in the situtation! Where would we be without a sense of humor?

Tara, I usually trace into a table on my local sandbox. How does that compare to putting it into a file on the server?

Terry, His user base is pretty frustrated with him now. Upper management has actually questioned his usefullness in a meeting with a large number of people with a nice cross section of the company ... in front of our director.

What saves him most of the time is his ability to baffle people with BS. If he doesn't know the answer, he makes something up and says it with authority. Later, when I do the research and gently let him know he was wrong, he never corrects himself to the developers. I've never heard that man say, "I was wrong" or "I made a mistake".

quote:Originally posted by cat_jesusWhat saves him most of the time is his ability to baffle people with BS. If he doesn't know the answer, he makes something up and says it with authority. Later, when I do the research and gently let him know he was wrong, he never corrects himself to the developers. I've never heard that man say, "I was wrong" or "I made a mistake".

Sounds like several people I've had the (dis)pleasure of working with.

One insisted that every column in the table be indexed (indvidually, of course) and that his GUID PK's always had to be clustered. He left us "idiots" to go work for IBM...sigh.

Tara, I usually trace into a table on my local sandbox. How does that compare to putting it into a file on the server?

Terry, His user base is pretty frustrated with him now. Upper management has actually questioned his usefullness in a meeting with a large number of people with a nice cross section of the company ... in front of our director.

What saves him most of the time is his ability to baffle people with BS. If he doesn't know the answer, he makes something up and says it with authority. Later, when I do the research and gently let him know he was wrong, he never corrects himself to the developers. I've never heard that man say, "I was wrong" or "I made a mistake".

You should watch out. He may try to find a way to blame you for all the problems.

Michael, You don't know how right you are. This guys dumps on anyone who leaves. I'm certain that if I leave before he does, every single production problem will be all my fault. He doesn't dare do that now because I save his ass all the time and don't make a big deal of it. I hope that in time he will see that it's better to try hard, learn and admit when you screw up than to behave the way he does. I am told this is a foolish hope, but I am an optimist that way.

I have actually found tables with indexes for every column on a database that the other dba has forbidden me to look at. He's very territorial and this prod machine is his baby and it has more problems than any other server in the company(and it's the newest, with the most RAM, CPUs and Storage). I was recently granted rights to the server in question and curiosity overwhelmed me and I took a peek. Most of the tables use 3 times the storage in indexes than they do in data. There isn't a single instance of a covering index that I could find. I found clustered indexes on tables with the another index on the same column defined as a non clustered index. And of course the one index per column "rule".

He actually told me he couldn't run profiler to tell what the problem was with the server during business hours because it would bring the server to its knees. So he was going to run profiler while it wasn't under load to determine the problem.

It's a horror show, but it makes for good humor.

actually you should have TWO indexes per column. one asc, the other desc.

every now and then someone comes along who seems to post all over the place with replies that are at best a copy of someone else's reply, or completley irelevant to the original question, or just plain wrong.

Well It looks like no real help is coming Thanks everybody for your help (80%)I will just figure out the remaining 20% quite new to SQL 2000 thou

quote:Originally posted by Michael Valentine Jones

I’m really sorry that SQLTeam was unable to respond to your question with the proper sense of urgency and seriousness. I hope having to do 20% of your work was not too inconvenient. We treasure your questions, and hope we will be able to serve you satisfactorily in the future. Best regards.