A fun visual graph, and super detailed explanation, of all the gears that turn in a query's execution! A solid read for new and experience folk alike,
Developers that interact with databases have two main pain points: troubleshooting performance and troubleshooting data loss issues. This article will not help you much with the later, if you do not have a backup, nothing will save your, sorry! But I hope that understanding how things work will shed some light into the performance troubleshooting problems.