geometry STDifference is directional. Two overlapping equal-area rectangles can produce equal remaining areas while retaining entirely different regions.
SQL Tips – 5 SQL Server Best Practices
5 SQL Server Best Practices worth a quick check, starting with backing up the master database and testing it, and rebuilding indexes online to cut downtime.
SQL SERVER – Check Advanced Server Configuration
How do you Check Advanced Server Configuration values? Turn on show advanced options with sp_configure, run RECONFIGURE, then run sp_configure to list them.
SQL SERVER – Computed Column – PERSISTED and Storage
How a computed column is created and why PERSISTED and storage go together: persisted columns take more space. Plus links to the whole series.
SQL SERVER – FIX: ERROR: 8170 Insufficient result space to convert uniqueidentifier value to char
Error 8170 says there is insufficient result space to convert a uniqueidentifier value to char. The simple fix is to give the VARCHAR its full 36 characters.
Inclusive End Dates: Why BETWEEN Misses the Last Day
Inclusive end dates describe whole calendar days, while BETWEEN compares the exact supplied endpoints. A date endpoint becomes midnight when compared with timestamp rows. A guarded disposable fixture makes the boundary conditions explicit.
Spatial Data Types for Beginners
Spatial data types in SQL Server use geometry for planes and geography for Earth; points, polygons, and indexes start with valid coordinates.