Anyone who’s spent years writing T-SQL has a mental list of “why doesn’t SQL Server just do this already?” moments. Here are 9 of those from Louis Davidson’s perspective – a wish list of practical, coding-oriented feature requests drawn from real-world pain points.
When I was asked about doing a post like this, I looked around at similar articles to make sure I wasn’t going to just repeat everyone’s list verbatim. I checked out Brent Ozar’s post (and definitely agreed that I would like to be able to write the FROM clause first), and Erland Sommarskog has a huge