Forum Replies Created

Viewing 15 posts - 2,371 through 2,385 (of 49,552 total)

  • RE: Indexing strategy

    river1 (9/16/2016)

    In terms of index strategy, should I create one index for mch.market_code and another for mch.audit_procedure_result_id or it is better to have a index that is composed by...

    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

    September 17, 2016 at 4:08 am

    #1901499

  • RE: PLE

    What does the PLE look like over a day or more?

    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

    September 16, 2016 at 3:14 am

    #1901297

  • RE: Can someone try this?

    ken.trock (9/15/2016)

    This should return an error. For me it simply returns no rows. If you look closely I fat fingered the creation of dbo.EH_NativeWorker_Dups. Maybe the compiler/parser got confused because...

    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

    September 16, 2016 at 2:01 am

    #1901290

  • RE: Index guidance needed

    MickyD (9/15/2016)

    I have been given a selection of queries from the users.

    Good start

    What's the most common predicate used against that table?

    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

    September 16, 2016 at 1:54 am

    #1901288

  • RE: Index guidance needed

    What's the table frequently filtered by?

    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

    September 15, 2016 at 3:39 pm

    #1901236

  • RE: Are the posted questions getting worse?

    I submitted an abstract, but it was turned down, so no (and frankly I'm just about travelled-out this year)

    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

    September 15, 2016 at 3:36 pm

    #1901234

  • RE: Cost Threshold for Parallelism not being honored?

    You're welcome.

    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

    September 15, 2016 at 1:26 pm

    #1901208

  • RE: Cost Threshold for Parallelism not being honored?

    Yes, it's the cost of the serial plan that's subject to that limit. If, as the optimiser was generating the plan, the serial plan it considered had a cost of...

    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

    September 15, 2016 at 12:38 pm

    #1901199

  • RE: shutting down sql instance

    Rather run the patch and let it manage the instance for you. Patches often contain T-SQL that has to be run in addition to the binaries changes.

    If you absolutely insist...

    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

    September 15, 2016 at 12:33 pm

    #1901196

  • RE: Data Science Education

    xsevensinzx (9/15/2016)

    Udemy is also a good resource. You get professionals who work in related fields trying to make extra cash who teach real-world examples there in various degrees of levels.

    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

    September 15, 2016 at 7:46 am

    #1901113

  • RE: Indexed, Foreign Keys and Primary Keys

    exec sp_rename ???

    Dropping all the indexes and recreating them will take ages, and do massive IOs and bloat the transaction log.

    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

    September 15, 2016 at 6:22 am

    #1901079

  • RE: New 2008 R2 Installation Errors

    SQL 2008 R2 database engine? (run SELECT @@Version please)

    What version of Management Studio? (Help -> About, attach a screenshot please)

    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

    September 14, 2016 at 2:23 pm

    #1900960

  • RE: Edition and upgrade to sql 2008r2

    If that's the only purpose, and it's for 6 months, can you just do the edition upgrade and leave the DB server on 2008?

    You won't be gaining much 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

    September 14, 2016 at 2:12 pm

    #1900958

  • RE: Edition and upgrade to sql 2008r2

    One thing first, why upgrade to a version that's completely out of support and has barely any changes or improvements over what you're using? If you're upgrading, why not *upgrade*?

    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

    September 14, 2016 at 1:12 pm

    #1900943

  • RE: Logging Events

    SQLAudit should be able to do that.

    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

    September 14, 2016 at 12:08 pm

    #1900925

Viewing 15 posts - 2,371 through 2,385 (of 49,552 total)