The backup only contains the data pages that are used in the db. So if you had more data, you have more pages and the backup gets bigger. ...

Ian-440692 (4/29/2011)

---

I tried saying I worked with computers, but had so many requests to fix printers or help set up wireless networks that I changed and now I say...

Yin Halen (4/29/2011)

---

Nope. Have you ever used sp_validatelogins? It tells you what logins you have on your server aren't in your AD. I'm looking for the opposite.

I am not...

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