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: