Category: T-SQL

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
Aaron Bertrand addresses a popular theory that NOLOCK can substantially reduce locking overhead against #temp tables.
February 26, 2015 | Aaron Bertrand | T-SQL 5
Aaron Bertrand talks about a couple of subtleties of SQL Server's THROW statement, and how to avoid frustrating bouts of troubleshooting.
February 13, 2015 | Aaron Bertrand | T-SQL 1
Paul White explains various ways SQL Server makes runtime decisions about whether to use the b-tree structure or perform allocation or...
January 23, 2015 | | T-SQL 0
Aaron Bertrand shows how to use common table expressions...
January 12, 2015 | | T-SQL, SQL Server 2012 0
Aaron Bertrand walks through several potential causes for different plans for identical servers.
Lori Edwards reminds us about a couple of columns in sys.dm_exec_requests that can give us an idea about the progress of certain operations.
November 25, 2014 | Lori Edwards | T-SQL, Monitoring 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