Team Blog

Find information about the builds of SQL Server Management Studio in the new release cycle approach; locate previous versions.
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.
Find out the build number of each SQL Server 2017 build as it is released, discover where to download, and how to get details on new fixes and features.
See updated downloads, security fixes, release notes, and observed changes for builds of SQL Server 2016.

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

Get a Free 2-Week Trial

Start your free trial of any of our products today.

Free Trial

2-Week Trial