Parallel Insert Into - Table Variable Vs Temporary Table in SQL Server

Play Parallel Insert Into - Table Variable Vs Temporary Table in SQL Server
Sign in to queue

Description

In SQL Server, for insert into select statements, when the target for insert into is temporary table, the select statement can execute in parallel. When the target is table variable, SQL Server will not execute the select statement in parallel, which can lead to poor performance.

The below video demonstrates this with hands-on example. SQLTest Tool simulates the hands-on labs for you, no registration necessary. You can practice the online hands-on example while watching the Video.

Tag:

SQL Server

Embed

Download

Download this episode

The Discussion

Add Your 2 Cents