Querying a table with an XML column over a linked server fails with Msg 9514: XML data type is not supported in distributed queries. Here is the fix.
SQL SERVER – New Way to Use DBCC Page in SQL Server 2019
SQL Server 2019 brings a new function that partly replaces DBCC PAGE. I compare the old and the new way to read page information with a small demo.
SQL SERVER 2019 – Oracle JRE 7 Update 51 (64 Bit) or Higher is Required
Installing SQL Server 2019 CTP with all features, setup stopped me with: Oracle JRE 7 Update 51 (64-bit) or higher is required for PolyBase. I explain why it asks.
Intelligent Query Processing: Checking What Is On per Database
Check intelligent query processing by database compatibility level, scoped switches, and actual plan evidence before comparing servers.
Scalar UDF Inlining: When Old Functions Suddenly Get Fast
Check scalar UDF inlining eligibility, database settings, function options, and execution plans before claiming a performance improvement.
The Last Actual Execution Plan: LAST_QUERY_PLAN_STATS in Practice
Capture the last actual execution plan with LAST_QUERY_PLAN_STATS, inspect runtime rows, and understand what cache retention cannot provide.
Scalar Functions and Performance
Scalar functions can hide row-by-row work in SQL Server; learn when inlining helps, how to inspect eligibility, and when a set-based rewrite wins.