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
Fundamentals of table expressions, Part 2 – Derived tables, logical considerations Itzik Ben-Gan continues his series on table expressions in SQL Server, explaining several use cases, pitfalls, and syntax wishlist items. Itzik Ben-Gan ◆ May 13, 2020 3
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
Updated Azure SQL Database Tier Options Tim Radney explains many new options for Azure SQL Database, including serverless, hyperscale, and hardware configuration optimized for CPU or memory. Tim Radney ◆ April 27, 2020 0
Removing the default trace – Part 3 Aaron Bertrand finishes up his series on replacing the default trace with views to simplify consumption and a caveat about reports in SSMS. Aaron Bertrand ◆ April 22, 2020 0
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
An approach to index tuning – Part 2 Erin Stellato concludes her two-part series on her multi-step approach to index tuning in SQL Server. Erin Stellato ◆ April 13, 2020 1
Fundamentals of table expressions, Part 1 Itzik Ben-Gan starts a new series discussing the fundamentals of table expressions, a commonly misunderstood feature in T-SQL. Itzik Ben-Gan ◆ April 8, 2020 0
Removing the default trace – Part 2 Aaron Bertrand continues his series on replacing the default trace with a more efficient and more complete Extended Events session. Aaron Bertrand ◆ April 6, 2020 0
