Forum Replies Created

Viewing 15 posts - 1,786 through 1,800 (of 49,552 total)

  • RE: Copy only Log Backup

    No, there isn't.

    A copy-only log backup doesn't truncate the transaction log, so the last of the copy-only log backups contained all the log records since the last non-copy...

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

    #1928288

  • RE: Query never completes with CXPACKET waits

    What's the compatibility level of the database?

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

    #1928193

  • RE: Flipping between SIMPLE and FULL recovery mode

    robinrai3 - Monday, February 13, 2017 7:42 AM

    2)  I agree the 150GB  is used for the processing, so really before the log...

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

    #1928173

  • RE: Are the posted questions getting worse?

    Grant Fritchey - Monday, February 13, 2017 7:48 AM

    Disco?
    But I survived the seventies. Why on earth would I want to go back?

    I...

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

    #1928170

  • RE: Flipping between SIMPLE and FULL recovery mode

    robinrai3 - Monday, February 13, 2017 6:59 AM

    1) What does the flip flopping achieve ? 

    It breaks the log chain, leaves you...

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

    #1928098

  • RE: SQL 2000 to 2014 Restore

    Beaux_Zeaux - Monday, February 13, 2017 6:38 AM

    Hello, I took over a LOB app that has been running on 2003 server w/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

    February 13, 2017 at 6:44 am

    #1928091

  • RE: Are the posted questions getting worse?

    Grant Fritchey - Monday, February 13, 2017 6:00 AM

    WHOOP! Two sessions this year, plus we'll be doing one for SQL Clone. I'm...

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

    #1928083

  • RE: Login

    The login you're using doesn't exist, or the password is wrong, or you're trying to connect to a DB that the login doesn't have access to, or (about 12 other...

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

    #1928038

  • RE: Is having a lookup table that is for multiple entities a common practice?

    Doctor Who 2 - Saturday, February 11, 2017 6:54 PM

     How can I simulate load onto this table, such as might happen in...

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

    #1928012

  • RE: Massive disk vs. multiple disks?

    goher2000 - Friday, February 10, 2017 6:32 PM

    does SDD make it start doing parallel reads/writes without multi-pal files?

    SQL can always do reads...

    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 12, 2017 at 5:38 am

    #1927988

  • RE: Query Performance Tuning – A Methodical Approach

    Aaron N. Cutshall - Friday, February 10, 2017 3:16 PM

    Thanks Gail.  Some time ago I began the habit of consolidating things...

    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 12, 2017 at 5:35 am

    #1927987

  • RE: Query never completes with CXPACKET waits

    Alex Chamchourine - Friday, February 10, 2017 4:15 PM

     Setting MAXDOP 1 should significantly decrease wait time on CXPACKET.

    No, please don't recommend crippling...

    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 12, 2017 at 5:25 am

    #1927986

  • RE: Query Performance Tuning – A Methodical Approach

    Aaron N. Cutshall - Friday, February 10, 2017 1:28 PM

    Since Steve was kind enough to re-post this in today's daily email, I...

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

    #1927889

  • RE: Forum User Post Levels

    Luis Cazares - Friday, February 10, 2017 7:07 AM

    With the huge amount of posts, Gail can increase points without any effort now.

    Sweet....

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

    #1927788

  • RE: Forum User Post Levels

    andrew gothard - Friday, February 10, 2017 4:01 AM

    Actually, Gail has a point.  I apparently have 34 points from the past 30...

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

    #1927715

Viewing 15 posts - 1,786 through 1,800 (of 49,552 total)