Category: SQL Server

Paul White takes a deep dive into SQL Server batch mode bitmaps revealing undocumented details that can greatly impact performance.
August 23, 2019 | SQLPerformance.com | Performance, SQL Server 0
MSPs are smart to choose database solutions, including monitoring tools, that offer the same performance regardless of whether their clients' databases are located on-premises or in the cloud.
Paul White explains minimal logging for inserts into b-tree indexes using Fast Load Context, and why it might not always work as expected.
May 29, 2019 | SQLPerformance.com | SQL Server, Indexes 0
Erin Stellato discusses the performance impact of a predominately adhoc workload in SQL Server.
Paul White explains in detail the factors SQL Server considers when enabling minimal logging for inserts into an empty clustered table.
Itzik Ben-Gan resumes his blog series on T-SQL bugs, pitfalls, and best practices, treating an issue with correlated column references in subqueries.
Paul Randal provides a detailed introduction to troubleshooting SQL Server workload performance using wait statistics.
Paul White explains in detail the factors SQL Server considers when enabling minimal logging for inserts into a table without a clustered index.
With Azure SQL Data Warehouse and SentryOne, migrate to Azure with confidence and receive breakthrough cloud analytics performance at the best price.
Paul White goes deep on grouped aggregation pushdown, and explains examples where this optimization is unsuccessful or simply not attempted, using the undocumented command DBCC CSINDEX.
April 23, 2019 | SQLPerformance.com | SQL Server, ColumnStore 0
Aaron Bertrand shares his slide decks and demos from two recent presentations at CodeStock in Knoxville, TN.
April 13, 2019 | Aaron Bertrand | T-SQL, CodeStock, SQL Server 0
Itzik Ben-Gan asks you to invest in SQL Server's future by voting for Row Pattern Recognition, a potential T-SQL syntax extension he deems the next step in the evolution of window functions.
April 10, 2019 | SQLPerformance.com | T-SQL, SQL Server 0
Paul White explains why the IGNORE_DUP_KEY index option on a clustered index can result in much poorer performance than for a nonclustered unique index.
Rob Farley talks about filtered indexes and when you might want to add filtered columns to the index definition.
March 29, 2019 | SQLPerformance.com | T-SQL, SQL Server 0
Glenn Berry provides some details about how compatibility levels and the cardinality estimator have changed over the years, and why modern versions of SQL Server continue to be the better option.
January 29, 2019 | SQLPerformance.com | SQL Server 0

Top Categories

See all

Get the best SQL query analysis and optimization tool – free!

Plan-Explorer-logo-RGB-800px
  • Index Analysis Sandbox
  • Statistics Analysis with Histogram
  • Management Studio Add-in
  • Plan Diagram
  • Deadlocks
  • History and Comments
Free Download Learn More