Category: SQL Server (3)

Kevin Kline provides an overview of the support options available for SQL Server versions that have reached end of life.
May 13, 2020 | Kevin Kline | SQL Server, Support 1
Kevin Kline recaps his "SQL Server Indexing for Developers and Accidental DBAs" webinar and answers attendees questions with Sebastian Meine.
April 23, 2020 | Kevin Kline | SQL Server, Indexes 0
Itzik Ben-Gan starts a new series discussing the fundamentals of table expressions, a commonly misunderstood feature in T-SQL.
Kevin Kline shares how to assess query performance, guarantee consistent query tuning, and avoid performance killers in SELECT statements.
April 7, 2020 | Kevin Kline | Plan Explorer, SQL Server 1
Aaron Bertrand continues his series on replacing the default trace with a more efficient and more complete Extended Events session.
April 6, 2020 | SQLPerformance.com | SQL Server, Trace 0
Erin Stellato walks through her multi-step approach to index tuning, with thorough explanations and simple but clever visualizations.
March 26, 2020 | SQLPerformance.com | SQL Server, Indexes 0
Aaron Bertrand pushes for improvements to STRING_SPLIT in the next version of SQL Server. See how you can help!
March 20, 2020 | SQLPerformance.com | SQL Server 0
Kevin Kline recaps a webinar with the SQLskills team, where they discussed their top SQL Server troubleshooting horror stories and the lessons learned.
Continuing his treatment of NULLs in SQL Server, Itzik Ben-Gan covers how SQL Server's implementation of unique constraints differs from the standard, and how you can work around it.
March 11, 2020 | SQLPerformance.com | T-SQL, SQL Server 0
Jonathan Kehayias starts a new blog series where he tests the impact that a specific plan shape might have on ASYNC_NETWORK_IO waits.
Kevin Kline recaps his recent webinar on an Introduction to SQL Server Internals & Architecture and shares answers to attendees' technical questions.
February 25, 2020 | Kevin Kline | SQL Server, Webinar 0
Adrian Hills explains that in the SQL Server database development world, the instinct to not repeat yourself could bite you if you're not careful.
February 20, 2020 | Adrian Hills | SQL Server, Engineering 0
John Welch shares a script for checking MAXDOP, a SQL Server setting that controls how many processors may be used for parallel plan execution.
February 18, 2020 | John Welch | Performance, T-SQL, SQL Server, MAXDOP 0
In a new blog, Brooke Philpott discusses how the SQL Server trace collection engine evolved over time and what the future holds.
February 13, 2020 | Brooke Philpott | SQL Server, Trace 0
Itzik Ben-Gan discusses missing T-SQL features like the DISTINCT FROM predicate, the NULL treatment clause, and controlling how NULLs are ordered.
February 12, 2020 | SQLPerformance.com | T-SQL, SQL Server 0

Top Categories

See all

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

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