Forum Replies Created

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

  • RE: Career Change

    Nope.

    Good answer - go find backups.

    Better answer - ask for help because this is out of my depth.

    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 16, 2010 at 3:30 pm

    #1134871

  • RE: Are the posted questions getting worse?

    There are two numbers that I tend to use when making this kinds stuff up.

    42 - the answer to the ultimate question of life, the universe and everything

    137 - The...

    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 16, 2010 at 3:29 pm

    #1134869

  • RE: Are the posted questions getting worse?

    Alvin Ramard (3/16/2010)

    SSIS now? or wait till later? 😀

    OUCH!! that hurts!!!!

    😀

    Good answers for that question:

    * Look for help

    * Call MS customer support

    * Go look for my backups

    Yes, I know...

    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 16, 2010 at 3:19 pm

    #1134859

  • RE: Career Change

    falcon00 (3/16/2010)

    I don't think you are discouraging me. I think you all bring up very solid points and allowing me to step back and evaluate my capabilities and look at...

    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 16, 2010 at 3:14 pm

    #1134857

  • RE: Career Change

    Cool. It returns several lines of errors and the last two lines read.

    CheckDB found 42 allocation errors and 137 consistency errors in database 'mydatabase'.

    DBCC execution completed. If DBCC printed...

    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 16, 2010 at 3:11 pm

    #1134854

  • RE: Restoring a db with more data files??

    A restore recreates the DB exactly as it was at the time of backup. You can move the files around, you cannot create new files as part of a 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 16, 2010 at 2:41 pm

    #1134824

  • RE: Career Change

    If they're pressing to urgently hire, it means they are desperate, probably means they have problems that they need solving. Not a good situation to walk into as a complete...

    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 16, 2010 at 2:41 pm

    #1134825

  • RE: Avoiding Sort task in Execution Plan

    Is the sort a problem?

    Is the specific query that you're looking at a problem?

    You said it's not a poorly performing query, so why are you worried about it?

    http://sqlinthewild.co.za/index.php/2010/03/11/the-root-of-all-evil/

    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 16, 2010 at 2:30 pm

    #1134811

  • RE: Conditionally Execute A Stored Procedure

    More details needed. Perhaps you can take a step back and explain the slightly larger picture?

    What defines which row of a table those values have to come from? Or are...

    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 16, 2010 at 2:27 pm

    #1134808

  • RE: Conditionally Execute A Stored Procedure

    IF <conditions>

    BEGIN

    EXEC TheStoredProc

    END

    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 16, 2010 at 2:07 pm

    #1134785

  • RE: SQL BIDS 2005 to access a SQL 2008 Database -Can this be done?

    Please don't cross post. It just wastes peoples time and fragments replies.

    No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic884158-1063-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

    March 16, 2010 at 2:06 pm

    #1134783

  • RE: Career Change

    Does the company have a DBA? If not, and you have absolutely no DBA experience, I would actually recommend that you turn that job offer down and suggest to them...

    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 16, 2010 at 1:57 pm

    #1134779

  • RE: Disk Failed

    823 is a hard IO error. SQL requested a read of the disk and the OS returned an error.

    Clustered?

    Is the disk available through windows?

    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 16, 2010 at 1:52 pm

    #1134777

  • RE: Stop, Don't Panic

    Steve Jones - Editor (3/16/2010)

    I've actually had to tell a VP to "go away" when I was managing. It was bad enough that I would go in to check on...

    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 16, 2010 at 1:47 pm

    #1134775

  • RE: Hourly backups + Weekly full = Overlap = problems???

    When restoring, you need full backup and all the log backups, starting with the first one after the full backup.

    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 16, 2010 at 1:46 pm

    #1134774

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