Forum Replies Created

Viewing 15 posts - 12,196 through 12,210 (of 49,552 total)

  • RE: Small transaction logs and/or transations logs with no transactions and need to restore

    You need to restore ALL log backups, in sequence.

    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 5, 2013 at 3:46 pm

    #1638762

  • RE: Are the posted questions getting worse?

    Jeff Moden (8/5/2013)

    Do you think Hekaton will provide any additional performance over using something like SSDs?

    Yes, potentially large ones. Because it is not just tables in memory.

    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 5, 2013 at 3:46 pm

    #1638761

  • RE: Are the posted questions getting worse?

    Jeff Moden (8/5/2013)

    Won't Hekaton allow you to use more memory than you should?

    I don't know what the memory management's going to be, there's no info available on it yet.

    Hekaton 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 5, 2013 at 2:29 pm

    #1638737

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (8/5/2013)

    GilaMonster (8/5/2013)

    andrew gothard (8/5/2013)

    ... Remember being able to PIN TABLE ...

    :exclamation: you have no idea how happy I am that vendors do 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

    August 5, 2013 at 12:33 pm

    #1638700

  • RE: Are the posted questions getting worse?

    andrew gothard (8/5/2013)

    ... Remember being able to PIN TABLE ...

    :exclamation: you have no idea how happy I am that vendors do not have access to that

    And clients....

    I remember...

    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 5, 2013 at 8:00 am

    #1638606

  • RE: Mirror Backup Success

    What do you mean by 'mirror backup'?

    If you mean, \BACKUP DATABASE... TO DISK ... MIRROR TO ... then that has nothing whatsoever to do with database mirroring.

    If you do mean...

    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 5, 2013 at 7:57 am

    #1638605

  • RE: Are the posted questions getting worse?

    Jeff Moden (8/4/2013)

    Remember being able to PIN TABLE and then took that wonderful feature away? Now they're bringing a form of it back with Hekaton but with more 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

    August 5, 2013 at 2:14 am

    #1638532

  • RE: Gaps in tlogs

    What do you mean by 'gaps in the tlogs'?

    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 3, 2013 at 2:25 pm

    #1638441

  • RE: Performance of principal db in Mirroring

    No, that would just increase the delay before a mirroring failover.

    To reduce the impact of mirroring, reduce the latency of the hardening of the mirror's log records, that's the line's...

    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 3, 2013 at 3:45 am

    #1638408

  • RE: Performance of principal db in Mirroring

    It can, yes.

    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 3, 2013 at 2:51 am

    #1638404

  • RE: Error message while adding Clustered Index

    Try changing the option SORT_IN_TEMPDB to ON

    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 2, 2013 at 2:15 pm

    #1638344

  • RE: Reg: SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

    No, I'm giving you alternatives to using nolock. Which you use is up to you, all will give you accurate reports (accurate to specific points in time for some) without...

    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 2, 2013 at 12:20 pm

    #1638312

  • RE: File System Failure DB Recovery

    Try from management studio. If that fails, the object's lost.

    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 2, 2013 at 12:09 pm

    #1638304

  • RE: Reg: SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

    kevin_nikolai (8/2/2013)

    Normally you would use READ UNCOMMITTED in stored procedures of SQL Reports if they point

    to Application server database - NOT to impact performance of the Application you would...

    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 2, 2013 at 12:00 pm

    #1638298

  • RE: File System Failure DB Recovery

    Script all objects, export all data, recreate the database, fix up your backup strategy.

    The history table may well fail when exporting.

    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 2, 2013 at 11:47 am

    #1638295

Viewing 15 posts - 12,196 through 12,210 (of 49,552 total)