Forum Replies Created

Viewing 15 posts - 1,216 through 1,230 (of 49,552 total)

  • RE: How much memory does SQL server Really need?

    WhiteLotus - Monday, July 3, 2017 1:11 AM

    Hi All,

     

    How do we know how...

    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

    July 3, 2017 at 1:41 am

    #1949103

  • RE: DBCC CHECKDB ( , REPAIR_ALLOW_DATA_LOSS) is not fixing Db

    Without a clean backup, that's not fixable. checkDB is not guaranteed to fix all problems, that's what a good backup strategy is there for (one of the things)
    Restore from...

    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

    July 1, 2017 at 4:06 pm

    #1949060

  • RE: SQL Server 2000 Installation Problem

    Please post new questions in a new thread. Thanks

    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

    July 1, 2017 at 1:59 pm

    #1949058

  • RE: Are the posted questions getting worse?

    Sean Lange - Friday, June 30, 2017 8:59 AM

    How did the water cooler get derailed into a technical solution? Are the hippos...

    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

    June 30, 2017 at 9:12 am

    #1948959

  • RE: SQL server error “No catalog entry found for partition ID xxxxx in database 12…”

    Run the following in the database with the problem, post the results

    DBCC CheckDB WITH NO_INFOMSGS

    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

    June 30, 2017 at 3:34 am

    #1948890

  • RE: log_reuse_wait_desc column says LOG_BACKUP - what should i do ?

    Please post new questions in a new thread. Thanks

    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

    June 29, 2017 at 12:56 pm

    #1948812

  • RE: More problems with SQL 2014's new Cardinality Estimator

    julian.fletcher - Thursday, June 29, 2017 9:30 AM

    (A few years ago we foolishly thought that it would be better to do...

    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

    June 29, 2017 at 9:40 am

    #1948773

  • RE: Creating Identity column reorders table

    GrassHopper - Thursday, June 29, 2017 9:20 AM

    I'm not defining the order.  It's the natural order that the data is in.

    There's...

    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

    June 29, 2017 at 9:31 am

    #1948769

  • RE: More problems with SQL 2014's new Cardinality Estimator

    ChrisM@Work - Thursday, June 29, 2017 8:43 AM

    Both of those execution plans indicate that SQL Server baulked at the task of generating...

    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

    June 29, 2017 at 9:07 am

    #1948764

  • RE: More problems with SQL 2014's new Cardinality Estimator

    It's the elevated row estimations that will likely be the cause. The spools show up when the optimiser thinks it's better to cache intermediate results and read from the spool,...

    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

    June 29, 2017 at 4:42 am

    #1948696

  • RE: More problems with SQL 2014's new Cardinality Estimator

    julian.fletcher - Thursday, June 29, 2017 3:27 AM

    GilaMonster - Wednesday, June 28, 2017 12:18 PM

    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

    June 29, 2017 at 4:10 am

    #1948692

  • RE: Order of Data and Cursor Fetch Next Order

    tinausa - Wednesday, June 28, 2017 2:47 PM

    Thanks for confirming what I was thinking. Then is there a way that I can...

    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

    June 28, 2017 at 2:52 pm

    #1948649

  • RE: More problems with SQL 2014's new Cardinality Estimator

    OPTION(RECOMPILE)

    On SQL 2016:

    What  lead me to try that was the estimated rows on the insert. 350 000 rows, which would probably...

    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

    June 28, 2017 at 12:18 pm

    #1948606

  • RE: More problems with SQL 2014's new Cardinality Estimator

    julian.fletcher - Wednesday, June 28, 2017 10:17 AM

    The execution plan (if you have enough time to wait for one)...

    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

    June 28, 2017 at 11:57 am

    #1948601

  • RE: More problems with SQL 2014's new Cardinality Estimator

    It runs on my 2016 instance in 19 seconds, and I don't have a 2014 instance around. Should I see if I can fix it on 2016?

    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

    June 28, 2017 at 11:52 am

    #1948599

Viewing 15 posts - 1,216 through 1,230 (of 49,552 total)