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: 179

Filed under:

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

Related posts about sql-server