Author: Matan Yungman

Help the Optimizer

Download Episode (mp3) There are many ways for writing efficient queries in SQL Server. In this show we talk about a few of those ways, when the key is – “keep it simple”. In addition, we talk about use cases for Big Data, Ways for transferring data to a reporting server, an interesting BI project Guy is working

Continue reading

The Mysterious Ways of the Optimizer

Download Episode (mp3) In this show, we talk about: Why there are more and more security and encryption projects, and how wrestling is related More issues and things to take into account with the new cardinality estimator The Baader-Meinhof Phenomenon Truncating a single partition in SQL Server 2016

Client Stories

Download Episode (mp3) In this show, we share some client stories from recent projects: One nice thing of being a consultant Another consolidation project with a client implemented with views Performance recommendations from a client project Trivial optimization vs.Simple Parameterization Some challenges when working with MySQL  

If Clippy Found His Way to SQL Server Radio

Download Episode (mp3) In this show: The challenges of consolidation projects What is the Remote Query Harden error with Availability Groups PASS Summit precons Describe your profession in one sentence What if Clippy found his way to to SSMS? The right ways to manage open transactions

A Sign Your Wife is Married to a DBA

Download Episode (mp3) In this show, we talk about: Our sessions at the GroupBy conference Another difference between the old and new Cardinality Estimators Lightweight Profiling in SQL Server 2016 SP1 Sign Matan’s wife is married to a DBA SSDT 2017 A cool SSMS shortcut A bug with CDC after a cumulative update The overhead

Continue reading