In this blog post, Solutions Engineer Alec Pickup answers questions from his recent webinar “Tools for Productivity & Performance.”
Category: SQL Server
Itzik Ben-Gan discusses the ins and outs of numbering and retrieving rows in a nondeterministic (but explicitly not random) order.
Tips for proper planning, best practices, and how our solutions can help ensure high-quality performance in virtualized SQL Server implementations.
Erin Stellato shows how to analyze patterns in your workload when dealing with many short, resource-intensive queries.
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.
In this blog post, we answer your top questions on the top concepts that every SQL Server generalist or accidental DBA has to learn.
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.
Paul White takes a deep dive into SQL Server batch mode bitmaps revealing undocumented details that can greatly impact performance.
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.
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.
