Paul White

@SQL_Kiwi

I live in Aotearoa New Zealand and write about SQL Server internals at sql.kiwi Microsoft MVP 2011-2022 DBA Stack Exchange Mod 2015-2025

Paraparaumu, New Zealand

Pinned
Paul White
@SQL_Kiwi
Apr 17, 2025
New article: How to Survive a Rollback (when logging) How to ensure log messages are always written to the database, even when a containing transaction rolls back.
How to Survive a Rollback (when logging)
From sql.kiwi
1
Paul White
@SQL_Kiwi
Jul 13
RIP Sam Neill. Great actor, great winemaker, great New Zealander. Difficult not to take these things unreasonably personally.
Paul White
@SQL_Kiwi
May 25, 2025
I don't really understand why anyone is excited about nested CTEs, but if you want to try it on SQL 2025 CTP2 box, enable TF 15320 (session or global). Currently only documented for 'Fabric' whatever that is
Nested Common Table Expression (CTE) - SQL Server
From learn.microsoft.com
1
Paul White
@SQL_Kiwi
May 22, 2025
Looks like 'expression indexes' are coming to SQL Server 2025. This is valid syntax on CTP 2 when trace flag 17152 is enabled: CREATE INDEX ix ON MyTable (n * 2); It creates a computed column for you, named e.g. $expression_index_B18729F8A924473FA0DF2CB95D9B2E01.
3
Paul White
@SQL_Kiwi
May 21, 2025
Interesting undocumented USE HINTs in SQL Server 2025 CTP 2: * DISABLE_PERFORMANCE_SORT_FOR_DML sets DMLRequestSort to false like TF 8795 * DISABLE_OPTIONAL_PARAMETER_OPTIMIZATION * PARALLEL_DML_FOR_VECTOR_INDEX_BUILD * DISABLE_SCALABLE_SUBTREE