SQL Server 2025 sp_columns Omits JSON and Vector Columns

· by · in

SQL Server 2025 filters json and vector columns from sp_columns and ODBC catalog output. I tested the alternatives.

What Is openrowset auto_create_statistics Connected To?

· by · in

I traced the undocumented openrowset auto_create_statistics option through SQL Server inventory, Microsoft docs, and a local 2025 test.

Cloud Feature Wait Types in Boxed SQL Server

· by · in

SQL Server includes wait types named for Synapse Link, Trident, DW, and Parquet. I checked which ones exist and whether they collect counts.

Idle SQL Server Instances Still Accumulate Undocumented Wait Types

· by · in

I sampled two idle SQL Server instances and found undocumented wait types with non-zero counts. Here is how I keep them visible but out of top waits.

Error Message Text Is Not an Alerting Contract

· by · in

SQL Server message text changes between versions. Key alerts on message ID and severity, then diff sys.messages before an upgrade.

How Approximate Are SQL Server 2022 XTP Hash Index Stats?

· by · in

I tested SQL Server’s undocumented XTP hash index approximation function against the documented DMV on one scratch table.