Forum Replies Created

Viewing 15 posts - 30,616 through 30,630 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    Steve Jones - Editor (9/16/2010)

    'postro-fees are also used to show a bit o' an accent.

    Still a contraction (left out letters)

    Where they should NOT be used..

    In fantasy/sci-fi 'languages to persuade 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

    September 16, 2010 at 3:11 pm

    #1222651

  • RE: D: drive is full and transaction log is full

    Do you have another drive with 2.5 GB on it? (The C drive even, or a flash drive, anything!)

    If so, move TempDB completely (ALTER DATABASE TempDB ...), then restart...

    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

    September 16, 2010 at 2:53 pm

    #1222633

  • RE: D: drive is full and transaction log is full

    Ninja's_RGR'us (9/16/2010)

    It's a good idea, but I'd assume that ALL databases on that drive are readonly at this point... or about to be running out of space (since the shrink...

    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

    September 16, 2010 at 2:42 pm

    #1222619

  • RE: Large LDF Despite Frequent Backups

    Richard M. (9/16/2010)

    That's where a tool like Idera's SQL Diagnostic manager comes in handy, as you can go back in time and see things like active sessions running and what...

    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

    September 16, 2010 at 2:37 pm

    #1222608

  • RE: Are the posted questions getting worse?

    Craig Farrell (9/16/2010)

    @Gail: Trial by fire much?

    Actually no. In last 5 years I've had:

    - One database with corrupt log that required a restore

    - One very long restart/recovery (12 hours) resulting...

    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

    September 16, 2010 at 2:37 pm

    #1222607

  • RE: D: drive is full and transaction log is full

    WayneS (9/16/2010)

    @Gail - out of curiosity, would adding a drive and configuring it as a "mount point"(?) that expands the D drive be an alternative for freeing up space?

    Don't think...

    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

    September 16, 2010 at 2:36 pm

    #1222606

  • RE: D: drive is full and transaction log is full

    WayneS (9/16/2010)

    @Gail - just curious... how did you acquire this mountain of knowledge on disaster recovery of failed databases? Like I mentioned earlier, you're one of the best out there......

    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

    September 16, 2010 at 2:29 pm

    #1222599

  • RE: D: drive is full and transaction log is full

    hallhome (9/16/2010)

    I think the cause is known - the database is using FULL recovery model

    and the transaction logs have never been backed up. Only full database backups have been...

    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

    September 16, 2010 at 2:04 pm

    #1222573

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (9/16/2010)

    Eats, Shoots and Leaves?

    Yup. Borrowed it from a friend (M.A English Lit) and loved 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

    September 16, 2010 at 1:56 pm

    #1222562

  • RE: SQL Server no downtime database changes

    Again, what kind of changes?

    Things like alter procedure, alter view, create table are all online operations. Alter table may or may not be, depending on what exactly you're doing.

    No...

    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

    September 16, 2010 at 1:50 pm

    #1222558

  • RE: D: drive is full and transaction log is full

    hallhome (9/16/2010)

    So.......you're saying that freeing up space on the drive will not do anything and that bouncing the server will not do anything? Which means that my only recourse...

    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

    September 16, 2010 at 1:48 pm

    #1222551

  • RE: Critical issues detected by SQL Server BPA

    Mark, I can't reply to your PM, either PMs are disabled or your mailbox is full. Check please, I'll try again tomorrow to send a reply.

    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

    September 16, 2010 at 1:43 pm

    #1222547

  • RE: SQL Server no downtime database changes

    Depends. What changes?

    Schema changes may or may not be online, depending what exactly you're doing. Index rebuilds can be online in Enterprise Edition. Backups are online. Data migrations, again depends...

    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

    September 16, 2010 at 1:26 pm

    #1222531

  • RE: Are the posted questions getting worse?

    Paul White NZ (9/16/2010)

    GilaMonster (9/16/2010)

    Steve Jones - Editor (9/16/2010)

    What's humour? You hanging out with Brit's in TN?

    He's finally learnt to spell properly. 😀

    Perhaps a course on the correct use...

    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

    September 16, 2010 at 1:23 pm

    #1222530

  • RE: SQL trace owned by accoung sa - system generated?

    Lowell (9/16/2010)

    remember all spids under #50 are system spids anyway; user spids are 50 and up.

    On 2005 and higher it's possible to have system spids with session_id above 50. Sys.dm_exec_sessions...

    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

    September 16, 2010 at 1:21 pm

    #1222527

Viewing 15 posts - 30,616 through 30,630 (of 49,552 total)