Preview Mode Links will not work in preview mode

Nov 19, 2014

On previous shows, we talked about an interesting behavior of the Sort operator and missing nodes in execution plans. On this show, we finally have the explanation for those Phenomenons.

In addition, we talk about:

  • What needs does Azure DocumentDB come to address
  • Common mistakes with Parameterization in SQL Server
  • Tracking Page Splits
  • Tracking progress of index builds and rebuilds
  • A new index maintenance script
  • Dangerous backups
  • And more..

Items mentioned in the show: