So you don't see California splitting any time soon?

Maybe seceding. Then we can just throw CA away. Or perhaps sliding into the ocean, then we can just throw CA away...

"OH for Ohio is a perfectly good natural key, and it is not going to change." Until it does - states have split quite a few times, e.g. Virginia and...

Michael,

I agree. As hardware becomes faster and faster, the software being developed becomes more and more bloated! The "hello world" program, which compiled into 1K of code 20 years ago...

Good ole TRS-80 days. I remember them well. I upgraded from 4K to 16K and thought I had all the memory I'd ever need, until I got the expansion interface...

OMG (and I NEVER use OMG), are you kidding. I took a nap and don't think I missed anything. I watched for 2 minutes as computer-generated code was typed on...

Is it really fair to not create a PK on the table variable and create one on the temp table and compare the query plan?

You CAN create a primary key...

I have to agree with Jeff for yet another reason. While this particular function was written for this particular application, and you will NEVER be looking more than 20 days...

Maybe someone already brought it up, but I am a little curious as to why the OPENJSON function was even mentioned in this article. I can't see that it...

I guess I am a bit 'perplexed' by this article. It was good. It was well written, and it did provide some useful information, but in the end the conclusion...

Hugo Kornelis (9/10/2016)

---

Why? In my experience, a (well...

Jeff Moden (9/9/2016)

---

dbishop (9/9/2016)

---

Let me rephrase that or someone will take exception: there are times (rare cases) where using a cursor turns out to be the more efficient way of...

patrickmcginnis59 10839: What I like is that if you Google "considered harmful" you will find a plethora of articles on things considered harmful in the programming world. The one I...

Carlo: "So, except some rare case, there's no reason to use cursors!"

Which, I guess, to a point, is what he was saying. I think everyone will agree that there are...

I know it has been quite some time since this was posted, but I have a question. The code is looking for an EXACT match to the start tag. However,...

I'm sorry if I am being too critical, but this seemed like more of an article to provide a lot of screen shots, and not a lot of substance. SELECT...