Forum Replies Created

Viewing 15 posts - 33,346 through 33,360 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    Grant Fritchey (3/24/2010)

    Maybe a wider angle to the beams at the top & a bit more diffusion will take care of that.

    I'm thinking of angling them a bit more, moving...

    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, 2010 at 6:33 am

    #1138842

  • RE: Database is in recovery status.

    There should be entries in the SQL Server error log saying what's happening with the database and how long recovery will take. What's in the SQL error log?

    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, 2010 at 6:28 am

    #1138838

  • RE: Database is in recovery status.

    If you query sys.databases, what's the value for state_desc for this database? Recovering or restoring?

    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, 2010 at 5:57 am

    #1138814

  • RE: Are the posted questions getting worse?

    Changing the subject (if there is one), any art critics here?

    Been fiddling with this on and off for a couple years now. Initial idea was just the light from 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 23, 2010 at 10:40 pm

    #1138693

  • RE: missing_index_details inequality columns

    Index key.

    http://sqlinthewild.co.za/index.php/2009/02/06/index-columns-selectivity-and-inequality-predicates/

    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 23, 2010 at 10:37 pm

    #1138692

  • RE: Query Optimizer and "GoodEnoughPlanFound"

    The optimiser's job has never been to find the best plan. It's job is to find a good plan fast. To find the best plan, on anything other than 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 23, 2010 at 4:08 pm

    #1138593

  • RE: Are the posted questions getting worse?

    http://twitter.com/sqltech2 if you're interested in the 'defendant's' views/

    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 23, 2010 at 3:55 pm

    #1138588

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (3/23/2010)

    Alvin Ramard (3/23/2010)

    Waaaaahaaaaahaaaaahaaaa!!!!!

    ... and don't you dare copy

    In reference to?

    Probably this:

    http://www.brentozar.com/archive/2010/03/plagiarism-inspiration-and-john-dunleavy/

    http://itknowledgeexchange.techtarget.com/sql-server/todays-plagiarism-incident/

    http://itknowledgeexchange.techtarget.com/sql-server/plagiarism-inspiration-and-john-dunleavy-madder-and-more-pissed-off/

    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 23, 2010 at 3:49 pm

    #1138585

  • RE: SSIS Package just keeps on running, blkby -2

    Spid -2 is an orphaned distributed transaction. A distributed transaction that was cancelled improperly and SQL's left holding locks without knowing who they belong to.

    To kill that, query sys.dm_tran_locks. There's...

    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 23, 2010 at 2:55 pm

    #1138570

  • RE: The Missing Certification

    Jack Corbett (3/23/2010)

    Personally I think the certification debate ought to be a priority for the organization. Setting some kind of continuing education should be important as well. I'll 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

    March 23, 2010 at 2:50 pm

    #1138567

  • RE: Are the posted questions getting worse?

    GabyYYZ (3/23/2010)

    On a CV/Resume, would it be better to list your experiences first and then, at the end, list the cert(s), or flip the order and have the certs first,...

    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 23, 2010 at 9:51 am

    #1138349

  • RE: Are the posted questions getting worse?

    Paul White NZ (3/23/2010)

    CirquedeSQLeil (3/23/2010)

    Just making my way through the thread - but something tells me they at least know who Bart and Lisa are.

    Who?

    (now where's that new angelic emoticon?)

    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 23, 2010 at 9:48 am

    #1138345

  • RE: Are the posted questions getting worse?

    WayneS (3/23/2010)

    In MY experience, those people that go to college from high school, get a degree in an IT field (even a masters!), and then join the work force 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

    March 23, 2010 at 8:11 am

    #1138242

  • RE: Are the posted questions getting worse?

    WayneS (3/23/2010)

    That being said, employers are still impressed by having certifications. For that reason, I feel that all the denizons of the thread would benefit from being certified... that coupled...

    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 23, 2010 at 7:50 am

    #1138224

  • RE: Being Proactive Recovering Master Database

    How about attending to the root problem instead of just preparing for when it fails?

    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 23, 2010 at 6:40 am

    #1138156

Viewing 15 posts - 33,346 through 33,360 (of 49,552 total)