To use a pipe delimiter between each field, use the -t "|" option. -r is the row delimiter

Toby Harman (7/5/2011)

---

Good article covering a common situation. Indexes are created because we assume they will be the access path (as pointed out in the DateTime discussion) but because they...

great question. I never realised Go accepted an option... now I just need to find a use for it 😉

Nice question. I got so caught up wondering why you chose union instead of union all that I missed the smalldatetime. doh!

Good question Steve! 4 seemed too obvious to me as well.

sknox (4/26/2011)

---

Very good question.

I think the reason this works is that the NULL in the CREATE TABLE is an attribute of the column (since NULL is actually just a...

Being an Aussie, I found this US based question harder than most of the others! Nailed it 🙂

I'd like to add one point to your great article. DW ROI is not proportionate to the development time invested.

Some business areas can provide high ROI, with...

I thought I'd nailed this one, but sadly was wrong. Nice to know, thanks for the great question.

Great question, thanks! I went for tinyint on the assumption it was 1 byte of storage and compression overhead - got it wrong, but learned something new 🙂

Nice question, thanks.

Great question, thanks!

I lost a point here, but it was well worth it as I hadn't even considered collation when I answered.

Great question considering 64% of the answers were incorrect! I came across this issue a short while ago which jogged my memory for this question, but nice to know. Thanks

Good question for general knowledge, thanks.

I thought I'd sneak in a quick question or 2 while I was at work...then all that date math took 10 minutes to work out, and now its home time!...