hangxliu (4/29/2011)

---

Ninja's_RGR'us (4/26/2011)

---

Grant Fritchey (4/26/2011)

---

nico van niekerk (4/26/2011)

---

One can understand that employers would be reluctant to allow someone with whom they have no trust-relationship to work at home. There are...

Tom.Thomson (4/29/2011)

---

Ninja's_RGR'us (4/29/2011)

---

Glad to learn that but why would you have to run that?

Even if by some accident you unintentionnally started update stats with fullscan on...

My personnal favorite is to put the file date in the filename. IE : ETL_ABC_20110429.

Then simply use xp_cmdshell to load the file names. Parse the date. Start...

I think the problem is the where condition. Usually you need to cast the split function back to int (since it starts as [n]varchar).

Try to rerun the query without...

Glad to learn that but why would you have to run that?

Even if by some accident you unintentionnally started update stats with fullscan on a 2...

ALZDBA (4/28/2011)

---

Ninja's_RGR'us (4/28/2011)

---

Thanks Albaza.

I'll put in an official request for my toy DB and I'll go from there.

We have a test environement but I can't overwrite it at...

Himmat Singh (4/28/2011)

---

1)use db_name

2) set the database recovery to simple - sp_dboption 'db_name', 'trunc. log on chkpt.', true

3) write a store produre to delete about 10000 per loop. After...

I don't see any needs for a rewrite at the moment. You'd have a lot to learn and it wold be very time consumming.

Bottom line is this. Try...

opc.three (4/28/2011)

---

jared-709193 (4/28/2011)

---

The problem right now with using BCP right now is that the Perl script validates data by what errors occur during insertion. These defunct rows are written...

The only "problem" is that the cpu can't process another high load at the same time. On the very long run, maybe premature death of the processors.

Other than that...

I'm not 100% sure I understand your concern then. Importing millions of rows is going to take processing power, no matter the tool used for the job.

If you don't...

It's <almost> always the date that's causing the problem.

definitely go the copy / paste to query analyser or ssms and check for exact problems there.

If you have the error message...

BCP will eat 1 M rows like it's nothing. If you really are having issues with the import (like users can't work), then I'd redo it.

It just does error out (by design). You need to use dynamic sql.

I've had to do something similar for a website. I simply concatenated the right DB name...

You either need to use full dynamic sql or solve the problem differently.

What are you trying to accomplish exactly?