Forum Replies Created

Viewing 15 posts - 1,606 through 1,620 (of 49,552 total)

  • RE: Statistics with NORECOMPUTE

    Don't think so, DBCC Show_Statistics does.

    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

    March 30, 2017 at 4:22 am

    #1935669

  • RE: Statistics with NORECOMPUTE

    Yes. On very small tables it'll be sample 100%, as the size goes up the sample % goes down.

    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

    March 30, 2017 at 3:51 am

    #1935659

  • RE: 2016 Cluster Questions For Always On but also with other services

    SQLKnowItAll - Wednesday, March 29, 2017 3:19 PM

    Not to mention, SSIS is not cluster aware and would still have 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

    March 29, 2017 at 3:25 pm

    #1935617

  • RE: Statistics with NORECOMPUTE

    sgmunson - Wednesday, March 29, 2017 1:07 PM

     I suspect it was just a good option to provide to for those READ...

    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

    March 29, 2017 at 3:01 pm

    #1935615

  • RE: 2016 Cluster Questions For Always On but also with other services

    Yes, but a cluster with all services, and trying to merge failover cluster and AG (and I don't even think you can do that), is a really bad idea. Overloaded,...

    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

    March 29, 2017 at 2:56 pm

    #1935614

  • RE: Are the posted questions getting worse?

    Someone who knows more than me about clustering, please weigh in?
    https://www.sqlservercentral.com/Forums/1867482/2016-Cluster-Questions-For-Always-On-but-also-with-other-services

    What he's thinking sounds like a bad idea, and if I saw a client...

    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

    March 29, 2017 at 2:53 pm

    #1935611

  • RE: Recompiling all objects , stored procedures after moving to new server

    sqlguy80 - Wednesday, March 29, 2017 12:19 PM

    Thanks Gail for the quick responses.

    So if we reduce the memory , say SQL is...

    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

    March 29, 2017 at 2:51 pm

    #1935609

  • RE: 2016 Cluster Questions For Always On but also with other services

    No, because it makes no sense to have it like that, it's likely to cause problems when the cluster fails over. Create more virtual machines and separate them 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

    March 29, 2017 at 11:12 am

    #1935541

  • RE: Are the posted questions getting worse?

    SQLRNNR - Wednesday, March 29, 2017 9:28 AM

    Thom A - Wednesday, March 29, 2017 8:31 AM

    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

    March 29, 2017 at 9:31 am

    #1935519

  • RE: Are the posted questions getting worse?

    Thom A - Wednesday, March 29, 2017 8:31 AM

    Too optimistic? 🙂

    Yes.

    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

    March 29, 2017 at 8:42 am

    #1935508

  • RE: Are the posted questions getting worse?

    Thom A - Wednesday, March 29, 2017 8:12 AM

    Concerning that someone who has probably created at least 100 topics on this forum...

    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

    March 29, 2017 at 8:27 am

    #1935505

  • RE: 2016 Cluster Questions For Always On but also with other services

    bobbytables - Wednesday, March 29, 2017 7:57 AM

    Would that be a typical representation of the real world? A cluster with both shared...

    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

    March 29, 2017 at 8:22 am

    #1935503

  • RE: Menaing of the select statement

    Can you post the whole query? Because out of context it doesn't mean all that much (and is missing a bracket)

    Which of the functions don't you understand?

    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

    March 29, 2017 at 8:10 am

    #1935498

  • RE: SQL Server core usage

    richardmgreen1 - Wednesday, March 29, 2017 6:03 AM

    This still doesn't answer the question as to why the instance is only recognising 4...

    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

    March 29, 2017 at 6:05 am

    #1935473

  • RE: SQL Server core usage

    andrew gothard - Wednesday, March 29, 2017 5:06 AM

    If you have low use, over provisioning and many cores your CPU ready time...

    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

    March 29, 2017 at 5:09 am

    #1935460

Viewing 15 posts - 1,606 through 1,620 (of 49,552 total)