Forum Replies Created

Viewing 15 posts - 36,001 through 36,015 (of 49,552 total)

  • RE: Does SQL2005/2008 recreate missing transaction log file(s) in case of data corruption?

    MANU-296622 (11/5/2009)

    In 2005 also it doesnt allow you to attach database with more than one log file using sp_attach_single_file_db.

    Which is deprecated anyway. Use CREATE DATABASE ... FOR ATTACH

    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

    November 6, 2009 at 12:38 am

    #1075736

  • RE: Introduction to Indexes

    I do, I think (wrote them a week ago and am currently brain-dead tired after PASS). Probably not in the detail hyou want. Any specific questions, ask them in 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

    November 5, 2009 at 8:10 pm

    #1075685

  • RE: Unable to reclaim transaction log space after removing replication

    Try this.

    Create a new transactional publication. Run sp_repldone. Drop the publication

    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

    November 5, 2009 at 8:09 pm

    #1075683

  • RE: Query performance

    Shark Energy (11/5/2009)

    Would a query that sometimes takes 10 minutes, then other times takes 45 minutes actually need tuning?

    Absolutely. In fact, I'd venture to say that eratic performance 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

    November 5, 2009 at 8:05 pm

    #1075681

  • RE: Msg 8992, Level 16, State 1, Line 1 Check Catalog Msg 3853 after sqlserver2005 sp3

    Just for your info, these errors are usually (not always but usually) the result of direct updates done to the system tables on SQL 2000. Is this an upgraded 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

    November 5, 2009 at 11:00 am

    #1075516

  • RE: Msg 8992, Level 16, State 1, Line 1 Check Catalog Msg 3853 after sqlserver2005 sp3

    Ok, seen this one before. Not too serious.

    Take a look at this blog post. If you can't solve based on what's posted there, post back and someone will hep more...

    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

    November 5, 2009 at 10:25 am

    #1075493

  • RE: Database Recovery from Log File Only

    Oh, ok. I see I need to play more. :blush:

    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

    November 5, 2009 at 10:17 am

    #1075485

  • RE: Alter SP, does it recompile ? Performance

    If you justwant to recompile a single procedure, use sp_recompile.

    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

    November 5, 2009 at 10:11 am

    #1075479

  • RE: Integrity Check Error: Check Catalog Msg 3853, State 1

    Where? The only posts I see from you are these two. Link?

    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

    November 5, 2009 at 10:07 am

    #1075475

  • RE: Restore a Database without restoring LDF

    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

    November 5, 2009 at 10:03 am

    #1075470

  • RE: Database Recovery from Log File Only

    Paul Randal (11/5/2009)

    Gail - the log file doesn't work as you describe. The *active* portion of the log *may* only be as you've described, as long as a bunch of...

    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

    November 5, 2009 at 10:02 am

    #1075468

  • RE: Integrity Check Error: Check Catalog Msg 3853, State 1

    julia.streatfield (11/5/2009)

    Hi, I'm pretty much in the same boat as Keith, i.e. v.new to this game. I've got the same errors appearing during integrity check immediately after applying sp3...

    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

    November 5, 2009 at 9:17 am

    #1075437

  • RE: Database Recovery from Log File Only

    You can buy a log reader (Apex SQL Log is around $1000) and see, but who knows what it's going to retrieve. just because the log is big doesn't 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

    November 5, 2009 at 9:02 am

    #1075422

  • RE: Stored Procedure

    This is a SQL Server forum. This is probably not the best place to ask. Try http://www.dbforums.com

    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

    November 5, 2009 at 8:57 am

    #1075417

  • RE: Sum(ISNULL(GSTExclusiveAmt,0))

    http://msdn.microsoft.com/en-us/library/ms187810.aspx

    http://msdn.microsoft.com/en-us/library/ms184325.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

    November 4, 2009 at 11:26 pm

    #1075175

Viewing 15 posts - 36,001 through 36,015 (of 49,552 total)