Thanks John...I always wondered about that.

George

OK, so this is going to show my ignorance/stupidity but the mentioning of Hex and varbinary is bringing up a topic that I've been confused about for a while. As...

Thanks for the info opc.three!

You know, after reading everyone's questions and suggestions and thinking about them last night the answer came to me. I think my second table design will work better for several...

Heya JQAllen,

Sorry about the delay...I got pulled into a meeting.

The relationship isn't a parent-child one...it's one of two equivalents (siblings??). So requisition A isn't the parent of B and requisition...

I'm not sure if this is the "correct" way to attack this problem...but one way could be to use a Dates table that holds a record for each day and...

No native SFTP support is really disappointing. We have been using the execute process task to run a vb.net program to perform the SFTP functionality, but it would have been...

@sql Kiwi: Ohhh, I get it now...because RAND is non-deterministic it will return different values in the various CASE statement branches.

Thanks for explaining it further!

George

Good article...but I would also like to see an article or explanation on the issues raised by SQL Kiwi because, even after reading those two links, I'm still not 100%...

ben.reese (8/9/2011)

---

My comment in agreement with what GilaMonster has said, is to be very carful do do proper performance and scale testing if you decide to use table variables, they...

Wow that's great...thanks for the...

Tom,

Great article...although I too was a little lost by the first paragraph but your example made it clear.

I would also add effectiveStartDate and effectiveEndDate fields to the PayGrade_Details table so...

Tom.Thomson (6/30/2011)

---

KaplanDBA (6/30/2011)

---

Setting aside the fact that I'd rather normalize this further than just 1NF, I want to understand your argument better:

Well, NULL should always mean "The database doesn't contain...

Hello,

I found this article interesting. However, granted I'm not a full-time DB designer, I am slightly confused by the statement:

Some people would still use the three columns, using a silly...

Gail,

Thanks for the help.

Whenever I run query...whether in QA or from the front-end app itself...it runs fast. I haven't been able to get the query to run slow...but I have...