Forum Replies Created

Viewing 15 posts - 42,451 through 42,465 (of 49,552 total)

  • RE: Corrupt DB -repair or restore

    Means that the corruption was present in that backup. Do you run checkDB regularly?

    If this is 2005, check the error log for the startup messages. As SQL brings the DBs...

    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

    December 10, 2008 at 5:35 am

    #910243

  • RE: Do we have syatem table like DUAL in oracle

    sabarichandru (12/10/2008)

    i need for to run the single line statement in Tsql without using any specific tables ..

    Unlike in Oracle, SQL doesn't require the from clause or a table 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

    December 10, 2008 at 5:34 am

    #910242

  • RE: Improve SQL Query Performance

    debjani.bedajana (12/9/2008)

    Hi Gail,

    Sorry to bother you. Wondering if you could find some solution. Thanks for your help.

    Debjani

    Chris seems to have the query sorted. I'll take a look when I have...

    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

    December 10, 2008 at 5:32 am

    #910239

  • RE: Performance optimization of UNIOn

    Is that the only index?

    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

    December 10, 2008 at 2:09 am

    #910152

  • RE: Do we have syatem table like DUAL in oracle

    There's isn't a 'dual' table in SQL. What do you need it 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

    December 10, 2008 at 2:05 am

    #910146

  • RE: retrieve the previous version of a stored procedure

    Kishore.P (12/10/2008)

    you can generate the script the sp for previous ver. if it is not encrypted.

    How, if the proc has been written over?

    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

    December 10, 2008 at 1:59 am

    #910139

  • RE: Database growth

    madhu.arda (12/10/2008)

    Hi Jeff,

    Iam curious to know why the available space for the database was showed as zero in enterprise manager and negative value when I ran sp_spaceused before running DBCC...

    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

    December 10, 2008 at 1:02 am

    #910114

  • RE: Performance optimization of UNIOn

    arup_kc (12/10/2008)

    I have a notion than "SELECT D.Label" will take more system resources than "SELECT 1". And since EXISTS works on boolean value, hence no difference between the two but...

    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

    December 10, 2008 at 12:51 am

    #910111

  • RE: Log File viewer shows error for backup

    Have you got any other backup tools than litespeed? That looks like the kind of messages that a 'snapshot' backup tool would generate. They work by asking SQL to temporarily...

    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

    December 10, 2008 at 12:24 am

    #910103

  • RE: retrieve the previous version of a stored procedure

    Find a backup of the DB that has the version of the proc that you want. Restore that alongside the existing DB and then script out the 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

    December 10, 2008 at 12:22 am

    #910101

  • RE: pls help me

    ganesha2181 (12/9/2008)

    *** i have a 400000 lacs data. i want to this data separeted to 40 tables. per table have 100000 data.

    Why?

    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

    December 10, 2008 at 12:18 am

    #910098

  • RE: Performance optimization of UNIOn

    mohd.imtiaz (12/9/2008)

    Hi Gail,

    here is the table defination

    Index definitions?

    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

    December 10, 2008 at 12:08 am

    #910093

  • RE: Are the posted questions getting worse?

    rbarryyoung (12/9/2008)

    GilaMonster (12/9/2008)

    I still think my favourite has to be this piece of code that I found when one of the devs complained that the dev server was very slow....

    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

    December 9, 2008 at 4:06 pm

    #910001

  • RE: sql 2005 encryption

    Joe (12/9/2008)

    I want to do encryption in sql 2005 without modfiing any exsiting data structure or application? it that possible in sql 2005; pls hlep; thanks in advance.

    What do you...

    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

    December 9, 2008 at 2:57 pm

    #909975

  • RE: Are the posted questions getting worse?

    Matt Miller (12/9/2008)

    Funny - that's the EXACT reaction I got when I tossed it back....:)

    Just about every time I've done a presentation or informal training and mentioned the problems of...

    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

    December 9, 2008 at 2:43 pm

    #909965

Viewing 15 posts - 42,451 through 42,465 (of 49,552 total)