Forum Replies Created

Viewing 15 posts - 23,731 through 23,745 (of 49,552 total)

  • RE: SQL 2005 Max Memory Setting on Cluster

    MiguelSQL (9/2/2011)

    I knew I was forgetting something

    64 bit and AWE = 1

    Turn AWE off. It has absolutely no use on 64-bit processes.

    Using locked pages?

    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

    September 2, 2011 at 3:53 pm

    #1376709

  • RE: Recovery Models

    Depends on what kind of disaster, what it damaged and what it left intact.

    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

    September 2, 2011 at 2:06 pm

    #1376680

  • RE: Performance Problem that I can't pin down

    Grant Fritchey (9/2/2011)

    I was just reading about monitoring latch waits over on Paul Randal's blog. He suggested this white paper to understand what's happening with latch waits..

    There seems to be...

    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

    September 2, 2011 at 1:19 pm

    #1376659

  • RE: Are the posted questions getting worse?

    GSquared (9/2/2011)

    GilaMonster (9/2/2011)

    SQLRNNR (9/2/2011)

    For the most part $7.25, but Wyoming (for example) dips to $5.15.

    That's not half-bad. Until a few months ago my friend (environmental consultant with 3 university degrees)...

    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

    September 2, 2011 at 1:17 pm

    #1376658

  • RE: Are the posted questions getting worse?

    GSquared (9/2/2011)

    The majority of people "below the poverty line" in the US own a house, 1 car, 2 TVs, 1 gaming consol, and eat 120-150% of the USRDA of calories....

    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

    September 2, 2011 at 1:11 pm

    #1376654

  • RE: select * from tbl where like is all

    Frances L (9/2/2011)

    I will like to simply the other thing.

    What 'other thing'?

    It is hard to explain the whole intention of my coding.

    If you can't explain it, how do you...

    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

    September 2, 2011 at 12:55 pm

    #1376645

  • RE: select * from tbl where like is all

    A straight SELECT * FROM <table> will return all columns, all rows.

    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

    September 2, 2011 at 12:50 pm

    #1376642

  • RE: Performance Problem that I can't pin down

    hmm.... @@version?

    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

    September 2, 2011 at 12:49 pm

    #1376639

  • RE: Are the posted questions getting worse?

    SQLRNNR (9/2/2011)

    For the most part $7.25, but Wyoming (for example) dips to $5.15.

    That's not half-bad. Until a few months ago my friend (environmental consultant with 3 university degrees) was making...

    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

    September 2, 2011 at 12:27 pm

    #1376624

  • RE: Are the posted questions getting worse?

    Jack Corbett (9/2/2011)

    In comparison to most 2nd and 3rd world countries a person making minimum wage in the US is making "Amazingly High Wages".

    Out of curiosity, what is US minimum...

    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

    September 2, 2011 at 11:39 am

    #1376599

  • RE: Performance Problem that I can't pin down

    Latch_Ex on what kind of latch?

    Latches (as opposed to PageLatch and PageIOLatch) are memory-related waits. Hence need to know what kind of latchwaits you're seeing.

    http://sqlcat.com/sqlcat/b/whitepapers/archive/2011/07/05/diagnosing-and-resolving-latch-contention-on-sql-server.aspx

    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

    September 2, 2011 at 10:48 am

    #1376566

  • RE: Are the posted questions getting worse?

    GSquared (9/2/2011)

    So, I've probably had wildlife closer than Gail has, despite the fact that she lives in a grass hut and hasn't ever even heard of electricity or running water....

    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

    September 2, 2011 at 9:28 am

    #1376513

  • RE: Large Comment Blocks Causing Issues

    A plan won't be cached if there's an >8000 character literal in the query, but that's a literal, not a comment. The SQL parser strips comments out, what gets to...

    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

    September 2, 2011 at 9:25 am

    #1376510

  • RE: Please help analyzing MS SQL Database Logfile(s)

    Subjective Adapts (9/2/2011)

    sys.dm_db_log_space_usage will give the log file usgae.you will be getting similar information when you retrive the data using DBCC SQLPERF('logspace').However this dbcc command will give you output for...

    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

    September 2, 2011 at 9:20 am

    #1376507

  • RE: read uncomitted doesn't work

    Considered snapshot isolation?

    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

    September 2, 2011 at 9:02 am

    #1376483

Viewing 15 posts - 23,731 through 23,745 (of 49,552 total)