Good catch, Scott. Changing that.

String_split returns a table. The list is converted into a table, so normal query rules for a table apply. In this case, there is no PK,...

My employer has been discussing for what seems like years about putting databases under VCS.  One system that I support was developed by an outside contracting firm.  Their database...

So, this leads me to ask, under these circumstances what can I do to get this guy to actually learn how to do a Get Latest before he starts...

Ah, sorry. It was working, then I added the file name change. I've adapted the question and this should award back points.

LOL, the grocers have been crazy. I'll need to go get some supplies Sat or Sun, but might go really early or late to limit contact.

We're going to lay low....

I got no kick with the questions and the editorials. In fact, the questions and editorials help me focus on things that might improve my queries, so keep it...

From what I've read, and my wife keeps researching because she has lots of older clients and is worried, most of us will be fine, but if you have respiratory...

That's a colon, and you're correct. Updated the answers.

Hi Steve - I think it is amazing that you can think up a new question challenge each day (and that you can produce the editorial similarly - and...

I wonder how this will go. My wife was listening to some of the things they did in China to contain the virus. Seems to be working, but it was...

Sorry to hear that, Sean, and hope things go better for you. I've seen many updated policies lately that are suspending some of the cancellation fees and allowing rebooking. So...

Sad here that the major volleyball tournament was cancelled. I coached last weekend for the younger kids, but the 16-18s were this weekend. I have kids at all ages I've...

No dev edition. No to 2019

https://aws.amazon.com/rds/sqlserver/pricing/

SQL Server...

Qa shouldn't have any. If they find some, or write them, they should get committed in a VCS and given to developers. The idea is that all automated tests pass,...

I am guessing this might not necessarily be a SQL issue? I know you can create a dump (https://support.microsoft.com/en-us/help/917825/use-the-sqldumper-exe-utility-to-generate-a-dump-file-in-sql-server) when you have issues. Maybe keep that link on the...