Thanks Joie,

I found the part of the problem was that I was logged in as myself and not as Administrator. Once I logged in as administrator, the options became...

Thanks Alan,

I the primary DBA and myself have checked the CPU usage and memory and both appear to be good.

I just tried restarting the SSIS Service and it had no...

Thanks Kevin,

We are doing the majority of the processing in temp tables but in the end, there are a lot of deletes and then writes back to five different summary...

Jeff Moden (2/12/2015)Just to be clear on the "new table" thing. The existing table could easily be modified to include Nested Sets to do all the magical things that...

Jeff Moden (2/12/2015)

---

Again, even though he's obnoxious as hell, Celko's right about one thing. The whole shebang should be recreated as a separate table that contains Nested Sets. ...

CELKO (2/11/2015)

---

Please follow basic Netiquette and post the DDL we need to answer this. Follow industry and ANSI/ISO standards in your data. You should follow ISO-11179 rules for naming data...

Jeff Moden (2/11/2015)

Not to worry. You won't have that problem when we're done. I just can't get to it during normal working hours. Have to do it...

By the way, I created a basic, limited workaround.

I created a table which takes the table and self-joins it nine times giving me up-to 10 generations of duplicates in a...

Jeff Moden (2/11/2015)

---

Yes. It makes sense.

So, just to clarify... if we did a search for all rows in this table where the "parent" ID was NOT contained in the...

Here is the create table:

CREATE TABLE [dbo].[Dimduplicates](

[duplicates_key] [int] IDENTITY(1,1) NOT NULL,

[dupeof_key] [int] NOT NULL,

[dupe_key] [int] NOT NULL,

[start_ts] [datetime] NOT NULL,

[end_ts] [datetime] NULL,

CONSTRAINT [PK_Dimduplicates_key] PRIMARY KEY CLUSTERED

(

[duplicates_key] ASC

)WITH (PAD_INDEX...

Yes. No child...

Thanks Dwain,

The data is structure such that children point to their parent but parents do not point to children.

Bug 1 has no idea it has any children but...

Thanks Alan.

Just opened and it looks quite in-depth. Will make for some good reading. 🙂

amar_kaur16 (2/9/2015)

---

Thank you for the response.

The only problem is there can or cannot be a record for an applicant in the review table and I want to get all...

Interesting solution:

Changing the order of processing solves the problem.

Original:

1. Retrieve all data to be inserted to @table

2. Delete from regular table based on date range in @table

3. Insert @table data...