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 ...

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 ...

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 ...

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 ...

Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. Ian Cooper discusses managing asynchronous ...

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 ...

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 ...

Microsoft has just added support for query hints to Azure SQL Database, giving database administrators a powerful tool to manage the performance of ISV application code. Here's how it works. Database ...

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, ...