Could not create constraint or index. See previous errors.<\/em><\/span><\/p>\nThe script you will execute should be as follows.<\/p>\n
USE [AdventureWorks2016CTP3]\nGO\nSET ANSI_NULLS ON\nGO\nSET QUOTED_IDENTIFIER ON\nGO\nCREATE TABLE [Person].[Person2](\n\t[BusinessEntityID] [int] NOT NULL,\n\t[PersonType] [nchar](2) NOT NULL,\n\t[NameStyle] [dbo].[NameStyle] NOT NULL,\n\t[Title] [nvarchar](8) NULL,\n\t[FirstName] [dbo].[Name] NOT NULL,\n\t[MiddleName] [dbo].[Name] NULL,\n\t[LastName] [dbo].[Name] NOT NULL,\n\t[Suffix] [nvarchar](10) NULL,\n\t[EmailPromotion] [int] NOT NULL,\n\t[AdditionalContactInfo] [xml](CONTENT [Person].[AdditionalContactInfoSchemaCollection]) NULL,\n\t[Demographics] [xml](CONTENT [Person].[IndividualSurveySchemaCollection]) NULL,\n\t[rowguid] [uniqueidentifier] ROWGUIDCOL NOT NULL,\n\t[ModifiedDate] [datetime] NOT NULL,\n CONSTRAINT [PK_Person_BusinessEntityID_2] PRIMARY KEY CLUSTERED \n(\n\t[BusinessEntityID] ASC\n)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]\n) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]\nGO\nALTER TABLE [Person].[Person2] ADD CONSTRAINT [DF_Person_NameStyle2] DEFAULT ((0)) FOR [NameStyle]\nGO\nALTER TABLE [Person].[Person2] ADD CONSTRAINT [DF_Person_EmailPromotion2] DEFAULT ((0)) FOR [EmailPromotion]\nGO\nALTER TABLE [Person].[Person2] ADD CONSTRAINT [DF_Person_rowguid2] DEFAULT (newid()) FOR [rowguid]\nGO\nALTER TABLE [Person].[Person2] ADD CONSTRAINT [DF_Person_ModifiedDate2] DEFAULT (getdate()) FOR [ModifiedDate]\nGO\nALTER TABLE [Person].[Person2] WITH CHECK ADD CONSTRAINT [FK_Person_BusinessEntity_BusinessEntityID2] FOREIGN KEY([BusinessEntityID])\nREFERENCES [Person].[BusinessEntity] ([BusinessEntityID])\nGO\nALTER TABLE [Person].[Person2] CHECK CONSTRAINT [FK_Person_BusinessEntity_BusinessEntityID2]\nGO\nALTER TABLE [Person].[Person2] WITH CHECK ADD CONSTRAINT [CK_Person_EmailPromotion2] CHECK (([EmailPromotion]>=(0) AND [EmailPromotion]<=(2)))\nGO\nALTER TABLE [Person].[Person2] CHECK CONSTRAINT [CK_Person_EmailPromotion2]\nGO\nALTER TABLE [Person].[Person2] WITH CHECK ADD CONSTRAINT [CK_Person_PersonType2] CHECK (([PersonType] IS NULL OR (upper([PersonType])='GC' OR upper([PersonType])='SP' OR upper([PersonType])='EM' OR upper([PersonType])='IN' OR upper([PersonType])='VC' OR upper([PersonType])='SC')))\nGO\nALTER TABLE [Person].[Person2] CHECK CONSTRAINT [CK_Person_PersonType2]\nGO\n<\/pre>\nAfter creating the table, we remove the Primary Key from the Person2 table and run the insert into clause with the following script without parallelism.<\/p>\n
INSERT INTO Person.Person2 SELECT * FROM Person.Person<\/pre>\nWhen we look at the execution plan, we see that Clustered Index Scan and Table Insert operations are performed without parallelism.<\/p>\n
![\"\"](\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/img_5de10250e86b6.png\")
<\/p>\n
Execute the INSERT INTO statement with WITH (TABLOCK) as follows and look at the execution plan again.<\/p>\n
As you can see the query worked this time using parallelism.<\/p>\n
![\"\"](\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/img_5de1028a7c6ab.png\")
<\/p>\n\n
<\/div>\n
![\"\"](\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/img_5de1014674b83.png\")
<\/p>\n