Map unsigned integers to SQL Server types without narrowing their range. Keep strict source-text validation separate from destination CHECK constraints.
SQL Error Riddles: Parent Keys Not Found and Other Classics
SQL error riddles have been passed around for years. Here are the classics, told kindly, with the real SQL Server error behind each punchline.
Indexing Foreign Keys
Indexing foreign keys can speed joins and parent deletes when child-side indexes are missing; learn how to find gaps and test write tradeoffs.
Where Reference Data Should Live
Reference data belongs in governed lookup tables with stable codes, clear owners, and a release process that keeps environments aligned.
SQL SERVER – Disable Clustered Index and Data Insert
A client’s DBA disabled every clustered index before a bulk insert, and the application stopped working. What happens when you disable clustered index?
SQL SERVER – GUID vs INT – Your Opinion
GUID vs INT as a primary key or clustered index: I list one advantage and one disadvantage of each and ask you to add yours in the comments.
Storing Percentages: 0.15 or 15, and How to Tell Them Apart
Storing percentages starts with a declared unit. Fractional rates and percentage points require different conversions, even when both pass a range check. Use named columns, explicit boundaries and a guarded disposable fixture.