I would suggest not to use T-SQL also for cooking rice and painting walls.

I "paint the walls"...

"Irony"... thanks for the reminder... I gotta iron a shirt for tomorrow's holy war with management 

Well... it depends...

Heh... Oh, I agree with you, Serqiy... no such thing as a "Universal Application".  Maybe they're that "misinformed" or ... not.

Nah, it's gotta be something else.  I'll try to get...

That's what the "" is supposed to do when importing into Excel... it's one of the default settings.  Tell your client the "" is absolutely necessary.

Should have sent this for a Friday poll!!

Didn't know there was such a thing... I'll check it out! ...

Yep, thanks Antares... knew that.  Not entirely sure that's what they were looking for, though.  Really strange question.  I think both Steve and I are right... it was one of...

That's kinda where I went with it... it depends.  But, I think they had something specific in mind... or, like I said, maybe a trick question to determine which "camp" I was...

Dunno, Peter... I can see UDF's being a place where you'd definitely NOT want to use a stored proc... but, I really don't know what they were getting at.  I...

Guess that's what I get when I only ask one question a year, huh?

Heh... yeah... I had a similar reaction as you did, David... I know you can't make it brush...

Yes, I know that statistics are independent of indexes... but think of stats as automatically generated indexes...

Can't believe that MS recommended turning them off... Look's like I have a little...

WHERE ','+@strApplicationIDs+',' LIKE '%,'+CAST(ApplicationID AS VARCHAR(10)+',%'

Index usage is certainly not possible using this method...

Hmmm... anyone know of any disadvantages of specifying VARCHAR(MAX) for everywhere a varchar is needed?

I think we've pretty much beat the subject of when and when not to use NOLOCK to death and the author pretty much summed up all that in his new...

Make sure TempDB is set to "simple" recovery mode... kill the developers that wrote cursors, views of views, and monster CTE's.