Only saw your second post after anwsering.

Your log file is so big because is logs all datachanges in the database. A write takes about one size of the space of...

What is the size of the datafile('s), and what is the size of the logfile('s).

Maybe the log file is growing and taking up space. In that case backup the logfile....

Spoiler alert, Here is the solution to the puzzle.

Spoiler alert, Here is the solution to the puzzle.

ben.brugman (1/18/2013)

---

-- Puzzle.

--

-- Using SQL I wanted to see what happend with the following...

46 seconds for the 25 000 rows.

About 2 hours for me...

Thanks for your solution, tried to study the solution,

'DelimitedSplit8K' is missing.

So I could not try the solution.

Also I have...

First I used the replace to find which were the undesired chars.

Next I used the...

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...