Forum Replies Created

Viewing 15 posts - 21,481 through 21,495 (of 49,552 total)

  • RE: The transaction log

    Also maybe worth noting that both the log write (when the log buffer is flushed to disk) and the data write (via checkpoint/lazywriter) can occur before the transaction commits, however...

    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 30, 2011 at 6:19 am

    #1426917

  • RE: Are the posted questions getting worse?

    Ninja's_RGR'us (12/30/2011)

    2011 was the year of the Monster, wonder how she can beat that next year :-D.

    I didn't even notice that.

    GG Steve.

    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 30, 2011 at 6:17 am

    #1426916

  • RE: I'm stuck on this problem - Msg 4104, Level 16, State 1, Line 25 The multi-part identifier "pp.PhoneNumber" could not be bound

    Does the table dbo_PersonPhone have a column called PhoneNumber?

    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 30, 2011 at 4:21 am

    #1426857

  • RE: The transaction log

    Pretty much.

    The order is:

    Change written to memory and log entry written into log buffer.

    Log buffer flushed to disk when the transaction commits (or sometimes earlier)

    Later the data change 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 30, 2011 at 4:18 am

    #1426855

  • RE: Edit rollove size threshold in SQL Server profiler trace

    No, you'll need to stop and delete the trace and then recreate 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 30, 2011 at 2:58 am

    #1426817

  • RE: Transaction Log Is Full

    SQLFreeman-486832 (12/29/2011)

    If you do not need to log all of the transactions, put the database in "Simple" Recovery mode. This will prevent the transactionlog from filling up.

    All transactions...

    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 29, 2011 at 1:56 pm

    #1426700

  • RE: sysobjects or sys.objects

    Thought as much. On SQL 2000 use sysobjects. On 2005 and above, it is sys.procedures and sys.objects.

    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 29, 2011 at 1:47 pm

    #1426696

  • RE: sysobjects or sys.objects

    Please run the following and post the results

    SELECT @@Version

    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 29, 2011 at 12:49 pm

    #1426660

  • RE: When Would You Use the SERIALIZABLE Transaction Isolation Level

    David Moutray (12/29/2011)

    As always, you are ever the voice of reason, Gail.

    I try. Bear in mind that I am a developer, so I come at this from a different perspective....

    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 29, 2011 at 12:25 pm

    #1426653

  • RE: Database in 'Recovery Pending' State -Error 945

    Vertigo44 (12/29/2011)

    When running DBCC CHECKDB (emergencydemo, REPAIR_ALLOW_DATA_LOSS) WITH NO_INFOMSGS;

    is there a way to see what tables were lost or at least some information on what happend...

    Maybe, it reports on what...

    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 29, 2011 at 12:19 pm

    #1426651

  • RE: When Would You Use the SERIALIZABLE Transaction Isolation Level

    If I may suggest....

    This is not a technical problem and should not be approached as one, and approaching it as a battle is going to make matters worse, not 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

    December 29, 2011 at 12:08 pm

    #1426642

  • RE: Fragmentation and ALTER INDEX REBUILD/REORGANIZE not resolving it

    1) Kinda...

    Fragmentation affects large range scans from disk. Emphasis large and disk. The intermediate levels (anything other than 0) tend to be much smaller than the leaf level, and far...

    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 29, 2011 at 11:53 am

    #1426629

  • RE: When Would You Use the SERIALIZABLE Transaction Isolation Level

    GSquared (12/29/2011)

    On his other thread, I just finished suggesting (not seriously) that he require all the devs to replace NoLock with TablockX in all their queries. Imagine all 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

    December 29, 2011 at 11:50 am

    #1426626

  • RE: When Would You Use the SERIALIZABLE Transaction Isolation Level

    David Moutray (12/29/2011)

    Well, it seems to me (in my role as Devil's Advocate) that it would require you to fix transaction locking issues arising from crappy code.

    Probably more than 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 29, 2011 at 11:48 am

    #1426623

  • RE: When Would You Use the SERIALIZABLE Transaction Isolation Level

    David Moutray (12/29/2011)

    It occurred to me that you could do exactly that (forget about transactions) by setting the transaction isolation level to SERIALIZABLE. (Sometimes I just amaze myself with...

    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 29, 2011 at 11:38 am

    #1426614

Viewing 15 posts - 21,481 through 21,495 (of 49,552 total)