Richard Rozema

Working with SQL server for over 20 years. First as a developer, now mostly administration and optimizations. And love to swim competitive.

Working with null values in SQL XML

We all know NULL values must be dealt with carefully in T-SQL, but how exactly do you best deal with them in SQL XML?

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(43)

You rated this post out of 5. Change rating

2010-10-26

27,829 reads

I have been experimenting with MCP servers in a few ways, including the Redgate...

I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...

Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...

Comments posted to this topic are about the item A Challenge of Our Knowledge

Comments posted to this topic are about the item The memory toll of VARCHAR(MAX)...

Comments posted to this topic are about the item Transaction Log Truncation

In SQL Server 2025, where can I find information about items that prevent or delay the transaction log truncation?