Forum Replies Created

Viewing 15 posts - 1,366 through 1,380 (of 49,552 total)

  • RE: Need replacement t-sql to obtain SHOWCONTIG values

    John Mitchell-245523 - Tuesday, May 30, 2017 8:11 AM

    I think the DMV you're looking for is called something like sys.dm_index_physical_stats.  There'll 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

    May 30, 2017 at 8:20 am

    #1944577

  • RE: High Fragmentation - No Indices

    notredamon - Tuesday, May 30, 2017 7:06 AM

    It looks like I can create an index, then drop the table to accomplish 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

    May 30, 2017 at 7:24 am

    #1944573

  • RE: High Fragmentation - No Indices

    Ignore it.

    Fragmentation is highly unlikely to be the cause of your performance problems.
    Performance problems mostly come down to poor indexing (as in incorrect or no indexes) 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

    May 30, 2017 at 6:44 am

    #1944568

  • RE: Performance issue due to index

    nadersam - Tuesday, May 30, 2017 5:04 AM

    But could you tell me please how could a bad plan go into cache

    Nearly...

    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

    May 30, 2017 at 5:42 am

    #1944560

  • RE: Performance issue due to index

    Most likely nothing to do with the indexes themselves.

    Rebuilding indexes updates statistics and updating statistics invalidates all execution plans that use those stats. If a couple bad plans...

    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

    May 30, 2017 at 4:58 am

    #1944552

  • RE: Are the posted questions getting worse?

    ChrisM@Work - Tuesday, May 30, 2017 1:57 AM

    You can, but you have to pay a shoulder and a leg for it 🙂

    Your...

    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

    May 30, 2017 at 3:18 am

    #1944536

  • RE: Adding conditional logic, help wanted

    A case statement returns expressions (constants, functions or variables), not select statements

    If you want to not query the table at all if it's empty, then you need an...

    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

    May 30, 2017 at 3:16 am

    #1944534

  • RE: Learning new programing language (Python or R)?

    And Python will be usable in the next version of SQL Server (2017)

    I decided to start with R, and then pick up Python later

    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

    May 30, 2017 at 1:20 am

    #1944523

  • RE: Are the posted questions getting worse?

    Eirikur Eiriksson - Monday, May 29, 2017 8:52 AM

    Steve Jones - SSC Editor - Monday, May 29,...

    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

    May 29, 2017 at 1:19 pm

    #1944508

  • RE: Are the posted questions getting worse?

    Oh, and Eirikur...

    Brown lamb shanks in a pan, remove from pan
    Soften some onion and garlic
    Add a good amount of curry powder (I use pre-made, as we...

    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

    May 29, 2017 at 1:18 pm

    #1944507

  • RE: Are the posted questions getting worse?

    DesNorton - Monday, May 29, 2017 8:02 AM

    GilaMonster - Monday, May 29, 2017 7:48 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

    May 29, 2017 at 8:05 am

    #1944493

  • RE: Execution plan

    krishnabudampati - Monday, May 29, 2017 5:36 AM

    How to get  execution plan of a SQL which has executed two days back?

    Unless 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

    May 29, 2017 at 7:53 am

    #1944491

  • RE: Are the posted questions getting worse?

    Something tells me that this is going to take a while...
    https://www.sqlservercentral.com/Forums/1878491/SQL-server-2014-is-very-slow

    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

    May 29, 2017 at 7:48 am

    #1944489

  • RE: SQL server 2014 is very slow

    That is not what I asked for. Please read what I'm asking.

    Filter out the meaningless waits. There are plenty of references online as to which ones are not...

    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

    May 29, 2017 at 7:46 am

    #1944488

  • RE: need help with Invoice summary query

    Eirikur Eiriksson - Monday, May 29, 2017 4:01 AM

    GilaMonster - Monday, May 29, 2017 12:15 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

    May 29, 2017 at 4:05 am

    #1944476

Viewing 15 posts - 1,366 through 1,380 (of 49,552 total)