Forum Replies Created

Viewing 15 posts - 28,486 through 28,500 (of 49,552 total)

  • RE: Sensible Archiving

    irobertson (1/13/2011)

    Is it safe / wise for me to run only a db backup, then drop the database and delete the t-log backup files? Is a t-log backup file required...

    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 13, 2011 at 3:08 am

    #1272887

  • RE: Are the posted questions getting worse?

    Koen (da-zero) (1/12/2011)

    bitbucket-25253 (1/12/2011)

    JUst got the notification

    http://www.microsoft.com/downloads/en/details.aspx?FamilyID=b953e84f-9307-405e-bceb-47bd345baece&displaylang=en

    Now Available for Download

    The RTM version of Service Pack 4 (SP4)

    for Microsoft SQL Server 2005 is now available

    Isn't SP4 already some...

    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 13, 2011 at 3:01 am

    #1272885

  • RE: Transactional log back up taken monthly once

    What do you need to see?

    The resultant data change for each transaction?

    The exact insert/update/delete that was run?

    Selects as well?

    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 13, 2011 at 2:56 am

    #1272883

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (1/12/2011)

    They are hoping that pennies get EOL'd. We'll see if it ever happens.

    Happened here a few years back. The 1c and 2c coins were discontinued...

    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 13, 2011 at 2:54 am

    #1272882

  • RE: Execute sql without writing on transaction log

    sachnam (1/13/2011)

    1. will shrinking always shrink your log file even if it is in use?

    No, and repeatedly shrinking logs is not recommended.

    2. Why to run a full backup after 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

    January 13, 2011 at 2:37 am

    #1272871

  • RE: IS Shrink part of Full Backup by default or as an option

    MothInTheMachine (1/12/2011)

    Would using a hex editor involve scrolling through the files manually, thus taking me a month, or is there a search feature that can be used?

    I suggest that you...

    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 12, 2011 at 3:48 pm

    #1272696

  • RE: sp_estimate_data_compression_savings question

    Table got a clustered index? Does the compression results include the cluster?

    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 12, 2011 at 3:37 pm

    #1272689

  • RE: Database Performance

    I strongly suggest that you get a consultant in to do a review and point out any areas of potential problem

    Disclaimer: I am a consultant and this is the kind...

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

    #1272567

  • RE: View question

    varunkum (1/12/2011)

    Can i use the table, will that make the execution faster ??

    Maybe. Depends what the view is. If it's just a straightforward select with some conditions, unlikely.

    Views are...

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

    #1272560

  • RE: Restoring a copy from a Log Shipped database

    You cannot get them read-write without breaking log shipping. Copy over another full backup 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

    January 12, 2011 at 12:18 pm

    #1272559

  • RE: Memroy Issue

    Bear in mind that the max_memory setting limits the buffer pool, not SQL's total memory usage. It can use extra memory for non-paged allocations - thread stacks, backup buffers, CLR,...

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

    #1272558

  • RE: Seeking Advise for DTA

    DTA's not perfect. It's far from it. Take any recommendations as suggestions to start from, nothing more.

    Yes, it takes time to do an analysis. Run it locally against a test...

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

    #1272554

  • RE: Are the posted questions getting worse?

    Grant Fritchey (1/12/2011)

    Anyone interested in reading a short blog post? I'm a little nervous about putting this one up. I'm talking about how heaps are stored and I've made mistakes...

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

    #1272547

  • RE: Restoring individual filegroups

    Ken Davis (1/12/2011)

    So in my example, to only restore the reporting tables, I should put the reporting tables in Primary and put all other tables in another filegroup. Then...

    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 12, 2011 at 11:48 am

    #1272540

  • RE: Execute sql without writing on transaction log

    Schadenfreude-Mei (1/12/2011)

    True but from the posters first post it seems they are worried about log filling (and presumably subsiquent growths) during the night.

    Index rebuilds can and do grow 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

    January 12, 2011 at 9:32 am

    #1272453

Viewing 15 posts - 28,486 through 28,500 (of 49,552 total)