Joey on SQL Server Deep Dive into SQL Server 2022's Query Performance Features, Part 2: PSP Optimization Reduce workload times with this handy feature that can benefit every database pro.

See performance gains by using indexed views in SQL Server Your email has been sent A view is a saved T-SQL query in SQL Server. The view definition is stored by SQL Server so that it can be used ...

Microsoft technical fellow David DeWitt talks about Microsoft's new database research labs first key goal: building massive parallel processing into SQL Server.

Here is a list of common wait types and techniques that every DBA (or wannabe DBA) should know. While there are many more wait types than listed here, understanding these will give you a leg up when ...

In early November 2021, Microsoft announced the private preview of its flagship database product, SQL Server 2022. At some point in 2022, we will see SQL Server 2022 released as a general availability ...

Check this tip to increase the 'min memory per query' option to improve the performance of queries that use hashing or sorting operations, if your SQL Server has a lot of memory available and ...

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.