Forum Replies Created

Viewing 15 posts - 1,756 through 1,770 (of 8,416 total)

  • RE: 'Other' wait oddity in Activity Monitor

    Scott H (8/12/2011)

    Paul - Thanks for the link. I've put that on the server and run it, but I'm not getting any wait_info back for 'normal' spids - I'm...

    August 12, 2011 at 9:27 am

    #1368011

  • RE: 'Other' wait oddity in Activity Monitor

    Scott H (8/11/2011)

    According to the Activity Monitor window, under the 'Resource Waits' category, the server appears to have a constant lag of over 8000ms of 'Other' wait.

    Activity Monitor is a...

    August 12, 2011 at 8:04 am

    #1367941

  • RE: trying to reduce the amount of logical reads

    GilaMonster (8/12/2011)

    The Dixie Flatline (8/11/2011)

    If the ID is included as part of the index, the optimizer can find MAX by matching on [field_name1] and [field_name2], then reading the last value...

    August 12, 2011 at 7:32 am

    #1367913

  • RE: Are the posted questions getting worse?

    bitbucket-25253 (8/10/2011)

    Cast my vote as the ninth (9th) For. Come on people lets support Brandie

    12th

    August 11, 2011 at 12:04 am

    #1367058

  • RE: How well do you know MAX?

    Hi John,

    I think you may have missed the humour in Tom's reply to you, but never mind.

    There's nothing incompatible between that general BOL advice and what's been said so far....

    August 6, 2011 at 11:40 pm

    #1364848

  • RE: How well do you know MAX?

    Tom.Thomson (8/5/2011)

    I would hope that most people realise that in applications where monetary values range from 0.01 units to 90071992547409.92 units (something over nine hundred million million units), and no...

    August 5, 2011 at 9:18 pm

    #1364733

  • RE: How well do you know MAX?

    Dave62 (8/5/2011)

    For those who were expecting the third highest salary, here is a select for that [...]

    Or, slightly more compactly:

    select max(Salary) from @table where Salary <

    ((select max(Salary) from @table where...

    August 5, 2011 at 9:00 pm

    #1364732

  • RE: How well do you know MAX?

    You almost had me :laugh:

    August 5, 2011 at 8:51 pm

    #1364731

  • RE: IsNumeric with NULL and Empty String

    Tom.Thomson (8/4/2011)

    ...if it delivers a non-zero result the next thing to happen will probably be the conversion and that was probably already done once...

    Indeed. Worse, people might write the...

    August 4, 2011 at 2:26 pm

    #1363986

  • RE: Niagara Falls

    SanDroid (8/4/2011)

    I just clicked it the link again on two systems and got the Connect page for this issue. Could it be the https part that is not working...

    August 4, 2011 at 12:38 pm

    #1363892

  • RE: IsNumeric with NULL and Empty String

    SanDroid (8/4/2011)

    "Code to enforce Business Rules should not be in SQL!"

    Some days, I would go further:

    "Code to enforce Business Rules should not be in SQL!"

    August 4, 2011 at 12:34 pm

    #1363889

  • RE: Niagara Falls

    SanDroid (8/4/2011)

    Several of you seem to agree that this is a bug that they can reproduce.

    However the count of user that can re-create and users that think this...

    August 4, 2011 at 12:28 pm

    #1363882

  • RE: IsNumeric with NULL and Empty String

    sknox (8/4/2011)

    While it's in many ways better than IsNumeric, TRY_CONVERT does have some problems.

    Oddly enough, this is exactly the stance I took a week or so ago in a discussion...

    August 4, 2011 at 12:20 pm

    #1363870

  • RE: IsNumeric with NULL and Empty String

    IsNumeric - sigh.

    Thank goodness for the improvements in the next version of SQL Server like TRY_CONVERT.

    August 4, 2011 at 8:41 am

    #1363697

  • RE: Are the posted questions getting worse?

    GilaMonster (8/3/2011)

    Tom.Thomson (8/3/2011)

    ...because US immigration control has deteriorated to the point where no-one in his right mind wants to travel to the USA anyway

    Tell me about it. It's about the...

    August 3, 2011 at 11:41 pm

    #1363448

Viewing 15 posts - 1,756 through 1,770 (of 8,416 total)