Viewing 15 posts - 1 through 15 (of 85 total)
Thank You much! I'm Sorry, I got environments and environment variables mixed up in my first post. I also specified "Data Model" where I meant "Data Flow". ...
"Any fool can write code that a computer can understand. Good programmers write code that humans can understand." -- Martin Fowler
March 5, 2015 at 10:34 am
Edited -- I was sending this before I saw your second reply with examples. I will take a look at them. -- text removed.
"Any fool can write code that a computer can understand. Good programmers write code that humans can understand." -- Martin Fowler
March 5, 2015 at 10:10 am
Along this line about the Default datetime value display (in SQL Server 2005) I do not understand why if I declare a variable as a datetime type and set it...
"Any fool can write code that a computer can understand. Good programmers write code that humans can understand." -- Martin Fowler
October 30, 2013 at 1:57 pm
DUH! In this case it is sometimes difficult to see the tree because the forest gets in the way.
Thanks very much!! I spent way too much time on...
"Any fool can write code that a computer can understand. Good programmers write code that humans can understand." -- Martin Fowler
October 22, 2013 at 7:39 am
THANK YOU DREW! Your Cross Apply example was exactly what I needed. I tried to research the Cross Apply when you first suggested it, but the complexity of...
"Any fool can write code that a computer can understand. Good programmers write code that humans can understand." -- Martin Fowler
September 13, 2011 at 8:57 am
I do not see how a GROUP BY will help as I have done that several times. What I need to do a MAX(LIVAR_DATE) with a MAX(LIVAR_TIME) in the...
"Any fool can write code that a computer can understand. Good programmers write code that humans can understand." -- Martin Fowler
September 12, 2011 at 2:08 pm
See attached .doc file with DDL of the three tables in query. The CFTVCM9200 table has a seperate LIVAR_TIME two char field to denote the hour which would be...
"Any fool can write code that a computer can understand. Good programmers write code that humans can understand." -- Martin Fowler
September 12, 2011 at 10:05 am
Well John, I didn't realize you were a Brit until you wrote "...a formidible defence" instead of "defense"!
"Any fool can write code that a computer can understand. Good programmers write code that humans can understand." -- Martin Fowler
May 4, 2011 at 8:04 am
Andy,
The most terrific pair of articles I've read in a long time. I was particulary impressed with the way you handled options and errors. Most all of the...
"Any fool can write code that a computer can understand. Good programmers write code that humans can understand." -- Martin Fowler
February 20, 2011 at 12:50 pm
Being an OLTP developer and not an actual DBA, I really don't see what the big problem is, it that I would expect personnel (DBA) resources and hardware to increase...
"Any fool can write code that a computer can understand. Good programmers write code that humans can understand." -- Martin Fowler
January 14, 2011 at 9:11 am
Calling Access, Excel, and other tools low-end IS NOT a deprecation of the tool itself. They are considered low-end development tools because they fit into the low-end of the...
"Any fool can write code that a computer can understand. Good programmers write code that humans can understand." -- Martin Fowler
December 29, 2010 at 5:59 pm
User prototyping is one possible use of low end tools such as MS Access and others (actually there are hosts of better prototyping design tools for professionals). However, I...
"Any fool can write code that a computer can understand. Good programmers write code that humans can understand." -- Martin Fowler
December 14, 2010 at 11:44 am
The arguments for and against deterministic Biometric fingerprint analysis, retinal scans, etc. vs immutable password hashing all sound totally ridiculous because there is no one method that is proportionally better...
"Any fool can write code that a computer can understand. Good programmers write code that humans can understand." -- Martin Fowler
November 9, 2010 at 9:47 pm
I believe the military (chiefly the USAF -- not sure of other branches) has already resolved this issue (and I am not talking about ultra top secret installations) for general...
"Any fool can write code that a computer can understand. Good programmers write code that humans can understand." -- Martin Fowler
November 8, 2010 at 10:14 am
I also tried all four queries and found that query 1 (SELECT COUNT(*)) was marginally faster in the Client Statistics! Possibly its server dependent?
...
"Any fool can write code that a computer can understand. Good programmers write code that humans can understand." -- Martin Fowler
October 19, 2010 at 2:09 pm
Viewing 15 posts - 1 through 15 (of 85 total)