Standard-Edition

Tag: standard-edition

Erik Darling and Kendra Little Talk AI, Databases, and SQL Server 2025

Erik Darling and Kendra Little Talk AI, Databases, and SQL Server 2025

By Kendra Little on December 9, 2025

Category: database-administration , sql-server
Tags: dear-sql-dba , ai-tools , sql-server-2025 , resource-governor , query-store , erik-darling , standard-edition , readable-secondaries

Erik Darling joins me on the Dear SQL DBA Podcast to chat about AI tools, why they work better for Python and PowerShell than SQL, and what’s exciting (and what’s not) in SQL Server 2025.

Along the way we describe the ONE THING we always want to configure in Resource Governor, why at least one SQL Server 2025 feature should be backported to 2022, and whether the universe is text files all the way down.

Continue reading

Adaptive Queries in Standard Edition: Interleaved Exec for Multi-Statement TVFs

Adaptive Queries in Standard Edition: Interleaved Exec for Multi-Statement TVFs

By Kendra Little on April 4, 2018

Category: execution-plans , functions , sql-server , table-valued-functions
Tags: interleaved-execution , adaptive-query-processing , table-valued-functions , standard-edition

It’s tough to keep track of which features work in each version of SQL Server, and which Editions support them.

My memory told me that the new Adaptive Joins feature in SQL Server 2017 was Enterprise Edition only…  and that’s correct, but I didn’t realize that the fancy new feature to make Multi-Statement TVFs smarter has much wider licensing.

Continue reading