Tag Archives: sql server

The Growth of IQP

Posted on October 3, 2022 by way0utwest

When Microsoft started to talk about Intelligent Query Processing (IQP) before SQL Server 2017, I wasn’t sure what to think. There was a diagram with 20 things on it, and only 5 were highlighted (you can see that in the … Continue reading →

Posted in Editorial | Tagged , | Comments Off on The Growth of IQP

T-SQL Tuesday #154–Thinking about SQL Server 2022

Posted on September 13, 2022 by way0utwest

This month is an interesting T-SQL Tuesday party, as Glenn Berry hosts and asks us to think about the upcoming new release of SQL Server. Sometime later this year, I expect SQL Server 2022 to be released and Glenn is … Continue reading →

Posted in Blog | Tagged , , | 3 Comments

What Do We Want to See in SQL Server?

Posted on August 5, 2022 by way0utwest

I like the feedback system that Microsoft built for SQL Server. This used to be the Connect system, but all the bug reports and feature requests are now at feedback.azure.com. That’s the place where you can send notes to Microsoft … Continue reading →

Posted in Editorial | Tagged , | 1 Comment

New in SQL Server 2022 – Generate_Series

Posted on June 20, 2022 by way0utwest

One of the new language features added in SQL Server 2022 is the GENERATE_SERIES function. This allows you to generate a SELECT * FROM GENERATE_SERIES(start=1, stop=7) This gives me a simple sequence of numbers in a result set, with the … Continue reading →

Posted in Blog | Tagged , , | Comments Off on New in SQL Server 2022 – Generate_Series