Forum Replies Created

Viewing 15 posts - 931 through 945 (of 49,552 total)

  • RE: SQL trigger not firing after moving to new server

    Triggers always fire. There's no setting (other than disabling it) to stop a trigger from firing.
    Try setting up an extended event session to see exactly what's happening and what,...

    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 13, 2017 at 5:15 pm

    #1955098

  • RE: Included Column Vs Covering Index

    SQL-DBA-01 - Sunday, August 13, 2017 7:38 AM

     So currently I have two indexes :

    1. One column and other as included
    2. Two columns...

    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 13, 2017 at 5:13 pm

    #1955097

  • RE: Wading through a profiler trace trying to connect the dots and find the source or parent of one particular statement

    That looks like an index rebuild, and the maintenance plans do report Management Studio as their application.
    Check maintenance plans. I bet you have an index maintenance job scheduled around...

    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 13, 2017 at 6:05 am

    #1955085

  • RE: 'Actual Rows' missing in query plans...

    Arsh - Sunday, August 13, 2017 4:43 AM

    John Mitchell-245523 - Friday, August 11, 2017 9:07 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

    August 13, 2017 at 6:00 am

    #1955084

  • RE: Simple Recovery Model and Checkpoint

    coolchaitu - Friday, August 11, 2017 7:50 PM

    "Writes all dirty pages for the current database to disk". 
    Does this mean checkpoint 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

    August 12, 2017 at 3:59 am

    #1955053

  • RE: Error on Backup

    Is the TDE certificate on that server?

    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 11, 2017 at 3:34 pm

    #1955047

  • RE: Are the posted questions getting worse?

    "I don't understand."
    "What don't you understand?"
    "I don't understand."
    "I don't understand."
    "What don't you understand?"
    "I don't understand."

    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 11, 2017 at 3:23 pm

    #1955046

  • RE: Simple Recovery Model and Checkpoint

    Ok, if you don't want to help me to help you understand.

    Checkpoint marks VLFs, virtual log files, as reusable, if and only if they are not needed 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 11, 2017 at 3:23 pm

    #1955045

  • RE: Does execution plan cache caches the usage of functions?

    Multi-statement and scalar functions, yes. In-line table, no, as they're more like views.

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

    #1955021

  • RE: Simple Recovery Model and Checkpoint

    I answered that.
    Before I waste time answering it again, please specify what, exactly, in my answer you did not understand?

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

    #1955020

  • RE: Moving the tempdb to another drive.

    newdba2017 - Friday, August 11, 2017 7:37 AM

    Restarting the service is something we can't do now. G drive has 22GB of free...

    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 11, 2017 at 8:17 am

    #1954986

  • RE: Statistics' update at reaching the threshold

    Internal counters. Exposed in the DMV sys.dm_db_stats_properties

    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 11, 2017 at 8:17 am

    #1954984

  • RE: Difference in row-size between what was expected and what was — can anyone explain please?

    .
    I'll wait for the OP to post the results from the actual system (as I'm not interested in generics, I could have run it locally if I was)

    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 11, 2017 at 6:49 am

    #1954958

  • RE: Recovery Model-Tlog Backup

    I answered that in your other thread.

    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 11, 2017 at 3:30 am

    #1954934

  • RE: Simple Recovery Model and Checkpoint

    What, specifically, did you not understand in that statement?

    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 11, 2017 at 3:30 am

    #1954933

Viewing 15 posts - 931 through 945 (of 49,552 total)