Kevin Kline shares the slide deck and video from his recent webinar on reducing latency and boosting performance in SQL Server.
Category: T-SQL (7)
Aaron Bertrand shows the most efficient way to return a running MAX or MIN aggregate in a grouped SQL Server Query.
Aaron Bertrand shares his PowerPoint deck and sample code from his most recent SQL Saturday appearance.
Aaron adds a few tidbits to follow up on his popular post on cursor options.
Aaron Bertrand discusses a couple of potential problems that can occur when you are inconsistent about case sensitivity.
Paul White (@SQL_Kiwi) finishes up his series on the performance of calculating a median with a thorough treatment of eliminating bad elements fro
Paul White takes one more look at medians, this time describing how a locking hint can help improve the performance of a pre-2012 solution.
Paul White demonstrates another case where a cursor might be the most efficient approach to solving a typically set-based problem: median with a dynamic cursor.
Aaron Bertrand compares multiple date formatting techniques
Aaron Bertrand shows the ins and outs of a new function that a...
Aaron Bertrand takes a quick look at a couple of things you...
Aaron Bertrand walks through some of the new JSON-related Transact-SQL functionality that will be available in SQL Server 2016.
With detailed information and his uncanny knack for explaining technical concepts very well, Paul White concludes his series on ACID...
Aaron Bertrand continues his series on bad habits and best practices, this time focusing on the benefits of referencing columns in a query.
Aaron Bertrand follows up on a question from his triggers...
