Slow insertions, poor page fillfactors, poor scan performance, fragmentation,...

SQL Server is using much more memory than that.

Take a look at the Total and Target Server Memory counters in Performance Monitor - you will find them under the Memory...

:blink: You want to create a clustered...

Had to guess at the data types a bit:

WITH TmpDoublons (ROWID, numero_avis)

AS (

SELECT ...

Just awesome.

Couldn't find a good elvish translator...took the easy road 😉

Example based on those two tables:

ALTER TABLE dbo.OrderFormHeader

DROP CONSTRAINT [FK_OrderFormHeader_OrderGroup];

TRUNCATE TABLE dbo.OrderGroup;

TRUNCATE TABLE dbo.OrderFormHeader;

ALTER TABLE dbo.OrderFormHeader

...

http://www.bmeijer.com/fun_stuff/runic_translator/index.html

There is no way I can see...

It is reasonably simple, as I outlined in my last post.

If it doesn't make sense yet, provide a simplified example that we can work with to outline the concept.

It would help explain the problem if you post the full...

river1 (3/18/2010)

---

When i use the export data tool (to send the table to other database), i can send the table, but i cannot create in the destination database the primary...

Is it not as simple as generating a list of numbers, starting at random 'R', then adding 'N' until enough records are selected?

If so, write something to populate a temporary...

peleg k (3/18/2010)

---

i will add the execution plan later beacuse i am in the middle of the task

but just to update you : when adding the OPTION (RECOMPILE); ->...

:blink: Do you want to take another shot at explaining that? :blink:

It is possible to do many things with the export data tool - I just need to understand the...