Redmond

Deep Dive into SQL Server 2022's Query Performance Features, Part 2: PSP Optimization

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

SQL Server Express-- "Hangs" on simple query of a single table

I have a test server hosting several sites using SQL Server Express and SQL Management Studio Express. I've seen one site have an occasional issue where queries to a particular table (the "SiteUsers" ...
Redmond

A Deep Dive into SQL Server 2022's Query Performance Features, Part 1

An update to the cardinality estimator feature in SQL Server 2022 will be one of the biggest changes to the database engine since its inception. Database engines like SQL Server are incredibly complex ...