Spot on, Gus. 🙂

rohanverma (9/3/2008)

---

Hi,

Thank you for the above script, I used the above script and it worked just fine. My question is for the part:

--===== Query one of the files by using...

I mean C:\temp on the SQL Server that's doing the reading.

dsegalles80 (9/5/2008)

---

Jeff Moden

This is used for update by batch as per requirement on our...

jfbergeron (9/4/2008)

---

It is actually a requirement to try importing the data as is, because we want to know if errors occured. That update will happen in 100 stores, and we...

You still haven't answered the question though... why would anyone create such a table of 1 gig of almost nothing but NEWID()'s?

Two way street here... 😉 What did you finally do to fix it?

Heh... sorry Gail... couldn't believe my eyes at first. Now I get what you were trying to say.

Thanks Hans, I appreciate the feedback... I had a great weekend, too. Heh... "Honey-Do" list and other labors of love.:D

The reason I'm so adamant about testing this is I...

blom0344 (9/4/2008)

---

From my point of view the performance issue is secondary , since we're talking in the range of 5000 - 100000 records for a table. With SQL server 2005...

Gaby,

Ok... I realize that you said "quick and dirty", but I keep looking at this article and wondering... why? :blink: Why would someone need to generate a giga-byte...

Heh... one person says it might be more performant, another says, with some vigor I may add, probably not. Neither has done a test and posted it. 😉

Gary Johnson (9/3/2008)

---

rbarryyoung (9/3/2008)

---

The script generator does not always work (bugs, fails on certain syntaxes), also cannot be automated and isn't very flexible. Plus there are things that it...

Heh... I've seen lot's of folks do it... they sit there with the spreadsheet open and try to run the code to populate. That will give such an error.

Also,...

None of this would be a problem if you first inserted the data into a staging table and validated it.