Forum Replies Created

Viewing 15 posts - 31,786 through 31,800 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    Jan Van der Eecken (7/16/2010)

    It's a sweltering 10deg C today in Cpe Town, and JoBurg is even colder. That's probably why we haven't seen Gail for a while, she's probably...

    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

    July 16, 2010 at 10:11 am

    #1194199

  • RE: Revovering a query

    No. It's got a recovery on crash, but not on close query.

    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

    July 16, 2010 at 8:33 am

    #1194149

  • RE: Passed 70-442

    I had them on one of my 2008 exams, can't remember which one. I'd guess they're trying to gauge how difficult the exams are, or something like 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

    July 16, 2010 at 6:43 am

    #1194057

  • RE: Challenge on DDL Triggers and Policy Management

    Please note: 2 year old thread.

    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

    July 16, 2010 at 6:35 am

    #1194049

  • RE: How to Tuning query in sql server 2005 ?

    Could you explain your question in more detail 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

    July 16, 2010 at 4:40 am

    #1193989

  • RE: SQL 2005 DB recovery

    anilambedkar (7/16/2010)

    the recovery model of the DB is Simple

    Then there's no chance for point in time recovery anyway. You can't take log backups in Simple recovery.

    is there any way...

    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

    July 16, 2010 at 4:36 am

    #1193987

  • RE: SQL 2005 DB recovery

    HowardW (7/16/2010)

    On the subject of firing the person responsible for the delete, I'd say the true incompetence lies in never having backed up a production database rather than making 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

    July 16, 2010 at 3:47 am

    #1193972

  • RE: SQL 2005 DB recovery

    anilambedkar (7/16/2010)

    Can Red Gate Log Explorer work..... ???

    if I downgrade the database to SQL 2000 (compatability 80)

    No. It only works on SQL 2000 databases. A database attached to 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

    July 16, 2010 at 3:44 am

    #1193971

  • RE: SQL 2005 DB recovery

    anilambedkar (7/16/2010)

    I dont know how actually this point-in-time recovery works

    And you're a production DBA?

    Point-in-time recovery requires a full backup and all the transaction log backups taken since that full backup.

    How...

    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

    July 16, 2010 at 3:42 am

    #1193967

  • RE: Usage-based optimization based on QueryLog File?

    Analysis services? Are you designing cube optimisations?

    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

    July 16, 2010 at 2:48 am

    #1193949

  • RE: MCTS 2008 Training Kit Question

    hxkresl (7/15/2010)

    With a product catalog under 2MB one could theoretically add it directly to the column, is that right?

    The size limit for varbinary(max) is 2 GB, not 2 MB (and...

    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

    July 16, 2010 at 2:44 am

    #1193946

  • RE: how to use execution plan

    Also maybe of interest:

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

    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

    July 16, 2010 at 2:34 am

    #1193938

  • RE: Worst performing procedures

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

    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

    July 16, 2010 at 2:33 am

    #1193936

  • RE: Clustered index and create unique

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

    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

    July 16, 2010 at 2:33 am

    #1193935

  • RE: SQL 2005 DB recovery

    anilambedkar (7/16/2010)

    -the problem is they have never taken any sort of back up of the database since beginning

    Just noticed this.

    If there has never been a full backup of this 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

    July 16, 2010 at 2:27 am

    #1193931

Viewing 15 posts - 31,786 through 31,800 (of 49,552 total)