The Itzik Ben-Gan Trick
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: Itzik Ben-Gan - What You Need to Know About Batch Mode Window Aggregate Operator in SQL Server 2016