Show 16 – SQL Server Horror Stories




SQL Server Radio show

Summary: <a href="http://traffic.libsyn.com/madeirasqlserverradio/SQLServerRadio_Show016.mp3" target="_blank">Download Episode (mp3)</a> We love working with SQL Server, but over the years, we've had some interesting, funny, sad and horrific cases related to it. On this show, we talk about some of those cases. Among other topics, we talk about: * How to bring SQL Server online when it has no tempdb files * Stored Procedure and Plan Cache optimization over the phone * Finding out who dropped a database * A very destructive MERGE statements that kills clusteres * Data corruptions * Table variable horrors * And more.. Items mentioned in the show: * <a href="http://www.dbnewsfeed.com/2014/02/20/the-strange-story-about-the-merge-that-killed-the-cluster/" target="_blank">Matan Yungman - The Strange Story About the MERGE that Killed the Cluster</a> * <a href="https://www.youtube.com/watch?v=KVsMrLPZR8E&amp;list=PLoGAcXKPcRvanix7u9eqg_qt1tp849rX3" target="_blank">Paul Randal - Advanced Data Recovery Techniques</a> * <a href="https://sqljudo.wordpress.com/monthly-dba-challenge/" target="_blank">Russ Thomas' Monthly DBA Challenge</a> If you like the show, please consider leaving a <a href="https://itunes.apple.com/ca/podcast/sql-server-radio/id907987517?mt=2" target="_blank">short review about the show on iTunes. </a>