Creează un cont pentru a te abona la acest blog și a-i urmări articolele pe pagina Lectură.
-
TL;DR Part 1 covered the patterns.
-
TL;DR A deadlock is two transactions each holding a lock the other needs, caught in a cycle the engine breaks by killing one.
-
TL;DR NULL is the absence of a value, and SQL evaluates expressions involving it under three-valued logic (TRUE / FALSE / UNKNOWN).
-
TL;DR Most silently wrong SQL comes from the same root cause: a join that multiplies rows in a way the author didn’t expect.
-
TL;DR Uniqueness governs correctness, selectivity governs performance.
-
TL;DR Every major database engine lets you attach comments to tables and columns: descriptions that live in the schema itself and show up in every tool that reads it.
-
TL;DR Foreign keys are the last line of defense against orphaned data, silent corruption, and integrity issues that compound over time.