Thanks for your input,

Suggestions how to proceed are very welcome.

My goal at the moment is finding similar strings.

For a long reply see under the signature,

Ben Brugman

Sean Lange (1/17/2013)

---

I would like...

Bhuvnesh (1/17/2013)

---

i havent got what you actually needed and asked ? can you post your requirement with sample data along with desired output. see "we cant see what you...

Sorry for the late response, I'll try to anwser the questions now.

[/quote]

ScottPletcher (1/4/2013)

---

Do you have only a few clients with huge numbers of orders each?

Or for a large number of...

Grant Fritchey (1/11/2013)

---

Right, so as far as SQL Server is concerned you're partitioning to a single drive. Performance is pretty much guaranteed to be poor. Yours does seem abnormally poor,...

Grant Fritchey (1/11/2013)

---

Yeah, but is the SAN set to multiple, isolated LUNs for the partitioning? If not, partitioning is going to suffer more than just a straight access to the...

Grant Fritchey (1/11/2013)

---

Are the partitions on a single disk? If so, you've just added the overhead of having to filter your data but you're not benefitting from having multiple disks...

Sorry I think I mean an extent (8 pages),

how did segment come into my head?

(Old term, Oracle, fantasy, I do not know).

Is the optimizer aware of extents (8 pages...

Thanks to all contributing to this thread, especially Gail and the others who triggered her in providing more information.

This made me wonder about Segments, do they come into the 'picture'...

GilaMonster (1/7/2013)

All processing is done in memory, regardless of whether it's an index seek, scan, lookup, etc. The query processor has no idea what a file is or how to...

GilaMonster (1/7/2013)

No. It reads all rows from the index where A=6, filters them as it reads for C =7. Once it has all rows that match all conditions that have...

Lynn Pettis (1/7/2013)

---

Your code still only runs the test code for one of the indexes not both. If I want the execution plans for the queries using the clustered...

Lynn Pettis (1/7/2013)

---

Taking a closer look at your code I see that now. You tell us to run your code from further below. Sorry, I missed that. ...

The code for a Heap situation is included in the code as wel.

I should have...

I wouldn't worry too much about it. While all a client's rows may be logically located together, after these page splits they'll be physically dispersed on disk and in less-than-full...

I have been working on the table definitions.

I do not wish to post the complete definition,

1 because of the...