Forum Replies Created

Viewing 15 posts - 30,601 through 30,615 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    jcrawf02 (9/17/2010)

    Chris Morris-439714 (9/17/2010)

    Oh heck - fresh crab, lapping waves. What a thought. It's gonna be a long day.

    Haven't been able to eat crab since we went to Alaska 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

    September 17, 2010 at 7:22 am

    #1222966

  • RE: Rebuild Index/ReorganizeIndex

    There's a column page_count in the DMV you're using to check fragmentation.

    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 17, 2010 at 7:21 am

    #1222963

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

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

    Talk about your catch 22... especially since 90% of the shrink question seems to happen when you're out of space in the file / drive :w00t:.

    My personal favourite 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

    September 17, 2010 at 7:19 am

    #1222959

  • RE: Rebuild Index/ReorganizeIndex

    How big are those indexes? How many pages?

    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 17, 2010 at 7:14 am

    #1222950

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

    Brandie Tarvin (9/17/2010)

    You can't shrink other databases while the disk is full. SQL Server requires space in which to do the shrinking, in which to add markers or throw data...

    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 17, 2010 at 7:13 am

    #1222948

  • RE: Are the posted questions getting worse?

    WayneS (9/17/2010)

    Steve Jones - Editor (9/14/2010)

    Well I sent a note to our BIT friend and got a reply back. Apparently

    - he was abused

    - I contributed to the abuser by...

    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 17, 2010 at 7:08 am

    #1222943

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

    Brandie Tarvin (9/17/2010)

    If the disk is full (and it sounds pretty 100% full), will he be able to save changes to the other databases? Will he even be able to...

    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 17, 2010 at 7:05 am

    #1222940

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

    lrutkowski (9/17/2010)

    you could also add another log file on another drive. not ideal, but it will get you going until you can get the mess cleaned up, then remove...

    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 17, 2010 at 7:02 am

    #1222937

  • RE: Recovery mode of Subscriber

    It means there's a partially configured transactional replication publication at the subscriber, which from what you've said shouldn't be where.

    Can't tell number of transactions.

    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 17, 2010 at 4:22 am

    #1222874

  • RE: Recovery mode of Subscriber

    It's not normal, replication should only be a wait type at the publisher. Your solution won't fix anything, this has nothing to do with recovery models.

    You need to do 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 17, 2010 at 4:09 am

    #1222870

  • RE: Column of table

    Looks like someone's posting his homework one question at a time...

    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 17, 2010 at 3:57 am

    #1222863

  • RE: Why SQL Server 2008R2 is highlighted a different color in start menu?

    You've probably got the 'highlight newly installed programs' option selected. If so, they'll be highlighted until you use them. Win7 (and Vista) feature.

    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 17, 2010 at 3:12 am

    #1222833

  • RE: What is the meaning of Select 2^3?

    More correctly, it's the Bitwise Exclusive OR.

    The truth tables for OR and XOR (exclusive OR) are different. OR means 'If either of these inputs are true, the output is true'....

    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 17, 2010 at 3:11 am

    #1222832

  • RE: MSDB

    Which is true?

    1) This is homework

    2) This is for an interview

    3) This is for an exam.

    We don't do homework for you. I suggest you read through Books Online (The documentation...

    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 17, 2010 at 2:22 am

    #1222804

  • RE: UDF's

    Which is true?

    1) This is homework

    2) This is for an interview

    3) This is for an exam.

    Besides, I don't understand what you're asking.

    There's a lot of good info in the 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

    September 17, 2010 at 2:22 am

    #1222803

Viewing 15 posts - 30,601 through 30,615 (of 49,552 total)