HN user

bts89

45 karma
Posts0
Comments9
View on HN
No posts found.

500 is the target, not a hard requirement. The current SP500 index is comprised of 503 constituents.

I’m also pretty sure S&P doesn’t maintain a ‘S&P 500 Software & Services Index‘.

There is a ‘S&P Software & Services Select Industry Index’ with 140 constituents. That’s probably the index in question.

SQL Anti-Patterns 9 months ago

That’s almost always my experience too.

Though fairly recently I learned that even with all the correct joins in place, sometimes adding a DISTINCT within a CTE can dramatically increase performance. I assume there’s some optimizations the query planner can make when it’s been guaranteed record uniqueness.

They have a Chesapeake Bay Bridge walk/run every year. It should probably be noted that it’s not the same bridge as the Chesapeake Bay Bridge Tunnel that this post is about.

The Chesapeake Bay Bridge connects Annapolis with Kent Island, while the Chesapeake Bay Bridge Tunnel connects the southern tip of Virginia’s eastern shore with Norfolk, VA.

It seems more and more that sports tickets are exclusively available on Ticketmaster

For US pro sports, I think it’s actually trending away from Ticketmaster. Baseball (MLB) tickets are now directly sold through the MLB. At least some (all?) American Football (NFL) teams have started partnering with SeatGeek. Basketball (NBA) and Ice Hockey (NHL) still seem to be through Ticketmaster.