Category: SQL Server

How can DBAs and data architects improve performance for vendor locked systems that won’t allow them to fully ply their craft? Jason Hall shares where to start.
December 13, 2019 | Jason Hall | Performance, SQL Server 5
Itzik Ben-Gan kicks off a new series of Transact-SQL blog posts treating NULL handling in SQL Server.
December 11, 2019 | SQLPerformance.com | T-SQL, SQL Server 0
In this blog, Michele Crockett helps you get started on becoming proficient with all things Azure so you're ready when the cloud conversation starts.
December 3, 2019 | Michele Crockett | SQL Server, Azure 0
Aaron Bertrand shows a simple way to keep your filtered indexes effective even under forced parameterization.
December 3, 2019 | SQLPerformance.com | SQL Server, Indexes 0
Tim Radney talks about the performance trade-offs when deciding between various VM sizes in Azure.
November 18, 2019 | SQLPerformance.com | SQL Server, Azure 0
In this blog post, Solutions Engineer Alec Pickup answers questions from his recent webinar “Tools for Productivity & Performance.”
November 14, 2019 | Alec Pickup | SQL Server, SentryOne 0
Itzik Ben-Gan discusses the ins and outs of numbering and retrieving rows in a nondeterministic (but explicitly not random) order.
November 13, 2019 | SQLPerformance.com | SQL Server, SQL Server 2019 0
Tips for proper planning, best practices, and how our solutions can help ensure high-quality performance in virtualized SQL Server implementations.
October 31, 2019 | Kevin Kline | SQL Server, Hyper-V, Virtualization 0
Erin Stellato shows how to analyze patterns in your workload when dealing with many short, resource-intensive queries.
October 29, 2019 | SQLPerformance.com | SQL Server 0
Find out the build number of each SQL Server 2017 build as it is released, discover where to download, and how to get details on new fixes and features.
See updated downloads, security fixes, release notes, and observed changes for builds of SQL Server 2016.
Find information about the builds of SQL Server Management Studio (SSMS) in the new release cycle approach or locate previous versions.
September 24, 2019 | Community Team | Management Studio, SSMS, SQL Server 11
In this blog post, we answer your top questions on the top concepts that every SQL Server generalist or accidental DBA has to learn.
September 13, 2019 | Kevin Kline | SQL Server, Career 1
See the builds, release dates, and database versions of SQL Server 2019.
Glenn Berry talks about AMD's current streak of processor innovation and how the single socket EPYC may better serve your SQL Server workloads.
August 27, 2019 | SQLPerformance.com | 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