The Itzik Ben-Gan Trick - a podcast by Guy Glantser, Eitan Blumin

from 2016-08-18T06:55:04

:: ::

Itzik Ben-Gan has many T-SQL tricks.

In this show, we talk about a few of them:

  • How to get Batch Mode Processing with regular tables
  • How to share Identity between different tables
  • How to use Cross Apply for Unpivot

In addition, we talk about what SOS_Scheduler_Yield means and answer the question - is it always the DBA's fault?

If you would like your question to be featured on the show, just head over to SQLServerRadio.com, drop us a line, and we'll talk about it in one of the upcoming shows.

Items mentioned in the show:

Further episodes of SQL Server Radio

Further podcasts by Guy Glantser, Eitan Blumin

Website of Guy Glantser, Eitan Blumin