DATEADD fractional numbers are truncated, not rounded. Compare positive and negative day additions while preserving an explicitly typed date input.
geometry STTouches: A Shared Boundary Is Not Interior Overlap
geometry STTouches tests whether shapes meet without their interiors intersecting. I keep that predicate separate from a general intersection check. Sharing an edge and sharing an area are different spatial relationships.
CAST to date: Remove Time Without Moving the Day
CAST to date keeps the calendar day from a typed datetime2 value. The example preserves the original time and contrasts actual removal with a display that merely hides it.
SQLAuthority News – Notes from TechDays 2009 at Infosys, Bangalore
My notes from TechDays 2009 at Infosys, Bangalore on Nov 16-17: the largest Microsoft tech event at Infosys, with about 2,500 attendees in person and online.
Validate an XML Document in T-SQL With an XSD Schema by Jacob Sebastian
To validate an XML document in SQL Server, store an XSD in a schema collection and type the variable or column with it. Jacob Sebastian’s lesson is kept, and I added tests on SQL Server 2025 that show the error number for each kind of bad document and what DOCUMENT and CONTENT accept.







