Forum Replies Created

Viewing 15 posts - 34,936 through 34,950 (of 49,552 total)

  • RE: Women in Technology

    support 79032 (1/6/2010)

    Anyone care to address the fact that there is no-where near a 50/50 division in child custody and yet we are debating how to make more jobs for...

    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 6, 2010 at 8:48 am

    #1099650

  • RE: Ensure protection of db tlogs

    laddu4700 (1/6/2010)

    In SQL is there any way to perform database log audit?

    Plenty of ways. Depends what you want to log, how you want the info stored, etc.

    I suggest you hit...

    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 6, 2010 at 8:31 am

    #1099632

  • RE: Query Optiimisation

    Please post query, table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

    Might be parameter sniffing.

    http://sqlinthewild.co.za/index.php/2007/11/27/parameter-sniffing/

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

    #1099610

  • RE: Are the posted questions getting worse?

    Steve Jones - Editor (1/6/2010)

    I see The Thread is alive and well. Happy 2010 to everyone.

    And to you Steve. Welcome 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

    January 6, 2010 at 8:11 am

    #1099605

  • RE: Ensure protection of db tlogs

    kareem007 (1/6/2010)

    How to protect the database transaction logs from alteration and deletion.

    The transaction logs cannot be altered, trying to do so will render the database suspect. Deleting them will often...

    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 6, 2010 at 8:11 am

    #1099604

  • RE: CXPACKET wait type

    Swirl, please explain 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

    January 6, 2010 at 8:06 am

    #1099597

  • RE: Restore keeps failing ?

    Your backup is damaged or there's an IO problem with the SAN. You can try to use CONTINUE_AFTER_ERROR, but do note that if you do so, some of the database...

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

    #1099596

  • RE: Women in Technology

    Manic Star (1/6/2010)

    Except for some locker room behavior at a few clients, I've not noticed any serious discrimination in my 20 years in the business.

    Same here. Worst I've had...

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

    #1099595

  • RE: Are the posted questions getting worse?

    GSquared (1/6/2010)

    If you can't access it, try Tarot cards to figure out the password.

    I have a set, if you need me to do a reading.

    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 6, 2010 at 7:25 am

    #1099564

  • RE: Can a RESTORE Change Collations?

    GDI Lord (1/6/2010)

    Can a restore change collations like this? I wouldn't think so, but...

    Shouldn't be able to. A restore recreates the database as it was at the point it was...

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

    #1099553

  • RE: Damage database, please help

    Please rather post new questions in a new thread. Often people won't look at threads with lots of answers, assuming they are resolved.

    In a new thread, please post the full...

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

    #1099549

  • RE: Women in Technology

    david_wendelken (1/6/2010)

    I'm very active in user groups. I've noticed the % of women at user groups is now way less than 20%. More like 5%. Again, 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

    January 6, 2010 at 7:09 am

    #1099544

  • RE: Women in Technology

    barriorm (1/6/2010)

    I have to disagree with the kind person who said that most women's professional women's organizations are 'pity parties'.

    I said no such thing. If you're going to quote...

    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 6, 2010 at 4:35 am

    #1099465

  • RE: transaction log growing

    Then you need to investigate why the replication isn't working. That's what's causing the log to grow.

    Does DBCC OPENTRAN say anything about replication?

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

    #1099432

  • RE: Backing up Large Database with limited bandwidth / time slot etc

    pmathewson (1/6/2010)

    I am fairly new to SQL have always done server, hardware and network support .

    No senior DBA there?

    Should I back up all transaction logs aswell with or without truncate?

    Please...

    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 6, 2010 at 2:49 am

    #1099418

Viewing 15 posts - 34,936 through 34,950 (of 49,552 total)