Forum Replies Created

Viewing 15 posts - 331 through 345 (of 49,552 total)

  • RE: Materialized views

    I'd start with the MS documentation, it's pretty good. They're usually called 'indexed views', so that search term should get you a lot of reading.

    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

    February 19, 2018 at 4:01 am

    #1980244

  • RE: SELECT TOP X vs Offset Fetch? Want to limit query results but not force a sort and scan?

    Top and Rowcount both work without sorts, however when you use them such, there's no guarantee as to which rows you get, and the rows you get can be different...

    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

    February 19, 2018 at 4:00 am

    #1980243

  • RE: Decimal place in SQL

    IQ1 - Thursday, February 15, 2018 3:28 PM

    yes actually my bad the rounding logic is to be applied to all cases but...

    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

    February 16, 2018 at 4:52 am

    #1980030

  • RE: Backup of DB while it is configured with log shipping

    Just don't take any log backups. Those must only be done by the log shipping process. (you can and should copy those log backups elsewhere for safety, once they've been...

    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

    February 15, 2018 at 1:07 pm

    #1979988

  • RE: Backup of DB while it is configured with log shipping

    Full backups will not affect log shipping (neither will differential backups) as they do not break or otherwise interfere with the log chain

    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

    February 15, 2018 at 12:26 pm

    #1979977

  • RE: Are the posted questions getting worse?

    Jeff Moden - Wednesday, February 14, 2018 6:11 AM

    They might not actually have a programming job but have been asked 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

    February 14, 2018 at 6:21 am

    #1979714

  • RE: Please delete this post

    Eirikur Eiriksson - Wednesday, February 14, 2018 2:17 AM

    GilaMonster - Wednesday, February 14, 2018 1:35 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

    February 14, 2018 at 4:26 am

    #1979702

  • RE: Slow Execution time in SQL Stored Procedure?

    DesNorton - Wednesday, February 14, 2018 3:59 AM

    You have a classic Catch_all type query.
    GilaMonster as a great blog post about...

    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

    February 14, 2018 at 4:24 am

    #1979701

  • RE: How to return PrimaryKey, Inserted datetime

    If you're using the procedure in an INSERT INTO ... EXEC... Then you need to be very careful. You can't add more resultsets to the procedure, as they're break 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

    February 14, 2018 at 1:39 am

    #1979689

  • RE: Please delete this post

    ffarouqi - Wednesday, February 14, 2018 12:29 AM

    Wow...really I never thought about it. Okay so actions speak louder than words so...

    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

    February 14, 2018 at 1:35 am

    #1979688

  • RE: Performance improvement following a disable indexes, shrink, enable indexes - but why?

    mig28mx - Tuesday, February 13, 2018 1:42 PM

    2.- Wrong cardinallity on execution plans. This is solved by updating / creatining statistics. As...

    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

    February 14, 2018 at 1:06 am

    #1979687

  • RE: Please delete this post

    It loops over one table and inserts the values, one by one, into another table. That's not hard to replace with a single insert.
    You get better at programming...

    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

    February 13, 2018 at 3:30 pm

    #1979663

  • RE: Please delete this post

    You could start by getting rid of the unnecessary cursor.

    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

    February 13, 2018 at 2:25 pm

    #1979654

  • RE: Huge table.and poor performance.

    Can you post the queries that are slow, along with their actual execution plans? The ones against the full table that take ~5 min.

    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

    February 13, 2018 at 7:07 am

    #1979585

  • RE: Index operation fails with below

    salamlemon - Tuesday, February 13, 2018 4:02 AM

     How shrink file/database will affect this operation?

    From the error message:

    The concurrent operation could 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

    February 13, 2018 at 5:06 am

    #1979574

Viewing 15 posts - 331 through 345 (of 49,552 total)