I would say turn off any AV on your system. You could look in your dumpfile if this is wrecking havoc to your SQL Server process space. (Is likely depending...

1. I do not know it you can send a stream to either BCP or BULK INSERT. But it sounds probable that you could do it some way. Though saving...

Well, you should sit down and start identifying your entities. Without any additional information it is hard to know exactly the problem. But then again, specifying the problem is a...

It sounds like you want to make a database to store class instances or did I get you wrong?

Is this your first attempt of designing a database?

I would definitly look into BCP (almost exclusively THE way to go when handling big dataloads) and the use of partitioning (so you ALWAYS load into an empty 'partition' THEN you SWITCH it).

I guess...

Yes.  But since you cannot ALTER types and you cannot DROP them if they are referenced I think it must be a little bit hard to change them frequently.

Having just started...

Maybe you have strange fragmentation or out of date statistics on your clustered index?

Hanslindgren

I can't remember when I last worked with a DWH of 5-10 GB My last was 1 TB..

CDR data are major league space consumers...

I guess that is good if you can be sure about that just a refresh would do it.

I've seen quite a few DWHs where some query runtime gets into...

I was wondering what your customer thinks when you are killing their connections? I don't think that can be an acceptable solution to a 24/7 warehousing problem in all cases...

Yes. SQL Server drops the LEFT JOIN with the table if the query optimiser decides that it can do it without any sideeffects. This is a VERY good quality for...

Albeit SQL Server 2005 wasn't out when you guys were writing these comments; do you now see anything against using SQL Server 2005 encryption? That is, if you can migrate...

Okay. You are right. One could ask oneself what someone would like to do with this data. Unfortunately this is also out of my control. Maybe one thing people have...

Thanx. Yes, you are theoretically right... That is under no user load, unfortunately my client is quite under dimensioned with regards to network bandwidth... The users are distributed around the...

Thanx Jeff!

I will look into it now!

Regards, Hanslindgren