Forum Replies Created

Viewing 15 posts - 946 through 960 (of 6,036 total)

  • RE: Detecting Issues

    Oh, really?

    How much did they pay you, say last month, for the software which you developed 5 years ago and which is working since then with no issues?

    Ah, you probably...

  • RE: Tally generator

    ChrisM@Work - Friday, February 17, 2017 9:38 AM

    Nice, Sergiy, and very useful.
    I'm guessing that you've checked out all of the alternatives...

  • RE: Detecting Issues

    Those potential issues that never get to the customer are wins for me, and I think this is something we should be proud of as software engineers and testers.

  • RE: Joining INSERTED and UPDATED tables when PK column changes

    Xedni - Wednesday, February 15, 2017 4:57 PM

    To make a long story short, my question boils down to this: If a primary...

  • RE: get date / only sql

    Thom A - Monday, February 27, 2017 4:23 AM

    Thom A - Monday, February 27, 2017 4:23...

  • RE: get date / only sql

    Everything is much simpler, really

    SELECT Whatever
    FROM orders
    where Orderdate >= @OrderdateOnly
    and OrderDate < dateadd(dd, 1, @OrderdateOnly)

  • RE: Count(*) output blank but required Zero

    rot-717018 - Monday, February 27, 2017 1:40 AM

    A field in your SELECT returns a NULL and thus the entire concatenated line is NULL.
    Replacing...

  • RE: Count(*) output blank but required Zero

    Placing the filter on dates to WHERE clause turns LEFT JOIN to INNER JOIN.

    Move it up, the the join condition:

    SELECT 
    '[ID- 1411]+ ',' +...

  • RE: IO Performance Problem

    Could it be caused by DB file auto-grow?

    How much free space do you have in the files?

    Do you shrink DB files overnight?

  • RE: Where is that CPU gone? (Profiler Trace)

    Eric Mamet - Tuesday, February 14, 2017 11:00 AM

    I have a stored procedure (uspRetrieveMonthlyDiagnosticsForFrontEnd) that takes about 6 seconds.
    Almost all processing...

  • RE: Trouble with openxml query

    Jeff Moden - Thursday, February 16, 2017 6:26 PM

    Sergiy - Thursday, February 16, 2017 5:46 PM

    February 17, 2017 at 1:31 pm

    #1929199

  • RE: Tally generator

    I posted it only because it's used in the article scripts, so if it gets published I can refer to this post.

  • RE: Tally generator

    I had status "Commited" for 2 years in a busy Production system.

    Not a soul complained.

    Till I spotted and fixed it myself.

    🙂

  • RE: Trouble with openxml query

    I'm not sure I can understand what's such a big deal with SSN, why it should be so secret.

    We here in NZ also have some ID numbers.

    Driver license is used...

  • RE: Trouble with openxml query

    pisorsisaac - Sunday, February 12, 2017 3:01 PM

    Thanks much to those who helped me, I appreciate it.

    To whoever it was that apparently...

Viewing 15 posts - 946 through 960 (of 6,036 total)