Ok... bloody variable width font's made it look like the CHARINDEX was based on an Empty String and not a single space, so I did have a misleading bit of...

Sorry... Had an possible error in my post and took it down until I'm sure.

Hi Friends,

I have been assigned to manage an SQL server pool with some standalone and with Log shipped to a DR. I noticed one of them has two databases...

@krypto69 ...

Ah... maybe not enough coffee when I read it the first time and assumed that "just goes and goes and returns no records" meant that it never stops.

Just to...

Have you checked to see if the d.eff_thru column is actually NULLable?

If it's not, remove the ISNULL from your formula.

If it IS NULLable, the ISNULL formula is non-SARGable (basically, cannot...

Last observation, we've been experiencing a lot of turnovers recently. One of the biggest positions to leave is the head of our Project Management Office. In an all-IT...

The following statement runs in 4 seconds and is definitely better:

SELECT
  B.ID,
  D.Value
FROM #Big B
LEFT MERGE JOIN (
  SELECT ID, dbo.GetValueInLanguage('fr', XmlValue) AS...

Maybe a multi-author Stairway to make such articles easy to find as a group?  To make it as high quality as possible, perhaps have a couple people do a review...

Hmmmm.... maybe a kickoff with the most basic and, yet, one of the most important things that isn't actually taught in any beginner classes that pretty much laid a foundation...

Agreed.  Definitely not a one man show on this type of thing.

It's funny that you brought this up because I was thinking about how many things I and others have...

That sounds like a fantastic idea, Steve.  Any ideas for a series title, just to add some consistency to such articles?  Some of those have already been written though.  Like...

What I find funny is that all of the too-cool-for-school stuff is what people concentrate on.  They don't realize the importance of SQL because they think they know SQL... in...

Absolutely not.  Where did that happen?  Was it on this this thread?  Was it...

Thanks for taking the time to post feedback, JJ.  It IS interesting to see which hoops and how high the flames are that other people have to go...

Thanks for taking the time to post feedback, JJ.  It IS interesting to see which hoops and how high the flames are that other people have to go through.

And glad...