Forum Replies Created

Viewing 15 posts - 40,156 through 40,170 (of 49,552 total)

  • RE: Can't restore a Copy Only backup

    Try typing the restore command manually. I seem to recall running into an issue with Copy-only and the GUI restore window.

    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

    March 24, 2009 at 12:23 pm

    #965487

  • RE: Weird Issue

    SQL ORACLE (3/24/2009)

    The T-Script I used to check database did not only provide informative message, it also caused the whole script failed. The job was terminated and marked as failure.

    We...

    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

    March 24, 2009 at 11:59 am

    #965470

  • RE: Missing indexes

    balbirsinghsodhi (3/24/2009)

    Actually, this is the stored procedure I ran every night and stored in the Missing_Indexes table. In the table , I check the column called Overall_Impact, if the this...

    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

    March 24, 2009 at 11:55 am

    #965468

  • RE: Cant Get Joins to work

    Still need the sample data.

    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

    March 24, 2009 at 11:47 am

    #965464

  • RE: Trigger advice

    Looks OK. The only thing I'd change is that if statement. If there's an update that sets some usernames to null and others to a non-null value, the IF may...

    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

    March 24, 2009 at 10:59 am

    #965417

  • RE: Cant Get Joins to work

    Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.

    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    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

    March 24, 2009 at 10:45 am

    #965399

  • RE: Are the posted questions getting worse?

    RBarryYoung (3/24/2009)

    It's like the old joke:

    Q: How many psychiatrists does it take to change a light bulb?

    A: Only one. But it takes a very long time and the light...

    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

    March 24, 2009 at 10:43 am

    #965395

  • RE: Select Command while dropping first 2 characters in the column

    Lookup the RIGHT function in Books Online. To get the results you want, you may need to combine it with LEN to get all the string except the first two...

    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

    March 24, 2009 at 10:23 am

    #965378

  • RE: Database Recovery Help

    angels4kali (3/24/2009)

    Restore from device and selecting the two above back ups

    By doing that you're telling SQL that is is one backup striped across two files, which it is not.

    Select restore,...

    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

    March 24, 2009 at 10:20 am

    #965375

  • RE: another problem I can't seem to work out.

    foxjazz (3/24/2009)

    I have an idea on how this could be done.

    Create 2 new tables with an identity, insert the records and join on identity.

    But I don't think that is 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

    March 24, 2009 at 10:17 am

    #965374

  • RE: another problem I can't seem to work out.

    foxjazz (3/24/2009)

    I am on 2005 and tmp tables are fine by me.

    Please post 2005-related questions in the 2005 forums in the future. I'm not asking to be pedantic. I'm asking...

    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

    March 24, 2009 at 10:10 am

    #965365

  • RE: another problem I can't seem to work out.

    Ok, so do you want them matched in order of the columns? So for output you want (first few rows only)

    3191 3621004

    3193 3621005

    3340 3621006

    3391 3621007

    3392 3621008

    3394 3621009

    Correct?

    Can I use 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

    March 24, 2009 at 9:54 am

    #965349

  • RE: another problem I can't seem to work out.

    foxjazz (3/24/2009)

    Are you guys saying it can't be done.

    It can be done easily. It's a trivial problem. I'm just missing some information I need.

    I don't know what your data looks...

    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

    March 24, 2009 at 9:45 am

    #965339

  • RE: Are the posted questions getting worse?

    So much for improving. Guess someone's going straight back on the blaclklist

    http://www.sqlservercentral.com/Forums/FindPost682465.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

    March 24, 2009 at 9:28 am

    #965321

  • RE: Database Recovery Help

    angels4kali (3/24/2009)

    I get this message:

    The volume on device 'C:\PathToFullBackup\FullbackFile.bak' is not part of a multiple family media set. BACKUP WITH FORMAT can used to form a new media set. RESTORE...

    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

    March 24, 2009 at 9:23 am

    #965318

Viewing 15 posts - 40,156 through 40,170 (of 49,552 total)