Forum Replies Created

Viewing 15 posts - 796 through 810 (of 49,552 total)

  • RE: Execution plan over estimation

    Arsh - Thursday, September 7, 2017 4:16 AM

    Please shed some light on the possibility of the optimizer not being able 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

    September 7, 2017 at 7:19 am

    #1958557

  • RE: To automatically change the value of a column if a particular date time is reached

    In that case, you need a scheduled job running on a regular interval. Use Windows Scheduler since you don't have SQL Agent.

    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 5, 2017 at 1:37 am

    #1958045

  • RE: Update Statistics..

    Jeff Moden - Monday, September 4, 2017 10:34 AM

    Density-vector for what?  I'm thinking that it's likely that there are more than...

    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 4, 2017 at 3:12 pm

    #1958028

  • RE: To automatically change the value of a column if a particular date time is reached

    You want the status set to 2 when what exactly happens?

    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 4, 2017 at 4:10 am

    #1957995

  • RE: Two column join between tables, one column with equal to and other columns with not equal to

    Since there are no filters other than the join, the most efficient way to execute that is probably with two full table scans. Do you really have no further restrictions...

    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 4, 2017 at 1:35 am

    #1957983

  • RE: failover cluster & windows cluster difference

    rajeshn29.dba - Monday, September 4, 2017 1:10 AM


    .fail over cluster & windows cluster difference  

    Do you mean a SQL cluster vs a...

    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 4, 2017 at 1:16 am

    #1957981

  • RE: Are the posted questions getting worse?

    Jeff Moden - Saturday, September 2, 2017 12:03 PM

    GilaMonster - Saturday, September 2, 2017 12:55 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

    September 2, 2017 at 12:30 pm

    #1957935

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor - Friday, September 1, 2017 9:52 AM

    There's too much JS in the editor. Trying to get 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

    September 2, 2017 at 12:55 am

    #1957909

  • RE: Update Statistics..

    Arsh - Friday, September 1, 2017 5:40 AM

    GilaMonster - Thursday, August 31, 2017 1:19 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

    September 1, 2017 at 1:52 pm

    #1957893

  • RE: Create a database from backup when the backup transaction log is damage.

    And if you try the
    CONTINUE_AFTER_ERROR option on the restore?

    Is the source DB intact?

    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 31, 2017 at 11:20 pm

    #1957777

  • RE: Update Statistics..

    Threshold for triggering auto update != sampling rate.
    The threshold is 20%. Jeff's talking about the sample rate.

    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 31, 2017 at 1:19 pm

    #1957727

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor - Wednesday, August 30, 2017 8:58 AM

    GilaMonster - Tuesday, August 29, 2017...

    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 31, 2017 at 7:39 am

    #1957650

  • RE: Update Statistics..

    Arsh - Thursday, August 31, 2017 4:20 AM

    The query plans that I get from the blocking sessions has no .Actual Rows'....

    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 31, 2017 at 4:30 am

    #1957611

  • RE: Anyway to find the row based on the page number

    In this case it's an orphaned text blob.

    The off-row data node  is not referenced

    As such, the row that the text blob belongs to is gone somehow and...

    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 31, 2017 at 3:56 am

    #1957604

  • RE: Update Statistics..

    Look at the slow query. Is there a large difference between estimated and actual row count at the leaf level
    Update the stats. Is the query plan better (better estimates)...

    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 31, 2017 at 2:15 am

    #1957596

Viewing 15 posts - 796 through 810 (of 49,552 total)