Databases are incredibly sophisticated pieces of software, and hence as they mature, the algorithms and logic behind what at first glance would seem to be trivial functionality are often amazing in their cleverness and cunning. In this episode we'll explore the complexity and sophistication around what would seem to be the simplest of questions: When I want to insert a row into a table, where should the database store that row? For a database to answer that question, it needs to know which table blocks are empty, which ones are full and how to manage multiple sessions all asking for which blocks to use all at the same time. Time for some insight into the High Water Mark for a database table, and its impact on your applications.
If you like this episode, be sure you hit the Like button and share it with your colleagues. Catch me on Twitter at https://twitter.com/connor_mc_d if you have comments or questions.
Popular Podcasts
Stuff You Should Know
If you've ever wanted to know about champagne, satanism, the Stonewall Uprising, chaos theory, LSD, El Nino, true crime and Rosa Parks, then look no further. Josh and Chuck have you covered.
Dateline NBC
Current and classic episodes, featuring compelling true-crime mysteries, powerful documentaries and in-depth investigations. Follow now to get the latest episodes of Dateline NBC completely free, or subscribe to Dateline Premium for ad-free listening and exclusive bonus content: DatelinePremium.com
Kingdom of Fraud
It’s the unlikeliest of criminal partnerships: a devout polygamist from an insular Utah sect joining forces with a shadowy Armenian tycoon from LA. The result - a billion dollar fraud conspiracy. In Kingdom of Fraud, investigative reporter Michele McPhee traces the origins of the extraordinary alliance between Jacob Kingston and Levon Termendzhyan. Together, the two men trigger the largest tax investigation in American history and weave around themselves a web of dirty cops, influential political relationships and transnational money laundering. All this is set against the backdrop of Jacob Kingston’s clan – The Order. A powerful and secretive polygamist organization in Salt Lake City. To whom Jacob is desperate to prove his worth. Kingdom of Fraud is produced by Novel for iHeart Podcasts. For more from Novel, visit https://novel.audio/. You can listen to new episodes of Kingdom of Fraud completely ad-free and 1 week early with an iHeart True Crime+ subscription, available exclusively on Apple Podcasts. Open your Apple Podcasts app, search for “iHeart True Crime+, and subscribe today!