geometry STUnion merges geometry coverage. These exact-coordinate rectangles distinguish a combined area from the sum of two areas, including duplicate coverage.
REGEXP_INSTR: Locate a Match or a Capture Group
REGEXP_INSTR returns the position of a selected regular-expression match or capture group. I compare its positional arguments using one short string. This example needs SQL Server 2025 and database compatibility level 170.
SQL SERVER – Disabled Index and Update Statistics
A reader asked how disabled indexes affect statistics. With the clustered index disabled, Update Statistics throws an error; see what happens once you enable it.
SQL SERVER – DATE and TIME in SQL Server 2008
What happens when you convert DATE and TIME in SQL Server 2008 to DATETIME? A quick demo shows the midnight and 1900 surprise.
Azure SQL Database and SQL Server: What Changes
Compare Azure SQL Database with SQL Server, including jobs, cross-database access, monitoring, backup control, and operational responsibilities.
SQL SERVER – Check the Isolation Level with DBCC useroptions
What isolation level is your session using? Run DBCC useroptions to see it, along with dateformat, datefirst, language and other SET options.
SQL SERVER – Simple Example of Snapshot Isolation – Reduce the Blocking Transactions
Snapshot Isolation has been in SQL Server since 2005, yet many shops still skip it. A simple example shows how it can reduce blocking transactions.







