Forum Replies Created

Viewing 11 posts - 1 through 12 (of 12 total)

  • RE: how to avoid duplicate business logic

    All the developers are on both SQL and .Net, so we will not have those kind of problems.

    Most of my concerns are regarding keeping everything in one place, and as...

  • RE: how to avoid duplicate business logic

    Jayanth_Kurup (10/2/2012)


    faster simpler better coding relies on moving business logic to the application layer. This is proven in many SOA implementations. The DB should stick to simple crud operations. The...

  • RE: how to avoid duplicate business logic

    ChrisM@Work (10/2/2012)


    If you can't code it up as a view, then it's unlikely that you can code it up as a query.

    You could still do it as a quite complex...

  • RE: how to avoid duplicate business logic

    Views would be a better option than functions - coded properly they won't hammer performance quite like the suggested UDF. You can't find a good example right now - if...

  • RE: how to avoid duplicate business logic

    Roland Alexander STL (10/2/2012)


    norbert.manyi (10/2/2012)


    Take the following example:

    select * from tbl_Users U where U.active = 1 and U.deleted = 0

    How is the application owner changing the business logic? Is the...

  • RE: trailing space in len() problem

    That's not what I said....

    I know that you mentioned memory issues, but I took this as 'there must have been some a bunch of other bugs as well'

    Either way, I...

  • RE: trailing space in len() problem

    The owner of that instance played around with some settings/files and now she cannot update her SQL 🙂

    So basically I shouldn't worry about this as it's most likely to be...

  • RE: trailing space in len() problem

    both are 2005

    9.00.5000.00 on win 3790 on Intel x86

    9.00.1399.06 on win 7601 on AMD x64

  • RE: trailing space in len() problem

    gorgeous idea, but this isn't it

    it's 0 on both servers...

  • RE: trailing space in len() problem

    Yes, they are indeed consistent...

    Although I am still curious about why len() doesn't work...

  • RE: trailing space in len() problem

    thanks, I will try this...

    just a point... I'm not interested in trailing spaces, I'm only interested in consistency...

    If I try the above-mentioned example with 'aa, a' I will get consistent...

Viewing 11 posts - 1 through 12 (of 12 total)