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.
Category: SQL Server
Aaron Bertrand shares his slide decks and demos from two recent presentations at CodeStock in Knoxville, TN.
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.
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.
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.
Glenn Berry talks about the blazing speeds of the latest Intel Optane gear from Intel, and how they can improve your SQL Server workloads.
Jonathan Kehayias shows why it can be beneficial to use the RETURNS NULL ON NULL INPUT option for scalar UDFs.
In his inaugural SentryOne Community Omnibus post, Kevin Kline shares the latest SentryOne webinars, resources, blogs, and press releases.
Paul White dives into histograms and explains how the optimizer uses coarse alignment for cardinality estimates.
Kevin Kline shares highlights from the PASS Summit 2018 keynote with Raghu Ramakrishnan.
Kevin Kline shares highlights from Rohan Kumar's PASS Summit 2018 keynote, "SQL Server and Azure Data Services: Harness the future with the ultimate hybrid platform for data and AI."
Learn about this HUGE opportunity to influence the Microsoft Data Platform products and services you use daily while attending the PASS Summit!
Tim Radney talks about some of the things you can do to prepare for the end of extended support for SQL Server 2008 and SQL Server 2008 R2.
Today Microsoft announced the first public preview of SQL Server 2019. I've got some exclusive details over at MSSQLTips.com.
