Forum Replies Created

Viewing 15 posts - 35,971 through 35,985 (of 49,552 total)

  • RE: Introduction to the Transaction Log

    James_DBA (11/9/2009)

    While the FULL recovery model will log more details to the log, the SIMPLE recovery model will log minimal details....

    Only if those inserts could be minimally logged. Otherwise 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 10, 2009 at 7:14 am

    #1077221

  • RE: Introduction to the Transaction Log

    JacekO (11/9/2009)

    The only difference in those two modes is how long SQL Server holds on to this data, not in the data logged itself. In Simple recovery mode the log...

    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 10, 2009 at 7:11 am

    #1077216

  • RE: SSC Level List?

    Andy Llewellyn (11/10/2009)

    Did the distribution graph of members at each level ever get published?

    Don't think so, but it's heavily weighted to the lower end.

    There are 15 people 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

    November 10, 2009 at 7:07 am

    #1077210

  • RE: Are the posted questions getting worse?

    Home, finally! Two cats are not letting me out of their sight.

    Still got to configure ADSL and redo the entire wireless network. That'll teach me to change ISP while out...

    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 10, 2009 at 6:56 am

    #1077203

  • RE: why my differential backup files are HUGE?

    Index rebuilds?

    Why are you doing differential backups hourly? How often are log backups running?

    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 10, 2009 at 6:51 am

    #1077199

  • RE: multiple data files increase performance

    The whole reason for creating multiple files (in user databases) is to spread the IO load out over multiple drives, usually because the original drive(s) are maxed out. Creating multiple...

    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 10, 2009 at 6:49 am

    #1077197

  • RE: Introduction to Indexes

    Blame Steve. 😀 The footnotes were correctly numbered in the original word doc. There should be 3 footnotes, will go in and edit later.

    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 10, 2009 at 6:43 am

    #1077189

  • RE: Group by clause on partial select

    ramadesai108 (11/9/2009)

    In this case what I will have to do is to insert the records into a temp table and thru a cursor check the previous Key value 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

    November 10, 2009 at 6:40 am

    #1077186

  • RE: Altering a big table

    Try create a new column, batch-update the values, then drop the old column. Might lessen the log impact. Run checkpoints between each (since you're in simple) to mark the log...

    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 8, 2009 at 8:37 am

    #1076458

  • RE: Are the posted questions getting worse?

    Heading home, finally. Wow, I'm tired after this week.

    Offline til tuesday (flights, sleep, installing new ADSL equipment)

    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 8, 2009 at 8:33 am

    #1076455

  • RE: Did a trans log dump now my trans log backup isn't working..

    Take a full backup.

    Why are you truncating and shrinking the log?

    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 7, 2009 at 9:26 pm

    #1076410

  • RE: Data allocation in B-tree

    Chandhini (11/7/2009)

    I have 10,000 records in a table.

    What would be the degree (depth) of the B-tree?.

    Not enough information. Depends on the definition of the index in question and 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 7, 2009 at 9:25 pm

    #1076409

  • RE: Slow execution time on query who perfoms Updates

    jocampo (11/7/2009)

    I asked the developer to run it manually ... I went to Management Studio and from the running queries, I pulled out the query execution plan ... the developer...

    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 7, 2009 at 9:19 pm

    #1076408

  • RE: Log file is full

    Please read through this: http://www.sqlservercentral.com/articles/64582/

    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 7, 2009 at 11:02 am

    #1076366

  • RE: Slow execution time on query who perfoms Updates

    jocampo (11/7/2009)

    we ran that on dev environment and I captured that info ...

    How? If you pulled it later out of the plan cache it won't have the run-time information 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

    November 7, 2009 at 10:55 am

    #1076364

Viewing 15 posts - 35,971 through 35,985 (of 49,552 total)