SQL Server 2022

PSPO: How SQL Server 2022 Tries to Fix Parameter Sniffing

Last Updated August 24, 2022

Parameter Sniffing, SQL Server 2022

Parameter sniffing is a notorious problem for Microsoft SQL Server because it tries to reuse execution plans, which doesn’t work out well for widely varying parameters. Here’s a primer for the basics about how it happens. SQL Server 2022 introduces a new feature called Parameter Sensitive Plan optimization. I’m not really sure why Microsoft capitalized…

What’s New in SQL Server 2022 Release Candidate 0: Undocumented Stuff

Last Updated August 25, 2022

Brent Ozar

SQL Server 2022

Microsoft has an official list of what’s new in 2022 overall, but here I’m specifically focusing on system objects that might be interesting to script developers like you and I, dear reader. New stored procedure sp_get_table_card_est_and_avg_col_len – I assume the “card” refers to statistics and cardinality, not Hallmark. SQL Server has historically struggled with memory…

How to Install SQL Server 2022 Release Candidate 0

Last Updated August 24, 2022

Brent Ozar

SQL Server 2022

SQL Server 2014’s end of support date is coming in less than two years: July 9, 2024. I know that sounds far-off right now, but consider the work you have to do between now and then: Pick a new version to migrate to Set up development SQL Servers for that new version Start developing &…

Pour One Out for Distributed Replay. It’s Deprecated in SQL Server 2022.

Last Updated June 20, 2022

Brent Ozar

SQL Server 2022

I love how Microsoft treats deprecated and discontinued features in SQL Server. No, seriously. I give Microsoft a lot of sarcasm and lip around here, but Microsoft takes serious care to make it easy to upgrade versions without worrying about your application breaking. If you disagree, hear me out for a minute. “Discontinued” means it’s…

SQL Server 2022 Tells You Why A Query Can’t Go Parallel.

Last Updated June 7, 2022

Brent Ozar

Execution Plans, SQL Server 2022

Until 2022, when a query couldn’t go parallel, all we got was a really cryptic note in the execution plan properties saying NonParallelPlanReason = CouldNotGenerateValidParallelPlan. But starting with SQL Server 2022, even when I’m running under older compatibility levels: ALTER DATABASE CURRENT SET COMPATIBILITY_LEVEL = 140; /* 2017 */ GO DECLARE @TableVariable TABLE(Total BIGINT); INSERT…

SQL Server 2022 Slogan Contest Winners

Last Updated November 17, 2021

Brent Ozar

SQL Server 2022

Last week, I challenged y’all to come up with slogans for SQL Server 2022. I have to confess that when I came up with the idea for that blog post, I thought y’all would take it seriously. I thought you’d come up with ideas that were meant to show off Microsoft’s hard work. I should…

Is Microsoft SQL Server 2022 a Big Release?

Last Updated November 11, 2021

Brent Ozar

SQL Server 2022

Normally when y’all post questions here on Pollgab, I let ’em pile up and I eventually do an Office Hours webcast where I talk through my answers. I check in on the list every couple of days just out of curiosity, though, and one of ’em jumped right out at me. The question, posed by…

What’s New in SQL Server 2022

Last Updated November 4, 2021

Brent Ozar

SQL Server, SQL Server 2022

Today at Microsoft Ignite, Microsoft started dropping new details on the next version of SQL Server, 2022. Here’s a 13-minute video from Bob Ward explaining and demoing some of the new features: The new features include: Failover back/forth from SQL Server 2022 and Azure SQL DB Managed Instances, including restoring versionless databases from Azure SQL…

Contest: Guess the SQL Server 2022 Release Date

Last Updated November 4, 2021

Brent Ozar

SQL Server, SQL Server 2022

370

When will Microsoft officially release SQL Server 2022 for download? The dust is just barely starting to settle on the 2019 box, so it’s time to guess the next one. Leave one – and only one – comment here in YYYY/MM/DD format with your release date guess. If you leave multiple comments, only the first/earliest…

SQL Server 2022

Save your cart?