There are multiple threads hitting using this process, how would the temp table work in that situation?

Thanks.

Yes, I have a Test env, and the Quality table has 100+ million rows.

any suggestions for dropping and re-creating on that large of a Table?

Not sure how much of a time window I have to do the drop\create...  The Box it's on has...

What ever will work to be able to load a new copy of the DB with Foreign Key in mind during the process. I want basically a schema only

version of...

Not sure what you mean by " re-cluster the Quality table".

Thanks.

I have used that before.. but was looking for something that would dump tables in order with foreign key reference in mind, so I could pickup this file and create...

Thanks... Will test that code out... Quality table has 100+ million records as does detail and Attribute has 400+ million

Do you see anything that would improve this snippet of code...

Attribute DDL

CREATE TABLE [dbo].[Quality_Attribute](
[Quality_ID] [int] NOT NULL,
[Attribute] [nvarchar](100) NOT NULL,
[Attribute_Value] [nvarchar](100) NULL,
[Attribute_DateTime] [datetime] NULL,
 CONSTRAINT [PK_Quality_Attribute] PRIMARY KEY CLUSTERED 
(
[Quality_ID] ASC,
[Attribute] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE...

DDL for Quality_Detail..

CREATE TABLE [dbo].[Quality_Detail](
[Quality_ID] [int] NOT NULL,
[Value_Count] [int] NOT NULL,
[Value] [nvarchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Result] [nvarchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
 CONSTRAINT [PK_Quality_Detail] PRIMARY KEY CLUSTERED 
(
[Quality_ID] ASC,
[Value_Count]...

DDL for Quality Table.

CREATE TABLE [dbo].[Quality](
[Quality_ID] [int] IDENTITY(26692927,1) NOT NULL,
[Quality_Test_ID] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Quality_DateTime] [datetime] NULL,
[Quality_Employee_ID] [nvarchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Quality_Equip_ID] [nvarchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Quality_Container_ID] [nvarchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS...

I'll try to run some testing with the suggestions given.

Thanks ALL!!!

Thanks for Updates..

Will update with DDL shortly..

Not exists performs better than not in ? or is it the select 1 versus select distinct ..

Thanks for reply

Found it.. it was under Getting Started .. not Downloads..

Thanks.

Thanks Scott that worked perfect..