Forum Replies Created

Viewing 15 posts - 21,406 through 21,420 (of 49,552 total)

  • RE: <Domain>\Administrators security role removed

    justin.jones 10898 (1/3/2012)

    Any idea wha may have caused this Admin account to go away?

    Someone or some app ran a script to remove it. SQL's not in the habit of...

    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 3, 2012 at 12:08 pm

    #1427938

  • RE: Back-up strategy

    have2much (1/3/2012)

    if the database is not too big, I will recommend going for nightly full backup with hourly or 2 hourly log backup to clear the logs.

    Log backups 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 3, 2012 at 12:05 pm

    #1427934

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (1/3/2012)

    About 8-10 hours per hour talk for me.

    You can't really do it in much less unless you're doing what too many of the MCTs here...

    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 3, 2012 at 12:05 pm

    #1427933

  • RE: Are the posted questions getting worse?

    Grant Fritchey (1/3/2012)

    There is courseware you can purchase, but with only 2 days to prep, you're effectively going to be reading from the slides. Here's a place online that sells...

    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 3, 2012 at 12:00 pm

    #1427929

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (1/3/2012)

    So I'm searching on thin clients and SQL Server and come up with this little gem:

    http://www.sql-server-performance.com/2000/implementing-oltp-environment/%5B/url%5D

    It's an almost 12 year old article, so I'm not sure why 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

    January 3, 2012 at 10:57 am

    #1427897

  • RE: log backups not clearing transaction log - no open transactions found

    MyDoggieJessie (1/3/2012)

    I liked the article (not to brown-nose) and will look forward to the updated version!

    Err, that (headline article today) is the updated version. Unless you're volunteering to rewrite 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

    January 3, 2012 at 10:54 am

    #1427896

  • RE: log backups not clearing transaction log - no open transactions found

    Ninja's_RGR'us (1/3/2012)

    When's the revised version coming out?

    Of the tran log article? Today.

    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 3, 2012 at 10:05 am

    #1427854

  • RE: How SQL uses Memory

    SQLKnowItAll (1/3/2012)

    lol However, it is good to know that books that are paid fr can help people around the world; i.e. SQL Server MVP Deep Dives. I got both volumes...

    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 3, 2012 at 10:01 am

    #1427850

  • RE: How SQL uses Memory

    Ninja's_RGR'us (1/3/2012)

    GilaMonster (1/3/2012)

    Ninja's_RGR'us (1/3/2012)

    Wow, you guys are so underpaid for this!

    No one writes books for money. Just ask Grant.

    So what's the real drive then?

    Challenge. Brand. Love of teaching.

    Dunno, I've...

    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 3, 2012 at 10:01 am

    #1427847

  • RE: Are the posted questions getting worse?

    Ninja's_RGR'us (1/3/2012)

    GilaMonster (1/3/2012)

    Ninja's_RGR'us (1/3/2012)

    Turns out it was another mistake (big one, but not as big). He had left live vm snapshots on for 2 weeks. Managed to fill...

    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 3, 2012 at 9:56 am

    #1427842

  • RE: log backups not clearing transaction log - no open transactions found

    Ninja's_RGR'us (1/3/2012)

    GilaMonster (1/3/2012)

    hkamal.infoedge (1/3/2012)

    Switch the full recovery mode to simple recovery mode and then switch back to full mode and take the full back up.

    No, no, no, no, no!

    And on...

    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 3, 2012 at 9:53 am

    #1427838

  • RE: How SQL uses Memory

    Ninja's_RGR'us (1/3/2012)

    Wow, you guys are so underpaid for this!

    No one writes books for money. Just ask Grant.

    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 3, 2012 at 9:51 am

    #1427835

  • RE: Are the posted questions getting worse?

    Ninja's_RGR'us (1/3/2012)

    Turns out it was another mistake (big one, but not as big). He had left live vm snapshots on for 2 weeks. Managed to fill up 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

    January 3, 2012 at 9:49 am

    #1427832

  • RE: Stored Procedures - Need to learn from the ground up!

    There's a lot of differences between Oracle's pl sql and SQL Server's T-SQL. Not just in syntax, but in the best way to approach problems.

    I recommend Itzik Ben Gan's T-SQL...

    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 3, 2012 at 9:47 am

    #1427827

  • RE: log backups not clearing transaction log - no open transactions found

    MyDoggieJessie (1/3/2012)

    I was just confused that the log_reuse_wait_desc still said LOG_BACKUP, even when nothing was running...

    A log backup wait reason means a log backup is needed, not that one...

    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 3, 2012 at 9:44 am

    #1427824

Viewing 15 posts - 21,406 through 21,420 (of 49,552 total)