Top all-time · #5489
Erland Sommarskog
Personal blog · sommarskog.sedataprogramming
Erland Sommarskog's personal blog at sommarskog.se covers data and programming. Since 2011, 15 different Hacker News readers have linked it 18 times, most often “Slow in the Application, Fast in SSMS? Understanding Performance Mysteries”. No feed was found, so read it on the site itself.
Too few sampled comments (7) to say how often HN recommends it.?
Why HN links it
Erland Sommarskog's long, technical SQL Server articles on query plans, parameter sniffing, error handling and stored procedures. HN readers link them as in-depth references.
Summarised by Claude from a sample of 7 HN comments that link here. Each comment is marked recommending, critical or neutral (citing without judging); how this works.
Most-linked posts?
- Slow in the Application, Fast in SSMS? Understanding Performance Mysteries6 people · 6 mentions · first linked 2013-04-19
- Slow in the Application, Fast in SSMS? Understanding Performance Mysteries2 people · 2 mentions · first linked 2023-09-18
What Hacker News says?
http://sommarskog.se/
Comment linking /
on “Ask HN: What are your favorite thin websites (text only or limited images)?”Submitted Slow in the Application, Fast in SSMS? Understanding Performance Mysteries as a story · 1 points
HN discussionI disagree with this article. SQL is an decent (though crusty) language when used specifically for the purposes of interacting with relational databases. The fact that most database vendors have hacked mutually incompatible proprietary extensions on-top of it for doing other tasks doesn't make it a good choice for them. Why would you use SQL over a language that has been specifically designed for code reuse, integra…
Comment linking /share_data.html
on “Mythbusters: Stored Procedures Edition”Submitted Slow in the Application, Fast in SSMS? as a story · 1 points
HN discussionAnother reason to write your own technical content, even if a similar question/answer does exist on SO, especially in examples where you experiment to put together examples that show/prove a point, is that it is practise for yourself. I intend to get some of my own content out there (it may never happen, the intention has existed for quite some time!) and if I ever find time to do it some of the things I might inclu…
Comment linking /
on “Technical blogging in the era of Stack Overflow”Submitted The Curse and Blessings of Dynamic SQL as a story · 1 points
HN discussionYeah, parameter sniffing is also a concern and a thing you have to manage on the SQL Server side - it's led to probably the most venerable article on the topic in that community - http://www.sommarskog.se/query-plan-mysteries.html
Comment linking /query-plan-mysteries.html
on “Life of a Sql Query”Submitted Using a Table of Numbers as a story · 1 points
HN discussionI made an app that generated reports. The queries ran quickly when I tested it directly on the database but when I ran my app it would hang on a particular query. Sometimes. I started making some small seemingly insignificant changes to my code and suddenly my app generated all the reports quickly. All was well until the next month when I had to generate the same reports and my app failed on the same query. I solved…
Comment linking /query-plan-mysteries.html
on “Code that breaks 2 or 3 times every month”Submitted Slow in the Application, Fast in SSMS? (2011) as a story · 1 points
HN discussionFor SQL Server there’s a very nice article on making query plans more predictable here: http://www.sommarskog.se/query-plan-mysteries.html
Comment linking /query-plan-mysteries.html
on “Can adding an index make a non SARGable query SARGable?”Submitted SQL Server: Understanding Performance Mysteries as a story · 1 points
HN discussionIf you want to trully know how thing works I suggest great blog: http://sommarskog.se/error_handling/Part1.html http://sommarskog.se/error_handling/Part2.html http://sommarskog.se/error_handling/Part3.html More than 100 pages of technical knowledge. And presentation: http://www.sommarskog.se/present/WhenThingsGoWrong%20(SQLSat...
Comment linking /present/WhenThingsGoWrong%20(SQLSat%20706).zip
on “SQL Server Error Handling Gotchas”Submitted Slow in the Application, Fast in SSMS? Understanding Performance Mysteries as a story · 1 points
HN discussionSubmitted Dynamic Search Conditions in T-SQL as a story · 1 points
HN discussion
