Forum Replies Created

Viewing 15 posts - 2,071 through 2,085 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    Luis Cazares (11/18/2016)

    ... so I can play with virtual machines just like the other kids?

    I haven't created a VM on a machine I own for probably a year now (and...

    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

    November 18, 2016 at 1:30 pm

    #1913522

  • RE: MAXDOP and HT

    PiMané (11/18/2016)

    HT cores don't have the same performance as real cores have... (I think).

    Maybe do some research and testing before jumping to conclusions?

    In the example I gave it can 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

    November 18, 2016 at 8:48 am

    #1913463

  • RE: MAXDOP and HT

    PiMané (11/18/2016)

    It's not logical to set MAXDOP to 2, for example, on a 4 core 8 HT and SQL use 2 HT cores...

    Why not?

    Shouldn't the scheduler only show 8...

    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

    November 18, 2016 at 6:46 am

    #1913411

  • RE: MAXDOP and HT

    PiMané (11/18/2016)

    The best practice is to disable in the BIOS...

    Err, maybe back at the time of the first generation of hyperthreading, but not any longer.

    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

    November 18, 2016 at 5:13 am

    #1913371

  • RE: Are the posted questions getting worse?

    TomThomson (11/17/2016)

    GilaMonster (11/16/2016)

    Lynn Pettis (11/16/2016)

    Question, any way to get these keynotes to view later? I would like to share these with others here at work. Plus, I came...

    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

    November 18, 2016 at 12:42 am

    #1913304

  • RE: Log Shipping: From SS2014 Server to SS2016 Server?

    Gail Wanabee (11/17/2016)

    What Books Online recommends is possible if I log ship from SS2014 (primary) to SS2014 (secondary).

    Yes, you can restore the logs WITH STANDBY and hence have 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

    November 17, 2016 at 1:50 pm

    #1913238

  • RE: Benefits of SQL 2014/2016 over 2005 ??

    homebrew01 (11/17/2016)

    Can I restore SQL 2005 Master, model, msdb databases to 2016 ?

    You do not want to do that (master won't, the others shouldn't). Script things, apply on new instance.

    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

    November 17, 2016 at 12:14 pm

    #1913204

  • RE: Benefits of SQL 2014/2016 over 2005 ??

    As of last night the killer reason to move to 2016 is to get SP1 which makes the previously Enterprise-only programability features now available in all editions. Eg In-memory OLTP,...

    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

    November 17, 2016 at 12:13 pm

    #1913203

  • RE: Log Shipping: From SS2014 Server to SS2016 Server?

    Gail Wanabee (11/15/2016)

    I have attempted to offload all the non-OLTP work by implementing a log shipping solution (to provide a read-only copy of the database on another server, a SS2016...

    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

    November 17, 2016 at 11:02 am

    #1913168

  • RE: Are the posted questions getting worse?

    Luis Cazares (11/17/2016)

    GilaMonster (11/17/2016)

    jasona.work (11/17/2016)

    So really, if you could figure out a way to live without Agent, you could drop down to Express and *really* save some money...

    And with only...

    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

    November 17, 2016 at 10:42 am

    #1913160

  • RE: Are the posted questions getting worse?

    jasona.work (11/17/2016)

    So really, if you could figure out a way to live without Agent, you could drop down to Express and *really* save some money...

    And with only 4 cores, 1...

    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

    November 17, 2016 at 10:07 am

    #1913156

  • RE: Are the posted questions getting worse?

    Ed Wagner (11/17/2016)

    Does this mean that our on-premise SE will be able to use the EE features like compression, columnstore and hekaton?

    Yes. (once you apply SQL 2016 SP1)

    What does this...

    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

    November 17, 2016 at 10:06 am

    #1913155

  • RE: Are the posted questions getting worse?

    Lynn Pettis (11/16/2016)

    GilaMonster (11/16/2016)

    Lynn Pettis (11/16/2016)

    Question, any way to get these keynotes to view later? I would like to share these with others here at work. Plus, I...

    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

    November 16, 2016 at 3:28 pm

    #1912929

  • RE: Data is not ordered correctly with pagination - Sql Server 2012

    francesco.giusto.sb (11/16/2016)

    Yes, adding ORDER BY solves my problem, but Hibernate (at least using 3.6.10 with SqlServer2008Dialect) won't translate it in that way. It will just output that query without...

    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

    November 16, 2016 at 9:49 am

    #1912850

  • RE: Are the posted questions getting worse?

    Edit: nevermind, need to check.

    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

    November 16, 2016 at 9:38 am

    #1912844

Viewing 15 posts - 2,071 through 2,085 (of 49,552 total)