News & features
Froid and the relational database query quandary with Dr. Karthik Ramachandra
Episode 73, April 24, 2019 - In the world of relational databases, structured query language, or SQL, has long been King of the Queries, primarily because of its ubiquity and unparalleled performance. But many users prefer a mix of imperative…
In the news | Microsoft Tech Community
Introducing Scalar UDF Inlining
First published on MSDN on Nov 07, 2018 | Last year SQL Server 2017 and Azure SQL Database introduced query processing improvements that adapt optimization strategies to your application workload’s runtime conditions. These improvements included: batch mode adaptive joins ,…
Optimizing imperative functions in relational databases with Froid
| Karthik Ramachandra
For decades, databases have supported declarative SQL as well as imperative functions and procedures as ways for users to express data processing tasks. While the evaluation of declarative SQL has received a lot of attention resulting in highly sophisticated techniques,…