Redmond Magazine

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

SQL Server 2022: Here’s what you need to know

SQL Server 2022: Here’s what you need to know Your email has been sent Three decades on, SQL Server is still a database workhorse that powers both an internal line of business applications and ...
Redmond Magazine

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 ...
Simon Fraser University

Running an SQL Query and Customizing the Output

When your SQL query is ready, you can run the query immediately or you can add a title, change its options, limit its output, and so on, to make the report look better. See Viewing the SQL Code, ...
TechRepublic

It’s time to get off Windows and SQL Server 2012 (or run them on Azure)

It’s time to get off Windows and SQL Server 2012 (or run them on Azure) Your email has been sent The release of Windows Server 2022 is a good reminder that older ...