Forum Replies Created

Viewing 15 posts - 43,411 through 43,425 (of 49,552 total)

  • RE: Transaction Log Free space

    yulichka (10/31/2008)

    recovery interval (min)03276700

    allow updates0100

    .....

    What's the question?

    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

    October 31, 2008 at 7:50 am

    #892336

  • RE: Managing Transaction Logs

    Jack Corbett (10/31/2008)

    GilaMonster (10/31/2008)

    I'll put the suggestion on the list. Currently I'm contemplating an article 'Help, my database is corrupt, what do I do?'

    Pray your backups are good and restore?...

    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

    October 31, 2008 at 7:47 am

    #892334

  • RE: The famous "Must declare the variable '@...'" again :(

    Can you fix the wrapping please?

    Does creating the proc give the error, or running it?

    I can create that without error on SQL 2008. Are you sure that's exactly what you're...

    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

    October 31, 2008 at 7:43 am

    #892329

  • RE: Managing Transaction Logs

    Jack Corbett (10/31/2008)

    Very nice article Gail. Clear, concise, and to the point. Sounds like a follow-up on how the checkpoint and lazy writer work would be good.

    Thanks. Glad...

    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

    October 31, 2008 at 7:36 am

    #892319

  • RE: Managing Transaction Logs

    Bob Bridges (10/31/2008)

    One thing I'm not absolutely clear on though... you mentioned the "daisy chain of logs" in recovery. If I have a full backup every night and have transaction...

    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

    October 31, 2008 at 7:35 am

    #892317

  • RE: Managing Transaction Logs

    Karrasko's Co. (10/31/2008)

    What do you think about this method?

    I think it won't do what you think it will. If you truncate the transaction log then you can neither take a...

    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

    October 31, 2008 at 7:33 am

    #892315

  • RE: Managing Transaction Logs

    Luke L (10/31/2008)

    Nice Article Gail, I did have one question though. Perhaps it's just me but it's been something I've seen here at SSC a few times in recent...

    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

    October 31, 2008 at 7:22 am

    #892303

  • RE: Managing Transaction Logs

    Chirag (10/31/2008)

    Thank you Gail. That explains things clearly. So would the same apply to BLOB data. Would BLOB data be brought into memory and then modified?

    Exactly the same. The query...

    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

    October 31, 2008 at 2:59 am

    #892200

  • RE: Total server memory vs Traget memory

    As far as I know, total is what it has and target is the value it's aiming for. If target is higher than total, then SQL will be acquiring 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

    October 31, 2008 at 2:56 am

    #892199

  • RE: When do we need to restore the system databases?

    When the drive that they're on fails.

    Model is not for DTS packages. Model is the template for creation of any other database (including tempDB when it gets recreated). MSDB 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

    October 31, 2008 at 2:50 am

    #892196

  • RE: Developement Difference between SQL 2000 and 2005?

    Books Online has a good section on what's new in 2005.

    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

    October 31, 2008 at 2:48 am

    #892194

  • RE: Managing Transaction Logs

    Anirban Paul (10/30/2008)

    Excellent discussion... Useful one

    ALZDBA (10/31/2008)

    100% demystification 😎

    Thank you. Glad you liked 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

    October 31, 2008 at 2:41 am

    #892191

  • RE: Managing Transaction Logs

    Chirag (10/31/2008)

    Say there is a big data modification (update statement) going on and not all pages affected by the update stmt are in the buffer/memory. Will the pages not 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

    October 31, 2008 at 2:38 am

    #892190

  • RE: Managing Transaction Logs

    Jake (10/30/2008)

    When do checkpoints happen?

    At regular intervals depending on the number and frequency of data modifications.

    Are they automatic?

    Yup.

    Can they be invoked programmatically?

    Yes. The command is CHECKPOINT. It'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

    October 31, 2008 at 2:34 am

    #892188

  • RE: MDX query help

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

    No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic594505-17-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

    October 30, 2008 at 10:37 am

    #891967

Viewing 15 posts - 43,411 through 43,425 (of 49,552 total)