In SQL Server 2017, when the query optimizer encounters code with a multi-statement TVF, the query optimizer will pause optimization, execute the TVF subtree to get a very accurate cardinality ...

Today, at its Ignite conference in Orlando, Microsoft is announcing the general availability of a new version of its flagship operational database, SQL Server 2017. SQL Server is a product I have ...

Efficient query processing is underpinned by the design and implementation of novel data structures and algorithms that address the increasing demands of modern data-intensive applications. Recent ...

Thanks to the technology behind ChatGPT, it’s become surprisingly simple to query a data set in plain English. As with most generative AI, results from OpenAI’s API are still imperfect, which means ...