Forum Replies Created

Viewing 15 posts - 36,016 through 36,030 (of 49,552 total)

  • RE: SQL SERVER Fatal Error When Job is running stored procedure.

    If you get this repeatedly, call Microsoft's customer support people. They have the tools to analyse and debug stackdumps, we don't.

    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

    November 4, 2009 at 11:02 pm

    #1075167

  • RE: Replication from SQL 2005 to Oracle 11g

    Please don't cross post. it just wastes people's replies and fragments replies.

    no replies to this thread please. Replies to: http://www.sqlservercentral.com/Forums/Topic813865-291-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

    November 4, 2009 at 7:43 pm

    #1075116

  • RE: Database Recovery from Log File Only

    The log contains only the changes since the last log backup (in full recovery when a full backup was taken at some point) or since the last checkpoint (in simple...

    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

    November 4, 2009 at 7:35 pm

    #1075115

  • RE: Stored Procedure

    rahulsony111 (11/4/2009)

    I think it is oracle.

    You think? Which database engine is the stored procedure part of? Shouldn't be a hard thing to tell.

    If you know can you help me?

    If 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

    November 4, 2009 at 7:29 pm

    #1075114

  • RE: check list for Migrating sql server 2000 to 2005

    Brandie Tarvin (11/4/2009)

    I'm not looking for "what will happen" so much as I am "how it all works," if that makes sense.

    Will see what I can find you, won't...

    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

    November 4, 2009 at 7:25 pm

    #1075112

  • RE: Does SQL2005/2008 recreate missing transaction log file(s) in case of data corruption?

    As far as I'm aware (haven't tested), with a single log file SQL may be able to recreate the log if it's deleted, with 2 or more, it won't. 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

    November 4, 2009 at 7:24 pm

    #1075111

  • RE: Stored Procedure

    Oracle database? Is this an Oracle or SQL Server stored procedure?

    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

    November 4, 2009 at 11:40 am

    #1074954

  • RE: Does SQL2005/2008 recreate missing transaction log file(s) in case of data corruption?

    jocampo (11/4/2009)

    Normally, when there is only one log file, if its missing, SQL will recreate it.

    Sometimes, not always. If the DB was not cleanly shut down, the log cannot...

    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

    November 4, 2009 at 11:35 am

    #1074952

  • RE: restore to a point in time/recover deleted data

    Animal Magic (11/4/2009)

    If the database was in full/bulk recovery model you could possibly have used a log reader tool to recover the data

    If a DB is in full recovery 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

    November 4, 2009 at 11:23 am

    #1074949

  • RE: Query tuning ONLY FOR THE BRAVE & BOLD

    Dave Ballantyne (11/4/2009)

    1. The problem with this is that sqlServer will scan every row testing the logic, it wont shortcuit.

    Providing there's an appropriate index, Column IN (Value1, Value2) will be...

    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

    November 4, 2009 at 11:17 am

    #1074947

  • RE: Introduction to Indexes

    Charles Kincaid (11/3/2009)

    GilaMonster (11/3/2009)

    What are you waiting for?

    Methinks he is waiting for your next installment.

    Next week.

    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

    November 4, 2009 at 11:08 am

    #1074938

  • RE: Are the posted questions getting worse?

    Roy Ernest (11/4/2009)

    I wonder how the Kilt day is going in PASS... 🙂

    Interestingly. Photos later.

    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

    November 4, 2009 at 11:07 am

    #1074937

  • RE: Need clarification

    sejal p gudhka (11/4/2009)

    Suspect state tells that database is corrupted meaning either physical files or filegroups are damaged or logical entries in system tables has been corrupted.

    Almost. A db can...

    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

    November 4, 2009 at 12:29 am

    #1074704

  • RE: Need clarification

    parthi-1705 (11/3/2009)

    Reason for suspect databases in ms sql ,

    Could be one of several. Look in the SQL error log. There will be entries in there saying why the DB 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

    November 4, 2009 at 12:26 am

    #1074703

  • RE: Restore a Database without restoring LDF

    ra_leech (11/3/2009)

    I have a problem I need to restore a database without restoring the associated Log Files..

    Can't be done. Data and log files have to both be restored.

    i would suggest...

    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

    November 4, 2009 at 12:23 am

    #1074701

Viewing 15 posts - 36,016 through 36,030 (of 49,552 total)