Forum Replies Created

Viewing 15 posts - 10,396 through 10,410 (of 49,552 total)

  • RE: Using (And) OR operators correctly

    Briceston (1/15/2014)

    GilaMonster (1/15/2014)

    I suspect (without any ability to test) that you want this

    WHERE ((([Serial Query].SER_OR_ADM_IND) = 'A'))

    AND t1.DISCHARGE_DISP ! = 'VVX'

    AND t1.VISIT_DATE = CONVERT(varchar,GETDATE(), 101)

    AND (t1.Diag_Code1 =...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 15, 2014 at 8:38 am

    #1680308

  • RE: Using (And) OR operators correctly

    I suspect (without any ability to test) that you want this

    WHERE ((([Serial Query].SER_OR_ADM_IND) = 'A'))

    AND t1.DISCHARGE_DISP ! = 'VVX'

    AND t1.VISIT_DATE = CONVERT(varchar,GETDATE(), 101)

    AND (t1.Diag_Code1 = '' OR...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 15, 2014 at 7:58 am

    #1680279

  • RE: How to give aliase name to column dynamically

    What's the purpose here? Why do you want a column dynamically named (I pity the front end app which uses that)

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 15, 2014 at 5:54 am

    #1680227

  • RE: SQL 2000 memory recommendations

    I'm not a fan of dev and prod on the same server (mess up dev and you can take prod down), but don't move just on account of memory, each...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 15, 2014 at 5:38 am

    #1680222

  • RE: Newly Migrated backend DB

    Update or insert a row into a table and check via the front end whether or not you can see the change.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 15, 2014 at 5:34 am

    #1680219

  • RE: SQL 2000 memory recommendations

    Right, standard edition.

    Standard is hard-capped at 2GB of memory. It can't use more so the other 4GB of memory you have on that server is wasted. So the 1.6GB looks...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 15, 2014 at 5:15 am

    #1680211

  • RE: Dynamic Query issue

    When you're debugging or performance tuning, try one thing at a time, test, evaluate, try something else. Change a bunch of stuff and you'll never be able to figure out...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 15, 2014 at 5:12 am

    #1680209

  • RE: SQL 2000 memory recommendations

    Probably means SQL doesn't need more. If you're not running load on it, it won't use more memory than it needs.

    That said, that looks like 32-bit without AWE or /3GB....

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 15, 2014 at 5:09 am

    #1680208

  • RE: SQL 2000 memory recommendations

    Plateau (1/15/2014)

    GilaMonster (1/15/2014)

    Oh, and turn boost priority OFF. It's a setting that should almost never be enabled

    Will do Gail, would you mind explaining this?

    Not being argumentative just wanting/trying to understand

    Books...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 15, 2014 at 5:07 am

    #1680204

  • RE: SQL 2000 memory recommendations

    Oh, and turn boost priority OFF. It's a setting that should almost never be enabled

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 15, 2014 at 4:50 am

    #1680198

  • RE: SQL 2000 memory recommendations

    Don't use Task Manager to check SQL's memory, it displays incorrect values.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 15, 2014 at 4:45 am

    #1680194

  • RE: Correctly sizing Temp datafiles

    Or, unless you're pressed for space, leave them at 20GB?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 15, 2014 at 4:43 am

    #1680193

  • RE: Are the posted questions getting worse?

    rodjkidd (1/15/2014)

    Oh and I see that @SQLBits has replied saying there will be an announcement soon, just hope it doesn't clash with any of the Saturdays in May / June...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 15, 2014 at 4:35 am

    #1680188

  • RE: Correctly sizing Temp datafiles

    Sort and hash warnings are in-memory operations that don't fit into memory and hence spill to TempDB, they're not an indication that TempDB is too small (that would be autogrow...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 15, 2014 at 4:21 am

    #1680184

  • RE: Dynamic Query issue

    Stuart Davies (1/15/2014)

    But something tells me that the the #temp table won't be visible to the dynamic sql.

    It will be, but since it's not referenced anywhere inside the dynamic SQL...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 15, 2014 at 3:02 am

    #1680157

Viewing 15 posts - 10,396 through 10,410 (of 49,552 total)