In this post I am going to “Stack walk” the batch run time and point out one or two interesting things along the way. However, I’ll take a short step back by providing some back ground information […]

One of the unheralded features of SQL Server 2014 is the parallel insert; provided through the SELECT INTO statement. In this blog post series I’d like to look at pushing this feature to its limits. This […]

The batch mode engine as it stands has delivered an order of magnitude performance increase over the row mode engine. In this post ( and please bear with me, as this is genuine level 400 stuff ), […]