SQL Server 2019

What’s New in SQL Server 2019’s sys.messages: More Unannounced Features

September 24, 2018

SQL Server 2019

The system table sys.messages holds error messages that SQL Server needs to return to end users. When a new build comes out, I love checking this table to see what features Microsoft has coded, but isn’t quite ready to announce yet. When SQL Server 2017 came out, that’s how I unmasked snapshot materialized views, a…

What’s New in SQL Server 2019: Faster Table Variables (And New Parameter Sniffing Issues)

September 24, 2018

Brent Ozar

Parameter Sniffing, SQL Server 2019, T-SQL

For over a decade, SQL Server’s handling of table variables has been legendarily bad. I’ve long used this Stack Overflow query from Sam Saffron to illustrate terrible cardinality estimation: Transact-SQL declare @VoteStats table (PostId int, up int, down int) insert @VoteStats select PostId, up = sum(case when VoteTypeId = 2 then 1 else 0 end), down…

What’s New in SQL Server 2019: Adaptive Memory Grants

September 24, 2018

Brent Ozar

Execution Plans, Memory Grants, Parameter Sniffing, SQL Server 2019

When you run a query, SQL Server guesses how much memory you’re going to need for things like sorts and joins. As your query starts, it gets an allocation of workspace memory, then starts work. Sometimes SQL Server underestimates the work you’re about to do, and doesn’t grant you enough memory. Say you’re working with…

Leaked: SQL Server 2019 Big Data Clusters Introduction Video

September 22, 2018

Brent Ozar

SQL Server 2019

Psst – you’re probably not supposed to see this yet, but look what @WalkingCat found: SQL Server 2019 Vision pic.twitter.com/zbjI28FYSu — WalkingCat (@h0x0d) September 21, 2018 What the video says Growing volumes of data create deep pools of opportunity for those who can navigate it. SQL Server 2019 helps you stay ahead of the changing time…

Announcing SQL Server 2019

September 8, 2018

Erik Darling

SQL Server 2019

TEASE Who Let The Docs Out? Ignite must be coming up. If you head over to Microsoft’s GitHub repo, you can peruse around for stuff updated recently. Maybe you’ll create an account. Maybe you’ll start contributing to open source projects. Maybe you’ll quietly slip into a world of solitude for days on end. Happy Saturday!…

10 SQL Server Feature Requests I’ve Upvoted Recently

July 4, 2018

Brent Ozar

SQL Server 2019

In no particular order: Database Level Option for Storing Wait Stats – just like we can store query plan history in Query Store, it’d be awesome to get performance history over time. Give more info on the “String or Binary Data Would be Truncated” error – tell us which column, and what row tried to…

Froid: How SQL Server 2019 Will Fix the Scalar Functions Problem

January 29, 2018

Brent Ozar

SQL Server, SQL Server 2019

froid

Scalar functions and multi-statement table-valued functions are notorious performance killers. They hide in execution plans, their cost is under-estimated, the row estimates are way off, they cause queries to go single-threaded, I could go on and on. Microsoft is bringing a fix in SQL Server 2019, and thanks to a newly published paper, we know…

Contest: Guess the SQL Server 2019 Release Date

December 1, 2017

Brent Ozar

SQL Server 2019

592

When will Microsoft officially release SQL Server 2019 for download? The dust is just barely starting to settle on the 2017 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…

Coming in SQL Server 2019: Approximate_Count_Distinct

November 8, 2017

Brent Ozar

SQL Server 2019

approximate_count_distinct

Last week at the PASS Summit in Seattle, Kevin Farlee & Joe Sack ran a vNext demo in the Microsoft booth and dropped a little surprise. SQL Server 2019 will let you trade speed for accuracy. I have had approximately all of the breakfast margaritas They’re working on a new APPROXIMATE_COUNT_DISTINCT. It would work like…

What Would You Put in SQL Server 2019?

September 20, 2017

Brent Ozar

SQL Server 2019

184

If you were leading Microsoft’s development programs, what would you add or change in SQL Server 2019? Forget licensing or pricing changes – that’s dictated by the marketing teams, and those decisions are made really close to the release date. Instead, let’s think bigger: what are the really big improvements you’d make that would really…

Upcoming SQL Server 2019 Features

August 31, 2016

Brent Ozar

Humor, SQL Server 2019

If you think that’s big, you should see the size of the drink I happened to be in Seattle this week after finishing up an Alaska cruise, and I had the chance to sit down with some of the PMs responsible for upcoming SQL Server features. It turns out they’re already deep in development with…