SSIS can't handle this to my knowledge.

What you're going to look to do is build a generic table with a VARCHAR(MAX) field in it, and use that as your original...

This should help:

CREATE NONCLUSTERED INDEX idx_temp_forGuidCounts ON TEMP ( GUID, Results)

This should let your count statements avoid a scan on the clustered and go directly for a seek on the...

Alright,

For starters, these are estimated plans. Everything here is a guess by the optimizer. By preference, you always want to work with actuals.

That said.

The original plan is doing...

I'd take a multi-step approach to this.

First, I'd break down the XML into a series of sub tables for filtering. Basically a series of #tmps or @tmps.

Next, I'd use...

We'd need to know the DDL and index builds on TEMP to be able to help further.

Attached plans are 0 bytes each. No data in them, just the file names. Please double check?

I've done it on rare occassions to produce flattened results during overnight rebuilds...

Jeff Moden (11/10/2010)

---

As I said on that post... now I know what a feeding...

eric larocca (11/9/2010)

---

this way i believe it won't rescan the original table but order only the records try this.

It should process the order by after it gathers the records

whats inside...

Use a temp table and store your variables in rows and join against it instead of trying to use the IN statement that way.

IE:

DECLARE @filter TABLE (FilterVal VARCHAR(100))

INSERT INTO @filter...

snoop123 (11/9/2010)

---

hi thanks for you reply actually there has been a huge amounts of I/o waits ,long running queries and also query timeout ....so i guess was may be an...

The higher selectivity probably lets it seek instead of scan an index. Would have to see the DDL and the comparable sqlplans to tell for sure.

It's either late, or I'm blind. Where's the tweak?

Alright, this is a bit chewy. This code works under the following conditions:

- Start or end time falls between Friday 23:00 and Monday 7:00.

- Noone works...

The last row found in the reference table is the last value entered/updated into the target table.

An easy test:

CREATE TABLE #tmp (ID1 INT, Val1 VARCHAR(10))

CREATE TABLE #tmp2 (ID2 INT, Val2...