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 ...

New AI capabilities help DBAs move from performance visibility to performance resolution--turning slow queries into actionable index recommendations in minutes HOUSTON, March 19, 2026 /PRNewswire/ -- ...

Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. Cory Benfield discusses the evolution of ...

In part 1 of my SQL Server 2022 features series, you learned about the improvements to the cardinality estimator component of query optimization. In this installment, you will learn about another ...

Last time, I discussed how to get PowerShell and SQLPS up and running on your machines. And much like my dog chasing its tail, you're probably asking yourself, "Now that I have it, what do I do with ...

As I discussed in an earlier column, SQL Server keeps a plan cached for each query it sees (assuming the query requires planning in the first place, of course). That's great for speeding up processing ...

Recent SQL Server 2025, Azure SQL, SSMS 22 and Fabric announcements highlight new event streaming and vector search capabilities, plus expanding monitoring and ontology tooling -- with tradeoffs in ...

I have been testing SQL Server 2008 RC0 (Release Candidate Zero) that was made available recently and I must admit I am beginning to like it. Even the new logo is growing on me. There are many new ...

Microsoft SQL Server's relational engine has offered new instrumentation that improves by light years with each new release. The introduction of Dynamic Management Views (DMVs) in SQL Server 2005 ...