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
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
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.
NFL Daily with Gregg Rosenthal
Gregg Rosenthal and a rotating crew of elite NFL Media co-hosts, including Patrick Claybon, Colleen Wolfe, Steve Wyche, Nick Shook and Jourdan Rodrigue of The Athletic get you caught up daily on all the NFL news and analysis you need to be smarter and funnier than your friends.