Skip to main content

Kerr

Member since Dec 11, 2008

Recent Blog Comments By Kerr

  • Software Application Layers And Responsibilities

    Posted on Dec 24, 2012 at 9:39 AM

    @Ben, That's great you're using DI/1. I imagine you've come across the injectProperties factory method for dealing with bean arguments. It can be interesting making sure that argument names don't conflict when you do lots of setter injection though. Still, not being married to com.x.y.z or some ... read more »

  • Software Application Layers And Responsibilities

    Posted on Dec 21, 2012 at 8:47 PM

    Oh, the other thing I think that bears mention from a dependency perspective is this: Strongly consider how coupled your service / data persistence layer is to anything else. Ideally, it should be able to be propped up, tested, and survive on its own accord without anything else touching it. Cert... read more »

  • Software Application Layers And Responsibilities

    Posted on Dec 21, 2012 at 8:42 PM

    I always enjoy reading your thoughts, Ben. You're eager to challenge your current thinking, which I find a bit rarer than I'd like. I really am with you on having a thin Controller layer, and view it as more of a traffic cop role than anything else. Regarding dependencies, I have found that to be... read more »

  • Getting Only the Date Part of a Date/Time Stamp in SQL Server

    Posted on May 9, 2012 at 8:34 AM

    @Praveen, That only works fine if you are on SQL Server 2008+, when the DATE data type was introduced. A lot of this discussion occurred before that product release. Also, that still only gets you to the date itself and will not help in situations where you want to get the month, quarter or year.... read more »

  • A Book Apart: Designing For Emotion By Aarron Walter

    Posted on Dec 6, 2011 at 6:40 PM

    ..." it struct me as being absolutely brilliant." Written like a true ColdFusion developer.... read more »

  • Getting Only the Date Part of a Date/Time Stamp in SQL Server

    Posted on Nov 21, 2011 at 9:50 AM

    "I daresay this is somewhat slower than using floor though." - That is definitely an understatement. See my post dated May 13, 2010 at 8:49 AM with a link to a test SQL script. The takeaway: Any method which converts data to another data type is going to be very slow. Dates are numbers.... read more »

  • Getting Only the Date Part of a Date/Time Stamp in SQL Server

    Posted on Sep 8, 2011 at 12:37 PM

    On 2008R2 those methods are by far the most straightforward. As far as performance goes, I recommend side by side tests. This thread is epic in length, but somewhere above I linked to some testing scripts I wrote years ago.... read more »

  • Getting Only the Date Part of a Date/Time Stamp in SQL Server

    Posted on Mar 2, 2011 at 8:38 AM

    @Eric, Are you working with SQL Server pre-2008? If you're on 2008, you have access to the dedicated DATE and TIME data types. They save a lot of storage space and still provide the separation you seek. We're in a (mostly) 2005 environment, so I don't have access to them. @Ben - OT, but I've be... read more »

  • Using Deferred Objects In jQuery 1.5 To Normalize API Responses

    Posted on Feb 12, 2011 at 10:50 PM

    Nice article, I'm looking forward to playing around with deferreds. jQuery has long been one of my favourite tools, and it just keeps getting better. "I'm still exploring myself." - TWSS Sorry, couldn't resist. :)... read more »

  • Happy Holidays From Ben Nadel And BenNadel.com

    Posted on Dec 24, 2010 at 11:49 AM

    Same to you, Ben! I don't post much, but I always enjoy reading your well written and informative blogs.... read more »

  • Getting Only the Date Part of a Date/Time Stamp in SQL Server

    Posted on May 13, 2010 at 10:39 AM

    René - Whoops, I bet that's why my post ended up not showing up here in the thread. ;) The link to my test script is the most important thing, and it looks like that was retained in my post from today.... read more »

  • Getting Only the Date Part of a Date/Time Stamp in SQL Server

    Posted on May 13, 2010 at 8:49 AM

    Aaargh, from time to time I have trouble posting long comments on here. A few days ago, I posted a long reply to TBonzai's posting of a UDF, linking to many external resources and articles to explain why UDFs will always tank performance, especially when used on large tables. In the hopes that thi... read more »

  • Getting Only The Date Part Of A Date/Time Stamp in SQL Server (Revisited)

    Posted on May 13, 2010 at 8:41 AM

    Geoff - I recommend viewing the (very long) string of comments in another related thread at http://www.bennadel.com/blog/122-Getting-Only-the-Date-Part-of-a-Date-Time-Stamp-in-SQL-Server.htm Bottom line - I don't use CAST/CONVERT for any action in SQL Server when it's not necessary. I use variou... read more »

  • Getting Only the Date Part of a Date/Time Stamp in SQL Server

    Posted on Aug 13, 2009 at 2:41 PM

    @Jeremy - Your P.S. is ambiguous. Performance gain vs. which method(s)? I've seen zero methods perform better than the datediff/dateadd scenarios in my own tests.... read more »

  • Getting Only the Date Part of a Date/Time Stamp in SQL Server

    Posted on Jun 3, 2008 at 3:34 PM

    Hmm, thought I could use unordered lists here... my bad!... read more »

  • Getting Only the Date Part of a Date/Time Stamp in SQL Server

    Posted on Jun 3, 2008 at 3:33 PM

    FWIW, I have found in my testing two things: <ul> <li>Any data type conversion is much slower than the dateadd method.</li> <li>Encasing this functionality inside a function (see my trunc function above) results in much slower processing as opposed to just writing out the ... read more »

  • Getting Only The Date Part Of A Date/Time Stamp in SQL Server (Revisited)

    Posted on Oct 10, 2007 at 8:20 AM

    I can corroborate the statement about UDF encapsulation being slow. SQL Server's date handling is pathetic when compared to Oracle's implementation, so I created a UDF (posted elsewhere on this blog) that mimics the TRUNC function in Oracle. I utilized various nested functions to truncate datetime... read more »

  • Getting Only the Date Part of a Date/Time Stamp in SQL Server

    Posted on May 17, 2007 at 2:38 PM

    I know I'm late to the party, but having dealt with both SQL Server and Oracle at length, it's easy to say that date handling and manipulation in SQL Server leaves much to be desired. As evidenced by this thread, truncating dates in SQL Server oftentimes involves massive amounts of function nesting... read more »

I believe in love. I believe in compassion. I believe in human rights. I believe that we can afford to give more of these gifts to the world around us because it costs us nothing to be decent and kind and understanding. And, I want you to know that when you land on this site, you are accepted for who you are, no matter how you identify, what truths you live, or whatever kind of goofy shit makes you feel alive! Rock on with your bad self!
— Ben Nadel