Is it possible that an insert would use parallelism?
Posted
by Lieven Cardoen
on Server Fault
See other posts from Server Fault
or by Lieven Cardoen
Published on 2010-03-23T18:57:43Z
Indexed on
2010/03/23
19:03 UTC
Read the original article
Hit count: 206
sql-server
In what situation can inserting a simple record (the table has got some 10 columns, two of them are xml) use parallelism?
CREATE TABLE [dbo].[PackageSessions](
[PackageSessionId] [int] IDENTITY(1,1) NOT NULL,
[PackageId] [int] NOT NULL,
[UserId] [int] NOT NULL,
[StartDateTime] [datetime] NULL,
[StopDateTime] [datetime] NULL,
[Score] [float] NOT NULL,
[ScoreMax] [float] NOT NULL,
[CompletionStatus] [int] NOT NULL,
[ReviewPlayerContextId] [int] NOT NULL,
[PlayerContextId] [int] NOT NULL,
[ReducedScore] [float] NOT NULL,
[ReducedScoreMax] [float] NOT NULL,
[PackageSnapShot] [xml] NULL,
[InterfaceLanguageId] [int] NOT NULL,
[Data] [xml] NULL,
[PackageSessionLanguageId] [int] NOT NULL,
CONSTRAINT [PackageSessions_PK] PRIMARY KEY CLUSTERED
(
[PackageSessionId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
© Server Fault or respective owner