Forum Replies Created

Viewing 15 posts - 28,936 through 28,950 (of 49,552 total)

  • RE: database mirroring over 10 Mbps

    From Books Online (emphasis mine):

    Database mirroring involves redoing every insert, update, and delete operation that occurs on the principal database onto the mirror database as quickly as possible. Redoing 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

    December 10, 2010 at 9:01 am

    #1261091

  • RE: Shrinking Databases

    pjdiller (12/10/2010)

    I am not in a position to disagree. But I am confused by the behavior in SSMS. In the GUI, when I choose to shrink a file,...

    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

    December 10, 2010 at 8:55 am

    #1261086

  • RE: Error Msg 824,servirty 24,state 2

    That's not an integrity job as far as I can see, those are index rebuilds, and there's nothing other than progress messages in what you posted.

    Check the maint plan history...

    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

    December 10, 2010 at 7:53 am

    #1261050

  • RE: Shrinking Databases

    RML51 (12/10/2010)

    Not to mention the time saved to backup and restore some of those environments.

    Shrinking is not going to help backup speed or size. Empty extents are not backed up....

    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

    December 10, 2010 at 7:40 am

    #1261046

  • RE: Error Msg 824,servirty 24,state 2

    Check that the integrity job has been running and included that database. If the integrity job (which just runs CheckDB) had run on that DB after the corruption occurred, it...

    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

    December 10, 2010 at 7:18 am

    #1261034

  • RE: Shrinking Databases

    It depends? 😀

    I think the answers will differ from app to app, DB to DB. Suspect that there won't be a universal truth showing up any time soon. Even 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

    December 10, 2010 at 6:57 am

    #1261020

  • RE: Shrinking Databases

    GSquared (12/10/2010)

    I'll add to the question: Should autoshrink be removed, and then put back in when SSDs become the standard and hard-drive seek time is no longer a problem 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

    December 10, 2010 at 6:44 am

    #1261011

  • RE: Shrinking Databases

    pjdiller (12/10/2010)

    Also, what about truncate only?

    It's only valid when shrinking the data file. If you shrink the log and specify that option, it's ignored. It's the same as doing just...

    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

    December 10, 2010 at 6:41 am

    #1261010

  • RE: Shrinking Databases

    jims-723592 (12/10/2010)

    Yes, turning on the "Truncate log on Checkpoint" helps (Script does that too), but the T-Log is still used.

    Trying not to be too picky, but... Unless you're using...

    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

    December 10, 2010 at 6:02 am

    #1260992

  • RE: Query speed is slow

    Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

    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

    December 10, 2010 at 4:24 am

    #1260971

  • RE: Shrinking Databases

    bas de zwart (12/10/2010)

    GilaMonster (12/10/2010)

    bas de zwart (12/10/2010)

    Now I could leave the DB running the rest of the month with 65% free space but that wouldn't be very effective 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

    December 10, 2010 at 4:20 am

    #1260970

  • RE: Error Msg 824,servirty 24,state 2

    Your database is corrupt, it's an irreparable corruption, you need to restore from the last good backup.

    Take a look at this article. http://www.sqlservercentral.com/articles/65804/

    The corruption is likely to be a fault...

    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

    December 10, 2010 at 4:17 am

    #1260968

  • RE: Shrinking Databases

    bas de zwart (12/10/2010)

    Now I could leave the DB running the rest of the month with 65% free space but that wouldn't be very effective in terms of fragmentation 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

    December 10, 2010 at 4:10 am

    #1260966

  • RE: Shrinking Databases

    Should it be removed? No.

    There are valid uses for it. Two weeks ago I sat running shrink against every database on a server (disclaimer: it was a dev server). 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

    December 10, 2010 at 1:52 am

    #1260916

  • RE: import data from excel file to sql server database

    Please don't cross post. It just wastes peoples time and fragments replies.

    No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1032839-392-1.aspx

    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

    December 10, 2010 at 1:01 am

    #1260907

Viewing 15 posts - 28,936 through 28,950 (of 49,552 total)