Viewing 15 posts - 1 through 15 (of 32 total)
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...
August 21, 2019 at 2:28 pm
"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...
August 21, 2019 at 1:43 pm
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...
August 19, 2019 at 1:42 pm
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...
August 19, 2019 at 1:36 pm
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...
August 12, 2019 at 3:49 pm
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...
August 1, 2019 at 1:54 pm
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...
May 1, 2019 at 3:51 pm
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...
August 10, 2017 at 4:49 pm
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...
September 16, 2016 at 9:40 am
Hugo Kornelis (9/10/2016)
I too try to avoid them at all cost, and generally will opt for, as you stated, a well written WHILE loop.
Why? In my experience, a (well...
September 12, 2016 at 7:17 am
Jeff Moden (9/9/2016)
September 10, 2016 at 11:31 am
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...
September 9, 2016 at 8:29 am
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...
September 9, 2016 at 8:06 am
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,...
October 7, 2015 at 1:53 pm
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...
June 9, 2015 at 6:46 am