Paul White @SQL_Kiwi

I live in Aotearoa New Zealand and write about SQL Server internals at https://t.co/nuZwOWQzHy Microsoft MVP 2011-2022 DBA Stack Exchange Mod 2015-2025 sql.kiwi Paraparaumu, New Zealand Joined April 2010

Tweets

14K
Followers

5K
Following

158
Likes

65K

Paul White @SQL_Kiwi

2 months ago

RIP Sam Neill. Great actor, great winemaker, great New Zealander. Difficult not to take these things unreasonably personally.

0 1 4 670 0

View Details

Paul White @SQL_Kiwi

a year ago

@Suriyakmaps No, it's fine

0 0 5 771 0

View Details

Paul White @SQL_Kiwi

a year ago

@jasonhorner dbt?

1 0 0 84 0

View Details

Paul White @SQL_Kiwi

a year ago

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 docs.microsoft.com/en-us/sql/t-sq…

1 2 12 1K 1

View Details

Paul White @SQL_Kiwi

a year ago

@sqL_handLe You're a very bad man! Nested views = bad Nested CTEs = good 🤯

1 0 6 76 0

View Details

Paul White @SQL_Kiwi

a year ago

Same here. I was most surprised to see genuinely nested CTEs added. I suppose someone, somewhere must have an absolutely compelling use case. The only upside can I think of otherwise is it would stop people writing the frankly offensive ";WITH"

1 0 2 105 0

View Details

Paul White @SQL_Kiwi

a year ago

@Citadel93 It doesn't really add anything new except easier syntax and more obvious feature parity with databases like Oracle, PostgreSQL, and DB2. We've always been able to index suitable non-persisted computed columns.

0 0 1 90 0

View Details

Paul White @SQL_Kiwi

a year ago

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 4 18 971 1

View Details

Paul White @SQL_Kiwi

a year ago

@jcoehoorn @kekline It seems to be exactly the same as creating a (non-persisted) computed column, then creating an index on that. A shorthand for that process.

0 0 0 59 0

View Details

Paul White @SQL_Kiwi

a year ago

@sqL_handLe Seems to be syntax sugar for doing it all manually. Who knows though before it's finished, released, and documented

1 0 2 101 0

View Details

Paul White @SQL_Kiwi

a year ago

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

0 3 7 583 1

View Details

Darling Data @erikdarlingdata

a year ago

TRUNCATE TABLE WITH PARTITIONS causes data corruption with non-aligned partitions feedback.azure.com/d365community/…

1 1 7 547 0

View Details

Paul White @SQL_Kiwi

a year ago

@Suriyakmaps New thread until it breaks please

0 0 2 150 0

View Details

Paul White @SQL_Kiwi

a year ago

@mcflyamorim The one I keep up to date is sql.kiwi/2016/05/the-in… Nice to see Microsoft being careful with dynamic SQL again after the demise of dbcc clonedb 😀

0 0 3 54 1

View Details

Paul White @SQL_Kiwi

a year ago

This is a really funny SQL Server bug dbfiddle.uk/iUmhLPln DECLARE @T table (i smallint NOT NULL PRIMARY KEY); INSERT @T (i) VALUES (256); SELECT TRY_CONVERT(tinyint, T.i) FROM @T AS T; SET STATISTICS XML ON; -- Oops! SELECT T.i FROM @T AS T WHERE TRY_CONVERT(tinyint, T.i) IS NULL;

1 4 12 769 3

View Details

Paul White @SQL_Kiwi

a year ago

@sqlcrossjoin @erikdarlingdata Not me

1 0 2 140 0

View Details

Paul White @SQL_Kiwi

a year ago

@erikdarlingdata A1 effort

1 0 4 137 0

View Details

Paul White @SQL_Kiwi

a year ago

New article: Recording Debugging Information Inside a SQL Server Function Call We cannot use PRINT or RAISERROR statements within a T-SQL function body for debugging purposes. This article presents a workaround using session context. sql.kiwi/2025/04/debug-…