mickyT (2/16/2014)

---

Hi

I've never compared my processes against a power shell equivalent (or anything else for that matter:-)), but I have some large text files (around 1.5 GB) that I pre-process...

Jeff Moden (2/16/2014)

---

sqldriver (2/15/2014)

---

I really hate SSIS and was hoping to avoid it. I guess I could try doing this all in another language that handles large file operations better....

TheSQLGuru (2/15/2014)

---

sqldriver (2/14/2014)

---

TheSQLGuru (2/14/2014)

---

sqldriver (2/14/2014)

---

TheSQLGuru (2/13/2014)

---

The biggest problem I have seen at clients along this type of need is not having a WHERE clause so you only update rows that...

Yeah, I think my plan is going to be using PS to generate a bulk insert for every file, naming the tables after the files before the .txt, and immediately...

I really hate SSIS and was hoping to avoid it. I guess I could try doing this all in another language that handles large file operations better. Of course, since...

Hi Igor,

Loading the files isn't the slow part; processing them for loading is. Mainly, I think, adding the location code to each file for tracking.

Thanks

TheSQLGuru (2/14/2014)

---

sqldriver (2/14/2014)

---

TheSQLGuru (2/13/2014)

---

The biggest problem I have seen at clients along this type of need is not having a WHERE clause so you only update rows that actually HAVE...

TheSQLGuru (2/13/2014)

---

The biggest problem I have seen at clients along this type of need is not having a WHERE clause so you only update rows that actually HAVE at least...

TheSQLGuru (2/9/2014)

---

Jeff Moden (2/9/2014)

---

THAT's JSON? Shoot... that's...

ChrisM@Work (2/5/2014)

---

The BETWEEN range ends at 'V'. If you have a vendor with exactly this value then it will be included. Vendors called 'V' + anything else will be excluded...

Jeff Moden (2/2/2014)

---

BWAAA-HAAAA!!!!! I know...

Yes, Jeff, now give me something to spend all this DBA money on that wasn't bottled and corked by a guy in a kilt.

Jeff Moden (2/1/2014)

---

Heh... correct. :blush: I really don't have 2K12 installed anywhere to mess with. I have a copy of the Developer's Edition sitting on my desk and I...

Jeff Moden (2/1/2014)

---

I'll save you some time...

I don't currently have a 2K12 machine available so I can't demonstrate the LAG method (I don't like to post code I haven't tested)...

Jeff Moden (2/1/2014)

---

BWAA-HAAA!!!! Was I there? 😛

Also, Michael, I'll see how your solution adapts when...