Forum Replies Created

Viewing 15 posts - 1,336 through 1,350 (of 49,552 total)

  • RE: Need Help Getting Max Date

    Replace the
    FROM
        #TestData td
    with the real  tables.

    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

    June 5, 2017 at 6:03 am

    #1945376

  • RE: Page life expectancy for xxx is currently 356.

    As a single point of data, there's no indication that there's an issue that needs fixing.

    Look at trends over time, not single data points.

    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

    June 5, 2017 at 6:00 am

    #1945374

  • RE: Has Anyone Used SAN Snapshot To Restore Database To A Developer Server? Permissions Issue?

    Continued from https://www.sqlservercentral.com/Forums/1879185/Attach-Database-Question

    Did you speak to the SAN admin? What did they say?

    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

    June 5, 2017 at 2:32 am

    #1945347

  • RE: SQL Server 2016 Inplace Upgrade

    I strongly do not recommend an in-place upgrade. If something goes wrong with the upgrade, you may be looking at reinstalling the *server* to fix the problems.

    If 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

    June 4, 2017 at 9:51 am

    #1945306

  • RE: Index fragmentation

    VastSQL - Sunday, June 4, 2017 5:15 AM

    GilaMonster - Sunday, June 4, 2017 4: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

    June 4, 2017 at 9:47 am

    #1945305

  • RE: Index fragmentation

    VastSQL - Sunday, June 4, 2017 4:43 AM

     Rebuild and reorg ignores tables with less than 1000 Pages, that might be 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

    June 4, 2017 at 4:48 am

    #1945299

  • RE: Find user connections to SQL server tables

    Ed Wagner - Saturday, June 3, 2017 6:00 PM

    For connections to SQL, the following query will give you a table of current...

    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

    June 4, 2017 at 2:35 am

    #1945297

  • RE: Get Last Name, First name and Middle Name from Full Name

    Please note: 8 year old 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

    June 4, 2017 at 2:34 am

    #1945296

  • RE: user unable to see all running queries

    GilaMonster - Friday, June 2, 2017 12:39 AM

    To see server-level information like that, you need, iirc, VIEW SERVER STATE permissions.

    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

    June 4, 2017 at 1:43 am

    #1945294

  • RE: Attach Database Question

    Speak to the SAN admin?

    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

    June 2, 2017 at 11:38 am

    #1945182

  • RE: script to remove multiple tempdb files and just have 1 datafile and 1 log file

    sqlguy80 - Thursday, June 1, 2017 3:59 PM

    Some server I inherited had multiple tempdb data files and 1 log file.

    He prob created...

    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

    June 2, 2017 at 11:36 am

    #1945181

  • RE: SQL Question with SELECT STATEMENT

    Here you go.
    https://www.simple-talk.com/sql/t-sql-programming/concatenating-row-values-in-transact-sql/

    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

    June 2, 2017 at 11:35 am

    #1945180

  • RE: Are the posted questions getting worse?

    DesNorton - Friday, June 2, 2017 8:46 AM

    HOLY COW.  In my world, a cold winters day is 12-14C (53-57F).  And then...

    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

    June 2, 2017 at 11:32 am

    #1945179

  • RE: Are the posted questions getting worse?

    bmg002 - Thursday, June 1, 2017 1:52 PM

    GilaMonster - Thursday, June 1, 2017 1:45 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

    June 2, 2017 at 3:18 am

    #1945047

  • RE: Plan Guides (Again)

    Why nolock? Are you aware of the negative impact in terms of accuracy?

    Have you considered the READ COMMITTED SNAPSHOT database option? That gets you read queries that don't...

    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

    June 2, 2017 at 3:15 am

    #1945045

Viewing 15 posts - 1,336 through 1,350 (of 49,552 total)