Fundamentals of table expressions, Part 4 – Derived tables, optimization considerations, continued Continuing his series on table expressions in SQL Server, Itzik Ben-Gan discusses more considerations for performance and efficiency. Itzik Ben-Gan ◆ July 8, 2020 2
Fundamentals of table expressions, Part 3 – Derived tables, optimization considerations Itzik Ben-Gan continues his series on table expressions in SQL Server, with some things you should keep in mind for performance and efficiency. Itzik Ben-Gan ◆ June 10, 2020 1
Visualizing the Tipping Point with Plan Explorer Greg Gonzalez shows off some new functionality in SentryOne Plan Explorer that literally visualizes the tipping point overlaying the histogram. Greg Gonzalez ◆ May 7, 2020 4
"0 to 60" : Switching to indirect checkpoints Aaron Bertrand talks about a recent change where he started turning on indirect checkpoints across all user databases. Aaron Bertrand ◆ May 1, 2020 4
New Metadata-Only Column Changes in SQL Server 2016 Paul White investigates the new metadata-only column data type changes possible in SQL Server 2016 when using data compression. Paul White ◆ April 17, 2020 3
Bandwidth-friendly Query Profiling for Azure SQL Database This script to update the default extended events session for ADS Profiler will make for a safer and more bandwidth-friendly query capture experience for Azure SQL Database. Greg Gonzalez ◆ April 15, 2020 0
Finding Distinct Values Quickly Paul White explains a few different ways to retrieve distinct values from a table, including some big "it just runs faster" wins in SQL Server 2019. Paul White ◆ March 17, 2020 1
Why Wait Stats Alone Are Not Enough Tuning SQL Server by looking at waits alone and ignoring resources could be costing you time, money, and performance. Greg Gonzalez explains why. Greg Gonzalez ◆ January 24, 2020 5
Fun with (columnstore) compression on a very large table – part 2 Aaron Bertrand continues his series on investigating compression for a 1TB table, honing in on clustered columnstore and partitioning. Aaron Bertrand ◆ January 7, 2020 0
Fun with (columnstore) compression on a very large table – part 1 Aaron Bertrand starts a series looking at using clustered columnstore indexes and page compression to address storage footprint for a 1TB table. Aaron Bertrand ◆ December 27, 2019 0
Azure Virtual Machines for SQL Server Usage Glenn Berry describes different types of Azure VMs and explains which might be better suited to your SQL Server workload. Glenn Berry ◆ December 17, 2019 1
