Mark,

Could you post your code again?

GAJ

Hi Michael,

I'm not sure of the performance hit of the udf, I'd have to test the various query plans, etc.

The maintenace issue is what I'd want to stay away from...

Alex,

I wish I had known of this feature 2 years ago but it's one I missed until recently. My hope is that there are others out there that had been...

Nicely Put RBarry.

I would start a performance audit prior to meeting (if possible).

Go into the meeting with as much knowledge as possible:

http://www.sql-server-performance.com/articles/per/performance_audit_part3_p1.aspx

Dont assume that the engineers are right...

Exactly what I was thinking.

some IO concurrency issues....

gaj

could even be the Transaction logs being backed up or something.

are your Transaction Logs on different disks than your data\indexes ?

same thing with TempDB. is it on it's own logical...

check to see if the select is being blocked.

as a quick test add WITH (NOLOCK) hint on the Table

Then, when the query runs, look at IO Performance in PerfMon

I would...

Great Article !!!

I am very much looking fwd to Part II.

thanks

Greg Jackson

PDX, Oregon

I would just execute the statement in question 5-10 times while profiling it for duration.

run it 5-10 times without qualified naming and then 5-10 times with qualified names.

average the durations

probably...

Roy,

Nice Work !

This is a well written, clear article.

I've always known this to be an issue, and in many places I've worked, we've adamantly forced the qualified naming conventions.

In the...

LOL

sounds to me like they had some "Issues" with the past DBA that they are replacing.

yeah...I dont see too many GURU's pounding their doors down here....

I also am not fond of the idea.

Putting the SQL layer in the hands of the entire engineering arm is likely to be dangerous in most shops.

How can you guarantee...

Sorry Michaell,

I dont understand the question here...

GAJ

Rishi,

You're very welcome.

I never imagined this trivial little article would have generated so much interest and such a vigorous discussion thread.

I'm very glad that SQLServerCentral published the article now.

cheers,

Thanks a bunch Matt,

I definately will

GAJ