Forum Replies Created

Viewing 15 posts - 21,181 through 21,195 (of 49,552 total)

  • RE: .mdf

    Create database for attach_rebuild_log is for when you've lost the transaction log, and it is by no means guaranteed to work. Deleting the transaction log or moving just the mdf...

    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

    January 10, 2012 at 4:36 am

    #1430996

  • RE: SQL Server detected a logical consistency-based I/O error

    CheckDB or CheckTable with repair allow data loss will lose data, that's why it's named that way (there are a couple cases where it won't, but they're rarer cases)

    For recovery...

    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

    January 10, 2012 at 4:34 am

    #1430994

  • RE: turn off auto update stats

    Again, it might, but that assumes that the queries are recompiling due to statistics updates, and not one of the other 8 or so possible reasons.

    http://sqlinthewild.co.za/index.php/2010/11/18/recompiles/

    http://sqlinthewild.co.za/index.php/2011/08/16/compiles-and-recompiles/

    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

    January 10, 2012 at 3:15 am

    #1430968

  • RE: SQL Server detected a logical consistency-based I/O error

    For future reference, repair should be the absolute last resort for corruption, no a knee-jerk first thing done.

    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

    January 10, 2012 at 3:01 am

    #1430963

  • RE: How we dealocate the memory of a row

    Can you explain further what you want to do?

    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

    January 10, 2012 at 2:59 am

    #1430961

  • RE: Help needed with sys.dm_db_missing_index_details DMV

    shovankar (1/10/2012)

    I am working on an OLTP system with 28 GB RAM given to the SQL Instance. But, it is running very slow and getting frequent timed out errors at...

    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

    January 10, 2012 at 2:57 am

    #1430958

  • RE: Are the posted questions getting worse?

    mtillman-921105 (1/9/2012)

    jcrawf02 (1/9/2012)

    And what does that make those of us who are following the debates about the faster than light neutrinos?

    I've been interested in that too... Is Einstein wrong?...

    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

    January 10, 2012 at 2:56 am

    #1430957

  • RE: .mdf

    No, it can be copied or moved, but it's not as simple as copying or moving access files or excel spreadsheets.

    If you're moving the database across servers, a better...

    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

    January 10, 2012 at 2:50 am

    #1430954

  • RE: combining SP_who and SP_LOCK result sets

    You could just use the DMVs instead, query and aggregate sys.dm_tran_locks (though it's a complex view) and join to sys.dm_exec_requests and sys.dm_exec_sessions.

    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

    January 9, 2012 at 3:55 pm

    #1430849

  • RE: turn off auto update stats

    It might, if the reason for the recompilation is statistics update. The trade-off is that your queries are using plans optimised for a data distribution that's no longer correct, so...

    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

    January 9, 2012 at 3:48 pm

    #1430846

  • RE: Nightly refresh of Prod data to other location across slow connection

    Ok, so courier is not an option.

    Transactional replication?

    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

    January 9, 2012 at 3:21 pm

    #1430840

  • RE: Nightly refresh of Prod data to other location across slow connection

    How far apart are the two data centres? Are there staff at both data centres?

    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

    January 9, 2012 at 3:10 pm

    #1430834

  • RE: Are the posted questions getting worse?

    mtillman-921105 (1/9/2012)

    Then, thanks to one of Ms. Shaw’s recommended books, now I'm stuck in physics and cosmology. :blink: The book I'm reading now is The Fabric of the Cosmos, which...

    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

    January 9, 2012 at 3:06 pm

    #1430831

  • RE: Error message.

    Exactly what it says...

    Satya_0000 (1/9/2012)

    During undoing of a logged operation in database Dbname, an error occurred at log record ID (605859:16:154). Typically, the specific failure is logged previously as an...

    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

    January 9, 2012 at 12:35 pm

    #1430748

  • RE: Are the posted questions getting worse?

    Jack Corbett (1/9/2012)

    I was going to comment that it would probably be cheaper and more productive to buy an e-reader than to keep going with bookshelves and "real" books.

    Got an...

    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

    January 9, 2012 at 12:26 pm

    #1430740

Viewing 15 posts - 21,181 through 21,195 (of 49,552 total)