Forum Replies Created

Viewing 15 posts - 23,761 through 23,775 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    Jan Van der Eecken (9/2/2011)

    GilaMonster (9/1/2011)

    mtillman-921105 (9/1/2011)

    GilaMonster (9/1/2011)

    SQLRNNR (9/1/2011)

    Reminds me of a story about my mother-in-law. A duck was in her garden. She went to chase it away...

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

    #1376304

  • RE: Are the posted questions getting worse?

    mtillman-921105 (9/1/2011)

    GilaMonster (9/1/2011)

    SQLRNNR (9/1/2011)

    Reminds me of a story about my mother-in-law. A duck was in her garden. She went to chase it away and the duck bit back....

    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 1, 2011 at 4:57 pm

    #1376225

  • RE: Are the posted questions getting worse?

    SQLRNNR (9/1/2011)

    Reminds me of a story about my mother-in-law. A duck was in her garden. She went to chase it away and the duck bit back. She...

    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 1, 2011 at 3:25 pm

    #1376203

  • RE: Recovery Models

    In the context of the quote it's usually pretty clear. If there's been some disaster you will know (or easily be able to find out) whether the drive that 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 1, 2011 at 2:10 pm

    #1376166

  • RE: REPLICATION ISSUE

    And have you checked what the error message told you to check? (the piece I highlighted)

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

    #1376146

  • RE: Where Do You Park?

    Peter Maloof (9/1/2011)

    jay holovacs (9/1/2011)

    Sometimes when I'm being 'stalked' for while walking to my parking spot at the mall, and feeling ornery, I will leisurely walk down a different row,...

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

    #1376144

  • RE: REPLICATION ISSUE

    niravbhat (9/1/2011)

    The Replication agent has not logged a progress in 10 minutes. This might indicates an unresponsive agent or high system activity, Verify that records are being replicated to 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 1, 2011 at 1:15 pm

    #1376136

  • RE: Set/extend kernel shared memory parameters

    I'm not likely to have a whitepaper about a strange error from an unknown application.... Ask the vendor what, in their application, causes that error.

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

    #1376120

  • RE: 2 Indexes in same columns, but the column order is different - Whats the difference?

    balasach82 (9/1/2011)

    Setting Recompute Statistics to YES, would mean, that whenever there is modification, the respective inded gets updated immediately, which can also slow a query/degrade performance for little time.

    Am I...

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

    #1376114

  • RE: Set/extend kernel shared memory parameters

    That's not a SQL Server error. I'd contact the application vendor.

    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 1, 2011 at 11:14 am

    #1376075

  • RE: Recovery Models

    One undo of a truncate coming right up...

    CREATE TABLE TestingTruncate (SomeUselessColumn varchar(50))

    INSERT INTO TestingTruncate

    SELECT NAME FROM sys.columns

    SELECT * FROM TestingTruncate -- 501 rows

    BEGIN TRANSACTION

    TRUNCATE TABLE TestingTruncate

    SELECT * FROM TestingTruncate...

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

    #1376072

  • RE: transaction log increase on the sam edrive where distribution database is

    Please don't cross post. It just wastes peoples time and fragments replies.

    No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1168783-391-1.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

    September 1, 2011 at 10:52 am

    #1376064

  • RE: 2 Indexes in same columns, but the column order is different - Whats the difference?

    Yes

    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 1, 2011 at 10:51 am

    #1376063

  • RE: 2 Indexes in same columns, but the column order is different - Whats the difference?

    Nope, they're different indexes.

    http://sqlinthewild.co.za/index.php/2009/01/19/index-columns-selectivity-and-equality-predicates/

    If Recompute stats is off, that means the statistics on those won't get auto updated. If the stats aren't getting auto updated, you must have a manual...

    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 1, 2011 at 10:08 am

    #1376050

  • RE: Got error on DBCC CHECKDB

    What's the output of the checkDB statement that calvo was thoughtful enough to post? (the entire, unedited output)

    Do you have a clean backup (one without any corruption)

    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 1, 2011 at 8:42 am

    #1376000

Viewing 15 posts - 23,761 through 23,775 (of 49,552 total)