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.
Stop Blaming the User: Let Constraints Catch Bad Data
Blaming the user is the oldest joke in IT. Here’s why it fails, and how NOT NULL, CHECK, UNIQUE and foreign keys stop bad data before it lands.
Keyset Paging: Continue After a Date and ID Cursor
Keyset paging continues after a saved ordering key instead of counting past an offset. A date and unique ID together keep equal-date rows in the sequence. A guarded disposable fixture makes the boundary conditions explicit.
SQL SERVER – SELECT * FROM dual – Dual Equivalent
Oracle developers often miss the DUAL table in SQL Server. I explain what DUAL is, why SELECT * FROM dual fails with Msg 208, and the dual equivalent to use.