The entire concept of psychology is to help people. It's the sick and depraved who use such knowledge to target the inherent goodness in...

An interesting database analogy, but quite apt. It's also good that you stuck to your guns and didn't let them pressure you into action before you were ready. I have...

Steve, I appreciated your comment: "Perhaps the Lucid developers are under pressure to get features out, but it seems that I've encountered more than a few things that could (should?)...

Yeah, I'm scratching my head on this one. Due to case insensitivity, I would expect all 10 rows to return, so I selected 10. I am surprised that the "correct"...

Over 20 years ago, I was asked to administer the phone system. It was antiquated and had a separate system for voicemail. The only way to connect to them was...

HTML didn't like the correct answer: <Steve Jones>

• This reply was modified 3 months ago by Aaron N. Cutshall.

As a data architect, I'm always preaching about using consistent standards to enforce names, data types, etc. The value of a standard isn't in the method of naming or data...

Crap. I didn't notice that the procedure was created in the ETL schema.

Unfortunately, none of the answers will work as they all return NULL since they fall outside of the acceptable range of values for NCHAR (0 through 0xFFFF).

• This reply was modified 8 months, 1 weeks ago by Aaron N. Cutshall.

If it is an ETL load that takes an hour AND runs during company downtime and I can get it down to 5 minutes, yes it is a HUGE...

I have to say that when it comes to refactoring code, it's usually my own code that I refactor. This is typically because I've learned more since I originally wrote...

@Ronald, you have a point that most modeling tools focus only on the physical model. There are some that also claim to have logical models, but they are not true...

I'm an old hand at data modeling. I started doing them manually in the 80's in the early drawing programs (yeah, majorly tedious!). I was one of the early users...

Thanks Steve. You highlighted one of the short-comings of the STRING_SPLIT function. While it's nice to have (in concept), I still prefer the flexibility of my own function based on...

There may be a difference between on-prem and Azure, as I got 10 as the estimate on both with Azure SQL.