Viewing 15 posts - 1 through 15 (of 43 total)
Thanks John...I always wondered about that.
June 26, 2012 at 11:12 am
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...
June 26, 2012 at 5:40 am
Thanks for the info opc.three!
February 29, 2012 at 7:40 am
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...
February 29, 2012 at 6:29 am
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...
February 28, 2012 at 1:08 pm
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...
February 23, 2012 at 5:25 am
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...
February 23, 2012 at 5:10 am
@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!
February 2, 2012 at 7:28 am
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%...
February 2, 2012 at 5:23 am
August 9, 2011 at 6:06 am
Look at Esteban Zimányi's 2006 paper "Temporal Aggregates and Temporal Universal Quanti?cation in Standard SQL" (available on pages 16 to 25 of this pdf doc, ...
Wow that's great...thanks for the...
July 15, 2011 at 5:18 am
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...
July 14, 2011 at 5:20 am
Well, NULL should always mean "The database doesn't contain...
July 1, 2011 at 5:52 am
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...
June 30, 2011 at 5:09 am
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...
September 2, 2008 at 6:27 am