Paul White

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. sql.kiwi/2025/04/surviv…

@Suriyakmaps No, it's fine

On the eve of the 1200th day of war in Ukraine, and with it the end of the second thread, have you had any problems to view this thread as happened with the previous one?

@jasonhorner dbt?

@SQL_Kiwi @WestoverJared I suspect it was mainly to support dbt which makes extensive misuse of them

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…

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

@WestoverJared @SQL_Kiwi accelerated enablement of "cut-and-paste" query writing

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"

@SQL_Kiwi I've always referred to what the documentation calls sequential CTEs as nested CTEs. I haven't thought much about it, but I don't see a reason for what is termed a nested CTE.

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

@SQL_Kiwi My guess this is would be useful in very rare circumstances

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.

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

@SQL_Kiwi @kekline So I could use this to, say, index a datetime column by just the date, w/o needing to define the column manually?

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

@SQL_Kiwi hm. a feature that, while perhaps easier to utilize in some particular T-SQL code, won’t be as robust as having a regular (non-persisted) computed column with an index?

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

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

@Suriyakmaps New thread until it breaks please

What do you guys think?

I don't know if it's better one thread or separate tweets from now on.

@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 😀

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;

@sqlcrossjoin @erikdarlingdata Not me

@SQL_Kiwi @erikdarlingdata , random Q, but do either of you use "PKM" (Personal Knowledge Management) tools for managing the vast amounts of obscure details you accumulate in your careers? (e.g. Logseq, Obsidian, Roam Research)

@erikdarlingdata A1 effort

🎥 How I Used Claude Code To Refactor My Stored Procedures youtube.com/watch?v=8nphFv… 🎥

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

FYI my rates for US residents have increased by 25% from today

New article: Accessing a SQL Server Table Variable in a Different Scope Two ways to access a SQL Server table variable outside its declaration scope. sql.kiwi/2025/04/access…