Forum Replies Created

Viewing 15 posts - 436 through 450 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    ThomasRushton - Tuesday, January 23, 2018 8:02 AM

    This makes me wonder what you're looking at, because I saw very little spam when...

    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

    January 23, 2018 at 10:21 am

    #1976952

  • RE: Efficient way of mirroring tables from one sql instance to another

    ffarouqi - Tuesday, January 23, 2018 9:39 AM

    GilaMonster - Monday, January 22, 2018 3:38 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

    January 23, 2018 at 10:17 am

    #1976951

  • RE: DBCC CheckDB produced errors

    That's a table that's corrupt.

    In this case, I suspect that a repair with allow_data_loss will work and will not lose data (there are no row that are unreadable,...

    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

    January 23, 2018 at 10:12 am

    #1976949

  • RE: Are the posted questions getting worse?

    The first 8 pages this morning had 3 legit posts on them, in total

    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

    January 23, 2018 at 7:32 am

    #1976898

  • RE: Minimum memory per query

    Unless you have a really good reason to be fiddling with that config setting, rather leave it alone.

    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

    January 23, 2018 at 3:23 am

    #1976868

  • RE: Disaster Recovery

    No where near enough information. To come up with a DR plan, you need to identify the SLAs and requirements. How much data loss is tolerable? How much downtime 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

    January 23, 2018 at 3:01 am

    #1976866

  • RE: In-Memory tables candidate

    89netanel - Sunday, January 21, 2018 3:24 AM

    and how can i decide which one of the candidate tables will be schema or data and schema? 

    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

    January 22, 2018 at 3:39 pm

    #1976835

  • RE: Efficient way of mirroring tables from one sql instance to another

    I'd use transactional replication and schedule the distribution agent to run every 4 hours. That way you snapshot once (when you set it up), not every 4 hours.

    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

    January 22, 2018 at 3:38 pm

    #1976834

  • RE: Checkpoint Process - Dirty Pages - Memory

    SQLSACT - Thursday, January 18, 2018 9:19 AM

    If so then why is the checkpoint pages/sec counter considered important when assessing memory pressure...

    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

    January 22, 2018 at 3:37 pm

    #1976833

  • RE: Question regarding Save Transaction and duplicates

    Sridhar-137443 - Monday, January 22, 2018 2:52 PM

     Is that not right?

    No, it's not.
    Locks are taken as needed, and how long they're held...

    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

    January 22, 2018 at 3:33 pm

    #1976832

  • RE: Are the posted questions getting worse?

    DesNorton - Monday, January 22, 2018 2:03 AM

    GilaMonster - Monday, January 22, 2018 12:58 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

    January 22, 2018 at 2:35 pm

    #1976826

  • RE: Question regarding Save Transaction and duplicates

    Sridhar-137443 - Monday, January 22, 2018 6:57 AM

    Thank you for the response. You are correct that it is doing read to get...

    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

    January 22, 2018 at 2:31 pm

    #1976824

  • RE: Database Size

    https://connect.microsoft.com/SQLServer/feedback/details/377223/sys-master-files-does-not-show-accurate-size-information

    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

    January 22, 2018 at 6:07 am

    #1976708

  • RE: Question regarding Save Transaction and duplicates

    No, the transaction name is not causing the duplicates.

    If SQL says you have duplicate rows, then you have duplicate rows. Probably due to using the read-then-insert pattern 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

    January 22, 2018 at 1:14 am

    #1976677

  • RE: Database Size

    Sys.master files is the size at last start of SQL Server iirc, so you probably have a very low default size for TemoDB and it has to grow afterwards (which...

    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

    January 22, 2018 at 1:08 am

    #1976675

Viewing 15 posts - 436 through 450 (of 49,552 total)