BROADCASTS.com

b'

We love working with SQL Server, but over the years, we\\u2019ve had some\\xa0interesting, funny, sad and horrific cases\\xa0related to it. On this show, we talk about some of those cases.

Among other topics, we talk about:

• How to bring SQL Server online\\xa0when 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:

• Matan Yungman \\u2013 The Strange Story About the MERGE\\xa0that Killed the Cluster
• Paul Randal \\u2013 Advanced Data Recovery Techniques
• Russ Thomas\\u2019 Monthly DBA Challenge

If you like the show, please consider leaving\\xa0a\\xa0short review about the show on iTunes.\\xa0