SQLPerformance.com - SQL Server Performance Articles

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

Removing the default trace – Part 1

Aaron Bertrand starts a series explaining how he evaluated the default trace and decided to replace it with a slimmer Extended Events session across all of production.

Aaron Bertrand ◆ March 2, 2020

0

Azure SQL Managed Instance Performance Considerations

Tim Radney talks about how to decide whether a move to Azure SQL Database Managed Instance makes sense and, if so, which tier.

Tim Radney ◆ February 26, 2020

4

SQL Server 2019 Cumulative Update #2

SQL Server 2019 Cumulative Update #2 is now available, with 134 fixes and improvements. Build # is 15.0.4013.40.

Aaron Bertrand ◆ February 14, 2020

0