Forum Replies Created

Viewing 15 posts - 2,611 through 2,625 (of 49,552 total)

  • RE: Is SQL Server Replication going away?

    pooyan_pdm (8/19/2016)

    This is a "deprecated" feature, as per Thomas's post it not possible to replicate between 2016 and 2008 R2 and is not completely supported between all different versions,...

    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

    August 19, 2016 at 1:45 pm

    #1896445

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (8/19/2016)

    GilaMonster (8/19/2016)

    !!!!

    https://www.pluralsight.com/courses/identifying-fixing-performance-issues-caused-parameter-sniffing

    And massive amount of work it was too. Recording's the easy part. Scripting is the most time consuming, editing probably the most difficult.

    Congrats! Nice accomplishment.

    Is this 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

    August 19, 2016 at 1:38 pm

    #1896441

  • RE: Are the posted questions getting worse?

    !!!!

    https://www.pluralsight.com/courses/identifying-fixing-performance-issues-caused-parameter-sniffing

    And massive amount of work it was too. Recording's the easy part. Scripting is the most time consuming, editing probably the most difficult.

    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

    August 19, 2016 at 10:39 am

    #1896395

  • RE: SQL Server Upgrade from 2008 Standard to 2014 or 2016

    I'd go straight for 16. It's a good version, lots of new features that you may find useful (temporal tables, stretch DB, always encrypted, dynamic data masking, etc), and it'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

    August 19, 2016 at 5:28 am

    #1896325

  • RE: Concurrency Woes.

    Consider tossing the sequence table away and using SQL's built-in sequence objects (in the product since 2012 iirc) once you get up to SQL 2014. They have the same mechanics...

    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

    August 19, 2016 at 5:17 am

    #1896322

  • RE: Update statistics after Index Rebuild ?

    I don't know why that warning sometimes appears. It might be the QO needs multi-column stats, which will not be manually created. I need to research that sometime.

    I'd say nuke...

    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

    August 19, 2016 at 5:05 am

    #1896320

  • RE: Is SQL Server Replication going away?

    pooyan_pdm (8/18/2016)

    Replication is a deprecated feature and Microsoft is not adding any thing new to it

    Citation needed.

    MSDN does not list replication as a deprecated feature. Please reference your source 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

    August 19, 2016 at 5:00 am

    #1896317

  • RE: Can we shrink datafile of a database which is configured with log shipping

    info.sqldbamail (8/19/2016)

    If we do shrinking do i need to stop log shipping jobs or will it break log shipping configuration?

    No and no.

    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

    August 19, 2016 at 4:58 am

    #1896316

  • RE: Update statistics after Index Rebuild ?

    BLOB_EATER (8/18/2016)

    Grant Fritchey (8/18/2016)

    Jeff Moden (8/18/2016)

    It also names the stats in a fashion almost identical to how SQL Server does it

    BWA-HA-HA!

    I was just having a conversation about statistics in...

    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

    August 18, 2016 at 2:03 pm

    #1896247

  • RE: Update statistics after Index Rebuild ?

    Jeff Moden (8/18/2016)

    I'm toying with the idea of just dropping all the stats that have the minor nuance in the name that I spoke of and letting the system sort...

    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

    August 18, 2016 at 2:00 pm

    #1896246

  • RE: Update statistics after Index Rebuild ?

    Yup, but those column stats are usually very important (if they weren't necessary the optimiser wouldn't have had them created), and there's still the index stats on indexes that you're...

    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

    August 17, 2016 at 4:10 pm

    #1896057

  • RE: Update statistics after Index Rebuild ?

    kramaswamy (8/17/2016)

    Earlier in this thread, Grant suggested updating the statistics after an index rebuild was not the right approach, since the statistics are already updated by the rebuilding of 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

    August 17, 2016 at 3:29 pm

    #1896053

  • RE: Database Corruption - Possible False Positive

    Since you're on 2014, open a case with product support.

    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

    August 17, 2016 at 2:59 pm

    #1896047

  • RE: Update statistics after Index Rebuild ?

    I wouldn't do it that way round.

    Index rebuild first, if necessary, afterwards update any stats that need updating.

    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

    August 17, 2016 at 2:53 pm

    #1896044

  • RE: Table Partition for date range>90 days

    A strongly recommend against doing the above. It'll work, but not well. The guidelines for adding partitions is to ensure that no data needs to move from one partition 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

    August 17, 2016 at 2:49 pm

    #1896041

Viewing 15 posts - 2,611 through 2,625 (of 49,552 total)