SGSoham Gaichorinsoham111.hashnode.dev·12h ago · 5 min readThe Cashier and the CEO: A Tale of Two Database Worlds (OLTP vs. OLAP)Imagine you walk into a bustling coffee shop. At the front counter, a barista is rapidly tapping the screen, printing paper receipts, and handing out lattes. In the back office, the store owner is sit00
SGSoham Gaichorinsoham111.hashnode.dev·17h ago · 6 min readThe Shepherd, the Dog, and the 700 Sheep: A Visual Guide to SQL Server Composite IndexesHave you ever wondered what actually happens inside a database when you run a query filtering on multiple columns? Or why adding an index sometimes makes your queries lightning-fast, but other times b00
SGSoham Gaichorinsoham111.hashnode.dev·19h ago · 6 min readThe Secret Life of Database Pages: Why "Fill Factor" is the Ultimate Balancing ActImagine you are packing your school backpack for the year. Do you shove your books in so tightly that you can't even zip it closed? Or do you leave a bunch of empty space in every pocket so you can ea00
