Category: indexes

Paul White : Minimal Logging with INSERT...SELECT and Fast Load Context

Paul White explains minimal logging for inserts into b-tree indexes using Fast Load Context, and why it might not always work as expected.

Glenn Berry goes over three different tactics you can use to squeeze some extra performance out of SQL Server without a lot of heavy lifting.

Following up on her post about automatic plan correction, Erin Stellato talks about a new feature in Azure SQL Database: Automatic Index Management.

April 5, 2018 | SQLPerformance.com | Azure, Azure SQL Database, indexes 0

Monica Rathburn (@SQLEspresso) talks about a few of the more common elements she always checks for when troubleshooting I/O problems.

April 18, 2017 | SQLPerformance.com | disk performance, indexes, I/O 0

Aaron Bertrand (@AaronBertrand) kicks off his "Performance Myths" series, showing a "redundant" non-clustered index outperforming the cluste

March 17, 2017 | SQLPerformance.com | Plan Explorer, SQL Server, myths, indexes 0

Lori Edwards continues her series on SQL Server statistics, discussing some of the finer details around keeping stats up-to-date.

April 28, 2015 | Lori Edwards | update statistics, indexes, Statistics 1

Jason Hall shows us how table variables have changed in SQL Server 2014 and reminds us how helpful it can be to follow up on hard questions.

September 18, 2014 | Jason Hall | T-SQL, SQL Server, indexes, table variables 4

Erin Stellato of SQLskills compares the impact of adding additional index columns, by choosing