Adaptive Query Processing in SQL Server 2017

ADAPTIVE QUERY PROCESSING IN SQL SERVER 2017 The next release of Microsoft SQL Server, announced as SQL Server 2017, is available for download in CTP2 at http://tinyurl.com/SQLvNextLinux and offers many cool new features. One set of features that I really like to focus on is adaptive query processing. These new features speed processing of workloads, especially those that have historically been the hardest to tune. READ MORE... Originally Posted July 05, 2017 … [Read more...]

Learn More About the SQL Server Cardinality Estimator

COOL FEATURES OF SQL SERVER 2014: IMPROVED CARDINALITY ESTIMATES With all the cheerleading and the steady drumbeat of new features being released to Azure, it's easy to lose track of the many cool and valuable new features released in the on-premises version of SQL Server. One of the crown jewels of SQL Server, the cardinality estimator (CE), underwent a large redesign for SQL Server 2014 to improve performance. Cardinality estimates are an extremely important part of query processing. In a nutshell, cardinality estimates are what the relational engine predicts for the number of rows affected … [Read more...]

Back in Atlanta! Wed, Feb 9 2011

I always enjoy spending time with my friends from Atlanta, as well as meeting folks and making new friends. If you live in the Atlanta area, I hope you'll join me on the evening of Wednesday, February 9th, 2011.  Details are at the Atlanta SQL Server user group website. It's common knowledge that I have a terrible memory for many things.  However, one of the few things that my memory is usually really good at is remember names & faces (and remembering stories, but that is another story as well). It's only in the last couple years that I've gotten to know Atlanta-area folks like Aaron … [Read more...]

Video: Magic Formula for SQL Query Tuning

Featuring Kevin Kline this video focuses on accelerated Disk Optimization and improved productivity with SQL Query Tuning. Posted December 18, 2006. … [Read more...]