Category: SQL Server

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
Paul White takes a deep dive into SQL Server batch mode bitmaps revealing undocumented details that can greatly impact performance.
August 23, 2019 | SQLPerformance.com | Performance, SQL Server 0
MSPs are smart to choose database solutions, including monitoring tools, that offer the same performance regardless of whether their clients' databases are located on-premises or in the cloud.
Paul White explains minimal logging for inserts into b-tree indexes using Fast Load Context, and why it might not always work as expected.
May 29, 2019 | SQLPerformance.com | SQL Server, Indexes 0
Erin Stellato discusses the performance impact of a predominately adhoc workload in SQL Server.
Paul White explains in detail the factors SQL Server considers when enabling minimal logging for inserts into an empty clustered table.
1 2 3 4 5

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