Viewing 15 posts - 211 through 225 (of 401 total)
It never ceases to amaze me just how easy movies and TV make complex computing tasks like hacking unknown systems (what if the aliens didn't have a binary system?), high-speed...
LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com
July 4, 2016 at 5:00 am
pietlinden (6/30/2016)
LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com
June 30, 2016 at 2:52 pm
Jeff Moden (6/29/2016)
I treat SSN as one of the most sacred of all pieces of PII even if the Social Security Administration and the medical/financial/general community at large does not.
Yeah,...
LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com
June 29, 2016 at 2:58 pm
Personally, I prefer using an account name as email addresses are much more subject to change. I've had issues where I could not change my email account (not on...
LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com
June 29, 2016 at 12:35 pm
xsevensinzx (6/24/2016)
LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com
June 24, 2016 at 2:39 pm
I've lost track of the number of database applications that I've built from scratch over the last 30 years. One thing is true though, I never got them completely...
LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com
June 24, 2016 at 5:47 am
kerry_hood (6/24/2016)
A bit scary for our future databases.
Way back when I was in school (still in the days of green bar line printers) subjects like database theory, set theory, and...
LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com
June 24, 2016 at 4:27 am
g.britton (6/10/2016)
In the spirit of DRY, I feel I should point out that this variant repeats references
Yes, you are correct that column references are repeated. I feel that those...
LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com
June 10, 2016 at 7:30 am
The use of APPLY is interesting and I did learn a couple of things, but in my opinion the CTE approach exemplified earlier is cleaner and easier to read especially...
LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com
June 10, 2016 at 6:06 am
Lynn Pettis (6/6/2016)
I don't agree with teaching a crutch.
It's not teaching the crutch, but teaching that the crutch is NOT NECESSARY.
LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com
June 6, 2016 at 8:26 am
Toreador (6/6/2016)
Aaron N. Cutshall (6/6/2016)
However, I do understand the intent of the QotD however it was presented.What was that intent, to encourage sloppy coding?
Yes, it's a lazy approach that some...
LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com
June 6, 2016 at 8:25 am
Lynn Pettis (6/6/2016)
Actually, if you add a statement using a CTE after a statement that is not properly terminated, go back and properly terminate it. Simple.
That's what I do...
LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com
June 6, 2016 at 8:09 am
Terje Hermanseter (6/3/2016)
I don't understand why MS is wavering on the commitment to enforce them as they've been part of the ISO-1999 standard for a very long time.
Too much old...
LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com
June 3, 2016 at 6:31 am
paul s-306273 (6/3/2016)
From my old days of Oracle, I seem to remember it was compulsory in SQL*Plus;
We've been told for some time (since 2005 I think) that semicolons were going...
LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com
June 3, 2016 at 6:15 am
Recce70 (3/15/2016)
LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com
March 15, 2016 at 1:24 pm
Viewing 15 posts - 211 through 225 (of 401 total)