Koen Verbeeck (7/15/2014)

---

Indeed, the file is formatted quite well in the sense that it is very predictable.

How I would do it:

* read the file in line by line as one...

Nice to know, I would have expected to return an overflow.

Thank you for the question.

Thank you for the question. Nice to see a question on PowerShell. By the way what cool things can you do with PS ? I have not used it...

thank you for the question

thanks for this

Shark Energy (3/20/2013)

---

Hi,

Long time Senior DBA here - but just starting down the Data mining journey. Great article - makes it seem you can get something good out with minimal...

I did not had luck 🙂 and did not knew the answer. But thanks for sharing this exercise and the experience.

Iulian

christian_nowicki (7/7/2014)

---

The only problem is that the rand function returns the same value for each row. Changing the seed value changes the value returned by the rand function, but it...

Good to know, thanks for the question

Thank you for the question.

initially I was under the impression that RAND(CAST(GETDATE() AS INT)) will generate a random order key.

But probably it will be random only if ran in different days, though if...

Well.. I think you are partially right,

The fact there is no ORDER BY does not guarantee the records will be returned in order,

though that is...

thanks for puting it together

Nice one , thanks , Iulian

Yes, very nice explanation.

Thanks,

Iulian