518 karma · joined October 11, 2012
Less known is that you can get the same effect using a TOP N statement where N is a number larger than the rows you might get back. This presumably avoids the additional i/o penalty of the temp table creation, but I've never validated that. This trick likely is portable across db engines, too.
See https://bertwagner.com/posts/does-the-join-order-of-my-table... - Adam Machanic has some good videos diving deeper into this.
And, it learned more each time you ran it - even more crazy! It was only when I looked at the source code and realized that it was using self-modifying code that I went, "Wait a minute - THAT'S A THING?"
I had so many of those moments. The very first was realizing you could use an iterator variable to do other things within the loop. That's the exact moment when programming clicked for me. My perception of it changed from being a glorified way to write out steps (like a hair-washing algorithm on a shampoo bottle) to realizing it could be very expressive and flexible.
On the other hand, from a purely practical perspective, the answer is only accurate to six digits, which is the number of digits in the fraction you must remember. So, you're not really getting much of a free lunch.
During the meeting, there was a hairy moment where the tape broke and got tangled up and likely ruined. This happened because of an old splice, but fortunately was at the end of the tape just as everything got successfully archived (at least one copy of it anyway).
It was a cool moment to observe, and I now have copies of these applications in my possession.
I watched the show with two other people, of very different interests and ages. We all enjoyed it immensely.
- The sets, costumes, and cinematography are fantastic and at times breath-taking. The level of detail in the costumes is amazing, and I can't really imagine them being better. - The acting is first-rate. IMO it's better overall than the acting in LoTR, or at least as good, and better than in most shows you'll watch. I did not see an actor that was not all-in for their role, and the many accents are beautifully done. This is the most important quality of any show for me. - The language in the script is elevated, and there are some beautiful lines. Scenes are allowed to develop, without the need for the rapid cuts many shows feature/rely on. - Plot is fine! I have not seen where it will go yet, but there are some big plot points, and subtle tensions developing. I had no problem here.
I love LoTR, but am not a dedicated Tolkien fan with rules about how things must be. I am fine with spin-offs, re-imaginings, alternate worlds, whatever! IMO the goal here is to entertain, to capture the imagination, and to do work that shows dedication to the craft and I think the show easily succeeds in all of those. I would probably watch a full season just for the production value alone.
Also, the whole race thing: What? To me it's a complete red herring and everyone in the show belongs there. This is not just gate-keeping, but racism plain and simple. If countering that racism is your only reason to watch the show, that's a good enough reason.