SQLPerformance.com - SQL Server Performance Articles

Sometimes you CAN upsize a column in-place

Altering a fixed-width column on a large table can often mean either a lot of planning or a lot of downtime, but in some scenarios there may be an easy out.

Aaron Bertrand ◆ August 19, 2020

0

Fundamentals of table expressions, Part 5 – CTEs, logical considerations

Continuing with table expressions, Itzik Ben-Gan compares CTEs to derived tables and addresses some logical considerations.

Itzik Ben-Gan ◆ August 12, 2020

8

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

4

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