Team Blog

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
SQL Server 2014 is now at Service Pack 3, with plenty of enhancements back-ported from recent SQL Server 2016, 2017, and 2019 updates.
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
The user documentation for the new SentryOne Test product is now available on the SentryOne Docs website.
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
Poor-quality data is a common problem that affects companies of all sizes in all industries. Understanding where to implement data validation tests to solve for it is another challenge.
April 9, 2019 | John Welch | SentryOne, SentryOne Test 0
Glenn Berry talks about the AMD EPYC CPUs now found in Azure Virtual Machines (in some regions) and their usage in balanced SQL Server workloads.
April 8, 2019 | SQLPerformance.com | Azure 0
In April 2018, SentryOne opened its first international office with the establishment of its EMEA headquarters in Dublin, Ireland.
April 5, 2019 | Bob Potter | SentryOne, SentryOne EMEA 0

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