This worked GREAT, thank you thank thank you

I dont remember. Let me try and get back to you.

Thanks the ... + @var + ... worked.

I haved it in my code and dont know why I just didnt think of it before.

I guess I was looking...

Thanks for the quick reply.

I knew where the error was, I just don't understand why the error is happening?

I a little baffled.

Thank You Thnak You Thank You to all who assisted.

The issue was dealing with INDEX Fragmentation.

I ran the sys.dm_db_index_physical_stats and found my indexes fragmented.

using the DBCC DBREINDEX...

Im loading a datawarehouse with many dimension tables.

WHen I moved to sql 08, I added more indexes but things were working well for a month.

My issue just started. When I...

No, on average there is about 10 000 to 20 000 records a day

it's local on a server. Not a vitual machine.

Thanks for the reply. I apoligize I should have mentioned one or two things.

The Database is a datawarehouse and therefore I need the 3 other tables (Dimension and Fact Tables)...

I should have been more specific. Would the retrival of data be quicker if the indexes were sorted in DESC order.

OK...I will leave it as it.

Thank You evryone for the help and the great info.

Standard, that is why I was curious abuot the/3GB option

1) Its not a dedicated Sql Box. I have a reporting solution running on the box.

3) I have been monitoring the memory pressure, and that is how I noticed why...

ok I think I found on how to set it up...

Thanks for all the help.

How do I enter the /3GB into the boot.ini file?

do I just add /3GB

[boot loader]

timeout=30

default=multi(0)disk(0)rdisk(0)partition(1)\WINDOWS

[operating systems]

multi(0)disk(0)rdisk(0)partition(1)\WINDOWS="Windows Server 2003, Standard" /fastdetect /NoExecute=OptOut /3GB