If you alter the collation at the database level it can have a negative impact on many, many things including query results, query performance, backups, indexes, data integrity, and can...

Well I wouldn't want to make any recommendations in this regard.  Changing collation on an entire db could cause major issues.  If possible maybe set up a new instance with...

More people need to know about the method that Dave showed in this article.

On modern machines, we still get 3 orders of magnitude difference in CPU and Duration (shown...

I did?  I don't remember... I've gotten old enough where I think my harddrive is full and, every time I learn something new, either something else in my mind...

It would be interesting to see...

I assume SQL 2019 for David, but I do think it's hard to regression test. I don't know how many of us have a decent set of things to...

Maybe split twice using an ordinal string splitter.  If there's more than 1 (www.domin.org)'s this would split them all.  Splitter is available at this link

DROP TABLE...

I too am curious how the project is going or went. I definitely wasn't trying to say "don't do it", I was just trying to say to be careful...

Ha, a haunting could be a good thing 🙂

This sounds like an interesting project and I'm wondering how it turned out.  Mr. Brian Gale made good points but there are workable solutions around.  Some backend developers are web...

That makes sense.  I was going to ask if maybe another script runs at the same time.  Afaik processing-wise, the IF condition and the ALTER TABLE statement are 2 separate...

Regarding the use of...

How to calculate the product of all of the denominators for each group?  Why doesn't...

The larger query I have has many fields with converts etc. so I am trying not to add the CustomerId to the nested query to get the sum somehow...

Assuming the parts to be split are: 1) the sentence on the left, and 2) the single string on the right.  It appears after the initial 50 character split of...