SQLPerformance.com

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

SQL Server 2019 Cumulative Update #4

SQL Server 2019 Cumulative Update #4 is available, with 50 enhancements. The build number is 15.0.4033.1.

Aaron Bertrand ◆ March 31, 2020

0

An approach to index tuning – Part 1

Erin Stellato walks through her multi-step approach to index tuning, with thorough explanations and simple but clever visualizations.

Erin Stellato ◆ March 26, 2020

8

Please help with STRING_SPLIT improvements

Aaron Bertrand pushes for improvements to STRING_SPLIT in the next version of SQL Server. See how you can help!

Aaron Bertrand ◆ March 20, 2020

8

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

SQL Server 2019 Cumulative Update #3

SQL Server 2019 Cumulative Update #3 is available, with 56 enhancements. The build number is 15.0.4023.6.

Aaron Bertrand ◆ March 13, 2020

0

NULL complexities – Part 4, Missing standard unique constraint

Continuing his treatment of NULLs in SQL Server, Itzik Ben-Gan covers how SQL Server's implementation of unique constraints differs from the standard, and how you can work around it.

Itzik Ben-Gan ◆ March 11, 2020

0

Execution Plan Impact on ASYNC_NETWORK_IO Waits – Part 1

Jonathan Kehayias starts a new blog series where he tests the impact that a specific plan shape might have on ASYNC_NETWORK_IO waits.

Jonathan Kehayias ◆ March 5, 2020

2