Forum Replies Created

Viewing 15 posts - 27,826 through 27,840 (of 49,552 total)

  • RE: SQL server DBA

    I'd start with this: http://sqlskills.com/BLOGS/PAUL/category/Involuntary-DBA.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

    February 11, 2011 at 9:16 am

    #1285767

  • RE: Unable to truncate sql log file

    So there's nothing in the blocked_by column?

    Let me get a second opinion on this.

    Is restarting SQL an option?

    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

    February 11, 2011 at 9:11 am

    #1285760

  • RE: Unable to truncate sql log file

    newbee dba (2/11/2011)

    how do i check what process is running this ?

    Query sys.dm_exec_request and sys.dm_exec_sessions

    Can i kill it and shrink the log file

    Don't fixate on shrinking the log. What's important...

    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

    February 11, 2011 at 8:39 am

    #1285741

  • RE: Unable to truncate sql log file

    And the open transaction?

    GilaMonster (2/11/2011)

    Also check that open transaction. The output of opentran indicates that a single transaction has been running since the 9th Feb. You need to find 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

    February 11, 2011 at 8:02 am

    #1285730

  • RE: Filegroup backup

    You could restore Primary plus that one filegroup as a new database and copy the data over. Or you could get a 3rd party tool (like RedGate's Virtual Restore or...

    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

    February 11, 2011 at 7:50 am

    #1285723

  • RE: Unable to truncate sql log file

    Transactional replication? If that's the case, check the log reader SQL agent job and make sure that it's running.

    Also check that open transaction. The output of opentran indicates that 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

    February 11, 2011 at 7:45 am

    #1285720

  • RE: Are the posted questions getting worse?

    The Dixie Flatline (2/11/2011)

    QA is where some developers send their code to see if it works correctly or not.

    Oh, you mean production. Cool, now I'm clear... :sick:

    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

    February 11, 2011 at 7:38 am

    #1285709

  • RE: Are the posted questions getting worse?

    GSquared (2/11/2011)

    Just suggest getting rid of the dev database entirely and developing in production. Think of the time it will save and the efficiency it will create by not...

    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

    February 11, 2011 at 7:27 am

    #1285694

  • RE: Unable to truncate sql log file

    What replication are you running?

    The log is been kept active by replication, you won't be able to do anything until you sort out the root cause.

    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

    February 11, 2011 at 7:20 am

    #1285686

  • RE: Are the posted questions getting worse?

    Grant Fritchey (2/11/2011)

    I don't mind pointing out that Red Gate has a tool that can help with this. It's called SQL Storage Compress.

    Great, if the client was willing to pay...

    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

    February 11, 2011 at 7:15 am

    #1285680

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (2/11/2011)

    GilaMonster (2/11/2011)

    I'm going to be spending part of the weekend cutting down a prod database for restore in dev, on my laptop. There's not enough space in dev...

    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

    February 11, 2011 at 7:11 am

    #1285676

  • RE: DML info for a table

    crazy4sql (2/11/2011)

    Please stop recommending that people look in the default trace for data changes. Data changes are not tracked by the default trace in any version of SQL.

    then what 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

    February 11, 2011 at 7:10 am

    #1285675

  • RE: DML info for a table

    crazy4sql (2/11/2011)

    Please follow this very well written article:-

    http://feodorgeorgiev.com/blog/2011/01/what-objects-were-created-altered-and-deleted-in-the-past-24-hours/

    Please stop recommending that people look in the default trace for data changes. Data changes are not tracked by the default trace 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

    February 11, 2011 at 5:45 am

    #1285626

  • RE: Are the posted questions getting worse?

    Craig Farrell (2/11/2011)

    On another note, it's 2 in the morning and I'm still watching this job go so that I can get a project up to QA in the morning....

    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

    February 11, 2011 at 5:40 am

    #1285624

  • RE: PURPOSE OF TEMPORARY TABLES

    Temporary storage of interim result sets that will be further processed by the procedure.

    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

    February 11, 2011 at 5:38 am

    #1285623

Viewing 15 posts - 27,826 through 27,840 (of 49,552 total)