Browse by Tags

• logic
• Performance

• Who's On First? Solving the Top per Group Problem (Part 1: Technique)

  Relative comparison is a simple matter of human nature. From early childhood we compare and contrast what we see in the world around us, building a means by which to rate what we experience. And as it turns out, this desire to discover top and bottom, Read More... Posted Friday, February 08, 2008 7:09 PM by Adam Machanic | 18 Comments Filed under: logic, Performance, Query Tuning, T-SQL

• Medians, ROW_NUMBERs, and performance

  A couple of days ago, Aaron Bertrand posted about a method for calculating medians in SQL Server 2005 using the ROW_NUMBER function in conjunction with the COUNT aggregate. This method (credited to Itzik Ben-Gan) is interesting, but I discovered an even Read More... Posted Monday, December 18, 2006 3:52 PM by Adam Machanic | 6 Comments Filed under: Performance, Query Tuning, T-SQL

• Scalar functions, inlining, and performance: An entertaining title for a boring post

  Scalar. Function. Wow. Could any other combination of words evoke the same feeling of encapsulation, information hiding, and simplification of client code? After years spent developing software in the procedural and OO worlds, it can be difficult--perhaps, Read More... Posted Friday, August 04, 2006 12:07 AM by Adam Machanic | 28 Comments Filed under: Performance, Query Tuning, T-SQL

• Paging in SQL Server 2005

  I keep seeing questions on newsgroups about paging in stored procedures, and whether there will be a better way in SQL Server 2005. However, aside from a few answers in newsgroups, I haven't seen any content on how to do it. So I'd like to spend a few Read More... Posted Wednesday, July 12, 2006 10:12 PM by Adam Machanic | 3 Comments Filed under: Performance, Query Tuning, T-SQL