See updated downloads, security fixes, release notes, and observed changes for builds of SQL Server 2016.
Paul White explains in detail the factors SQL Server considers when enabling minimal logging for inserts into an empty clustered table.
Aaron Bertrand shares his slides and demos from his most recent presentations at SQLDay in Wracłow, Poland.
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.
Itzik Ben-Gan resumes his blog series on T-SQL bugs, pitfalls, and best practices, treating an issue with correlated column references in subqueries.
I'll be speaking throughout the Nordics from 3rd May to 13th May 2019, from Reykjavik in the west to Helsinki in the east! The topics range from advanced SQL statement behavior and tuning to advanced scalability and performance settings for the SQL Server relational engine to cool query tuning techniques everyone who writes SQL code […]
Paul Randal provides a detailed introduction to troubleshooting SQL Server workload performance using wait statistics.
Aaron Bertrand announces that he is among the handful of community members in the inaugural group of official bloggers at PASS Summit 2019.
Kevin Kline shares more about the history of PASS and the assembling of the original board of directors.
Paul White explains in detail the factors SQL Server considers when enabling minimal logging for inserts into a table without a clustered index.
Guest author Dustin Dorsey shows how to prepare for a migration to Azure SQL Database by sending SentryOne monitoring data to the DTU calculator.
Latest builds of the SentryOne platform and Plan Explorer, as well as updated blog posts, downloads, and change lists.
Most organizations are familiar with the constant exercise of prioritizing price or performance, particularly in decisions about technology infrastructure. We know how tempting it can be to simply throw more hardware or compute power at a database performance problem. But even that short-sighted approach doesn’t work when budget is a concern.
Find information about the builds of SQL Server Management Studio in the new release cycle approach; locate previous versions.
Paul White goes deep on grouped aggregation pushdown, and explains examples where this optimization is unsuccessful or simply not attempted, using the undocumented command DBCC CSINDEX.