Forum Replies Created

Viewing 15 posts - 9,421 through 9,435 (of 49,552 total)

  • RE: SQL server is takes all memory

    SQL manages its own memory very well. There's a hell of a lot to it. If you want the details, get a copy of "Troubleshooting SQL Server: A guide 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

    April 3, 2014 at 10:09 am

    #1702944

  • RE: Memory configuration

    If that's what the documentation says, then that's what it can take.

    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

    April 3, 2014 at 10:08 am

    #1702942

  • RE: dumping fields in a single column of database.. is this a right way to achieve performance in sql..

    Cody K (4/3/2014)

    - I'm not sure what the benefit would be for the programmers to go through an ORM layer to translate arbitrary XML data into a column format, if...

    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

    April 3, 2014 at 10:04 am

    #1702940

  • RE: Ideal table for Memory Optimization ?

    Koen Verbeeck (4/3/2014)

    GilaMonster (4/3/2014)

    Jeff Moden (4/2/2014)

    Koen Verbeeck (4/2/2014)

    GilaMonster (4/1/2014)

    In-memory OLTP (hekaton) is for heavy concurrent load (tens of thousands of concurrent connections with thousands of inserts/sec). The advantage is the...

    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

    April 3, 2014 at 1:14 am

    #1702750

  • RE: Memory configuration

    The documentation is correct (unsurprising)

    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

    April 3, 2014 at 1:02 am

    #1702744

  • RE: dumping fields in a single column of database.. is this a right way to achieve performance in sql..

    Pro: flexible

    Cons: Performance, no data integrity, misuse of a relational structure (sounds like they want a schema-less database, one of the NoSQL variants), hard to manage

    When you would use it:...

    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

    April 3, 2014 at 12:53 am

    #1702741

  • RE: SQL server is takes all memory

    By design, normal, documented behaviour. SQL will take all the memory it is allowed to use.

    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

    April 3, 2014 at 12:50 am

    #1702740

  • RE: Ideal table for Memory Optimization ?

    Jeff Moden (4/2/2014)

    Koen Verbeeck (4/2/2014)

    GilaMonster (4/1/2014)

    In-memory OLTP (hekaton) is for heavy concurrent load (tens of thousands of concurrent connections with thousands of inserts/sec). The advantage is the lock-less, latch-less optimistic...

    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

    April 3, 2014 at 12:49 am

    #1702739

  • RE: Are the posted questions getting worse?

    dup

    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

    April 2, 2014 at 10:18 am

    #1702546

  • RE: Are the posted questions getting worse?

    Ville-Pekka Vahteala (4/2/2014)

    Could it be because True is actually instance of class bool and therefore you are not testing boolean operation, but instead testing equivalence of two classes?

    No, the value...

    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

    April 2, 2014 at 10:07 am

    #1702541

  • RE: Execution Plan what to look for

    SQL Guy 1 (4/2/2014)

    Grant Fritchey (4/2/2014)

    There's a lot to it. I wrote a book on the topic (look in the links below). But, to get you started, I'd recommend...

    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

    April 2, 2014 at 9:59 am

    #1702538

  • RE: Are the posted questions getting worse?

    It's not the language I have an issue with. It's different, the indenting will take some getting used to, there are odd conventions about how to handle lists and other...

    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

    April 2, 2014 at 7:53 am

    #1702468

  • RE: CHECKTABLE

    You may want to reopen that case.

    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

    April 2, 2014 at 7:12 am

    #1702450

  • RE: Blocking and WRITELOG wait type

    PearlJammer1 (4/2/2014)

    Would the locks that where taken out on the resources by the stored proc that was causing the blocking be held until the log file had been committed 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

    April 2, 2014 at 7:11 am

    #1702449

  • RE: logical consistency-based I/O error

    So that saturday backup should be clean, since the CheckDB which ran after it was without error.

    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

    April 2, 2014 at 7:00 am

    #1702441

Viewing 15 posts - 9,421 through 9,435 (of 49,552 total)