Top all-time · #25501
Remus Rusanu
Personal blog · rusanu.comprogrammingdata
Remus Rusanu's personal blog at rusanu.com covers programming and data. Since 2013, 3 different Hacker News readers have linked it 4 times, most often “Understanding how SQL Server executes a query”. The last post was in 2017, but the archive is still widely read.
Too few sampled comments (3) to say how often HN recommends it.?
Why HN links it
Linked for posts on SQL Server internals, including a 2008 note on certificates with future validity times and an article on how the query optimizer works. Comments cite them as references without judging the writing.
Summarised by Claude from a sample of 3 HN comments that link here. Each comment is marked recommending, critical or neutral (citing without judging); how this works.
Remus Rusanu blog
Most-linked posts?
- Understanding how SQL Server executes a query2 people · 2 mentions · first linked 2013-08-01
What Hacker News says?
>Perhaps one day I will learn how to write HN clickable URLs... Leading space is for preformated text and is mostly useful for code. For everything else, don't add leading space. Do add extra line breaks, though. Here are your links with extra line breaks and without leading space, thus nicely presented and clickable. [0] https://medium.com/@rusanu/why-i-have-high-hopes-for-the-qua... [1] http://rusanu.com/2009/05/1…
Comment linking /2009/05/15/version-control-and-your-database/
on “Stack Overflow: How We Do Deployment”Submitted Understanding how SQL Server executes a query as a story · 1 points
HN discussionSQL Server 2005 actually shipped with code that used the local time instead of UTC time in CREATE CERTIFICATE. Users in Western hemisphere (local time behind UTC) had no major problems because of it, but users in Eastern hemisphere (local time ahead of UTC) would create certificates not yet valid . Confusing, to say the least. See http://rusanu.com/2008/08/25/certificate-not-yet-valid/
Comment linking /2008/08/25/certificate-not-yet-valid/
on “Unit tests fail when run in Australia”I have a blog article that covers a bit more details: http://rusanu.com/2013/08/01/understanding-how-sql-server-ex...
Comment linking /2013/08/01/understanding-how-sql-server-executes-a-query/
on “How Does the SQL Server Query Optimizer Work?”