SQLPerformance.com - Page 2 of 40 - SQL Server performance articles curated by SentryOne

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

NULL complexities – Part 3, Missing standard features and T-SQL alternatives

Itzik Ben-Gan discusses missing T-SQL features like the DISTINCT FROM predicate, the NULL treatment clause, and controlling how to order NULLs.

Itzik Ben-Gan ◆ February 12, 2020

1

Fun with (columnstore) compression on a very large table – part 3

Aaron Bertrand continues his series on large table compression with results from row and page compression as well as a process involving scheduler manipulation.

Aaron Bertrand ◆ February 3, 2020

1