Viewing 15 posts - 121 through 135 (of 178 total)
call.copse (1/30/2014)
Was there anyone whose heart's cockles were left unwarmed by this story? An oldie but goldie.
That was an excellent article. Thanks for posting it as I...
January 30, 2014 at 7:39 am
Steve said in the article, "It almost seems as though digital ideas and software defy analogies and explanations that we can relate to the real world."
Like all of you, I'm...
January 30, 2014 at 7:18 am
Thomas Abraham (1/30/2014)
I share your sentiments. However, from personal experience, I can tell you there are still plenty of databases out their that look like they were designed by someone...
January 30, 2014 at 7:10 am
zsolt.miskolczi (12/5/2013)
;WITH e1(n) AS
(
SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 1 UNION ALL
SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 1 UNION ALL
SELECT 1 UNION...
December 5, 2013 at 10:10 am
Andy DBA (11/12/2013)The second criteria in the code snippet above won't filter anything, because ALL COLUMNS returned from CourseCompleted will be NULL
Right you are. In my haste to explain...
November 13, 2013 at 8:08 am
Andy DBA (11/12/2013)
WHERECourseCompleted.CourseId IS NULL
AND CourseCompleted.DateComplete >= '1/1/2013' --Failed attempt to list all courses missed this year
I remember learning that lesson too. Before I knew I could add...
November 12, 2013 at 4:17 pm
the purpose of the article was to show how to get the results using the outer join
I think it was a good choice as it made the example easy to...
November 12, 2013 at 11:10 am
wagner crivelini (11/12/2013)
thx for sharing, PatrickI always complain how hard it is to find practical uses of the CROSS JOIN and you showed us a nice example.
I agree. A...
November 12, 2013 at 11:05 am
Steve, FYI...
Not sure if this is me or the email but I clicked the "Join the discussion" link in the email this morning but was brought to following page:
February 21, 2013 at 8:41 am
We have a credit card application that requires password complexity and that it be changed every 90 days and I imagine all of them are required to do this because...
January 17, 2013 at 6:30 am
I've been on the SQL Server Central mailing list for some time (5 or 6 years?) and I've always been confused why recycled topics like this one get sent out...
October 12, 2012 at 9:25 am
sajjanmukesh_83 (10/12/2012)
Great Article! I feel this is the platform to learn more about SSIS.Looking forward fot the series!!
If you got here from an email today (and if you didn't notice...
October 12, 2012 at 7:52 am
This comment truly isn't a rant and definitely not an attack on Rob, it's just that I'm failing to see where any of this is useful in my daily SQL...
October 11, 2012 at 4:18 pm
Enjoyed both articles and I'm learning from them. I kind of expected a little more during this step but maybe that's just me being impatient?:-D
I do have a curiosity...
September 26, 2012 at 2:08 pm
Thanks for taking the time to write such a detailed article. I feel I've learned something. I've always been of the mindset to not mess with system tables...
September 17, 2012 at 11:00 am
Viewing 15 posts - 121 through 135 (of 178 total)