Join Microsoft MVP Steve Endow as he demonstrates some simple techniques that mere mortals can use to diagnose and optimize SQL Server queries. Topics will include identifying problem queries, ...

In part 1 of my SQL Server 2022 features series, you learned about the improvements to the cardinality estimator component of query optimization. In this installment, you will learn about another ...

This book aims to give you the tools and knowledge to get peak performance from your queries, how does it fare? The book, which is largely an update to the author’s Microsoft SQL Server 2014 Query ...

As I discussed in an earlier column, SQL Server keeps a plan cached for each query it sees (assuming the query requires planning in the first place, of course). That's great for speeding up processing ...

In SQL Server 2017, when the query optimizer encounters code with a multi-statement TVF, the query optimizer will pause optimization, execute the TVF subtree to get a very accurate cardinality ...

T-SQL (Transact-SQL) is a set of programming extensions from Sybase and Microsoft that add several features to the Structured Query Language (SQL), including ...

What exactly does 1 unit of cost represent in SQL Query Analyzer execution plans? [ie: Subtree Cost: 41.2134] Obviously it is some form of measurement since a very simple "select @@version" is like ...

Structured Query Language (SQL) is a standardized programming language that is used to manage relational databases and perform various operations on the data in them. Initially created in the 1970s, ...

Watch this recorded webinar where Microsoft MVP Steve Endow demonstrates some simple techniques that mere mortals can use to diagnose and optimize SQL Server queries. Topics include identifying ...