Brandie Tarvin (3/19/2008)

---

HEEEEHEEEEHEEEHEEE. ROTFLOL!

MAAAAAAATTTTTT!!!!

I'm supposed to be working on serious ETL stuff today! You're not allowed to make me laugh so hard that my boss glares at me from...

Just for the kick of it, today I took the brainbench test for SQL 2005 Administration.

I took Basic level for starters and I got 3.14. And when I took Intermediate...

It is a claim actually. Basically what they say is since the bats eats a certain fruit (not a common fruit, I forgot the name) and that fruit is actually...

How in heavens name did we end up with exotic food when talking about interview:D

Since the topic is already there, has anyone had Bat? You know , the flying wolf......

If it is a new index then I dont see why you need to do an Update statistics.

You could set Isolation Level read Uncommitted for the whole stored proc that has the select that causes dead locks

Thank You all for the feedback. I appreciate it very much.

I agree with sreinster. If there are really no compelling reason for this, then they should be completely qualified. In your case 3 part qualification. Especially if your DBs are...

Sideout, Yes it is always better to call objects with their qualifier.

Hey Jack,

Thanks for the excel file. Thats a pretty good testing.. 🙂

Hi Paul,

Yes, you are right. I had both 2005 and 2000 installed in my local box and ran the tests under 2000 instance.

Hi srienstr,

No, Even if you provide the DB and the object qualifier, it will still go through all the hassles of Acquiring a Lock and then releasing it.

Thats a very generic question to ask without providing any details. But I would venture to say first get all the documentations that has been completed so far. Also try...

Thats one of the craziest thing to do....:D

And the surprising part is that it worked for you...lol

Hi Gregory, Thats worth a try. I will try to do that and see if I can find anything.

Jack, Thanks for answering that. I was not sure about it...