NOLOCK should only be used when appropriate.  But, yes, I do think the jihad against it can be overdone at times, aka the "never use NOLOCK" crowd.  Makes almost...

• This reply was modified 4 years, 5 months ago by Michael L John.

I had someone from HR make me remove the shirt pictured above.  It was at a company picnic.  I guess I offended some people.

When I headed up a group of...

It really depends on whether you understand the consequences of NOLOCK.  It can result in a 'dirty read' if there are uncomitted transactions in the database that affect...

Then you really have never done any...

I always wondered if those looking at this understood that time spent thinking or architecting a solution many times is more valuable than creating many things quickly and spiraling...

Heh... mine has started off with a bit of a "well that sucks" factor.  Whole new time-keeping system where they want me to categorize virtually every aspect of what...

SQL 2012 is end of life in 7 months.  Sounds like it's time for another vendor.

Back at ya.

Mine has started good already.  I received a significant bonus, and was put on some kind of quarterly bonus plan moving forward.

Wouldn't that be related to parameter sniffing in the scenario I gave vs function in a WHERE clause in the OP?  And if so, the performance could...

Wouldn't that be related to parameter sniffing in the scenario I gave vs function in a WHERE clause in the OP?  And if so, the performance could tank due...

Yeah, I wasn't saying it was "good", it is just what it was doing.  I prefer the "WHERE (A=@a) OR (@a IS NULL)" approach myself... and depending on how...

Which is typically a really poor performing construct.

I see this far too often when something else should have been used.

"I review it".  How long does THAT take?

And why does it need reviewed for "safety" if they don't have the permissions to change anything on...

• This reply was modified 4 years, 6 months ago by Michael L John.

Hi Michael

thanks for looking at query.. yes you are right the other post is also mine but client changed the requirement. now they want to see if it is...

What value indicates that room_cd is single? Or multiple?

Can you show what you have tried so far?

Isn't this the same question in this post?

https://www.sqlservercentral.com/forums/topic/t-sql-help-50