Category: T-SQL (7)

Kevin Kline shares the slide deck and video from his recent webinar on reducing latency and boosting performance in SQL Server.
Aaron Bertrand shows the most efficient way to return a running MAX or MIN aggregate in a grouped SQL Server Query.
October 8, 2015 | | T-SQL 0
Aaron Bertrand shares his PowerPoint deck and sample code from his most recent SQL Saturday appearance.
September 26, 2015 | Aaron Bertrand | SQLSaturday, T-SQL, Community 0
Aaron adds a few tidbits to follow up on his popular post on cursor options.
September 22, 2015 | | T-SQL 0
Aaron Bertrand discusses a couple of potential problems that can occur when you are inconsistent about case sensitivity.
August 7, 2015 | Aaron Bertrand | T-SQL 3
Paul White (@SQL_Kiwi) finishes up his series on the performance of calculating a median with a thorough treatment of eliminating bad elements fro
August 6, 2015 | | Execution Plans, T-SQL 0
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
June 29, 2015 | | T-SQL 0
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.
May 11, 2015 | Aaron Bertrand | SQL Server 2016, T-SQL, CTPs 10
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...
March 10, 2015 | | T-SQL, T-SQL Tuesday 0

Top Categories

See all
5 6 7 8 9

Get the best SQL query analysis and optimization tool – free!

  • Index Analysis Sandbox
  • Statistics Analysis with Histogram
  • Management Studio Add-in
  • Plan Diagram
  • Deadlocks
  • History and Comments
Free Download Learn More