Forum Replies Created

Viewing 15 posts - 29,131 through 29,145 (of 49,552 total)

  • RE: Needed SQL DBA's (multiple positions contract/Full Time)

    Craig Farrell (11/29/2010)

    GilaMonster (11/29/2010)

    Craig Farrell (11/29/2010)

    Contracting usually tops out between $60-$75/hour (for the consultant via a consulting firm, corp to corp independents are a whole different set of rules)

    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 29, 2010 at 12:13 pm

    #1256425

  • RE: Detect Corrupt Statistics - Is there a way?

    Ninja's_RGR'us (11/29/2010)

    GilaMonster (11/29/2010)

    I've seen corrupt stats on SQL 2000, but that's because on SQL 2000 the stats were stored in an image column in sysindexes. Never seen on 2005+. I'd...

    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 29, 2010 at 11:41 am

    #1256405

  • RE: Needed SQL DBA's (multiple positions contract/Full Time)

    Craig Farrell (11/29/2010)

    Contracting usually tops out between $60-$75/hour (for the consultant via a consulting firm, corp to corp independents are a whole different set of rules)

    I bill $100/hour, 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 29, 2010 at 11:35 am

    #1256402

  • RE: Detect Corrupt Statistics - Is there a way?

    I've seen corrupt stats on SQL 2000, but that's because on SQL 2000 the stats were stored in an image column in sysindexes. Never seen on 2005+. I'd start by...

    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 29, 2010 at 11:30 am

    #1256397

  • RE: DBCC error

    You have got some *serious* problems with that IO subsystem. Get some diagnostic done and problems fixed or get the databases onto other storage. Quickly.

    Make sure no one is using...

    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 29, 2010 at 11:24 am

    #1256392

  • RE: Are the posted questions getting worse?

    Alvin Ramard (11/29/2010)

    It's time for the business owners to try and figure out what they forgot in the requirements.

    What requirements?

    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 29, 2010 at 10:52 am

    #1256364

  • RE: Needed SQL DBA's (multiple positions contract/Full Time)

    ram 71135 (11/25/2010)

    Qualifications and Education Requirements

    * Bachelor*s degree

    * 8+ years Database Administration experience

    * 8+ combined years experience in

    Well that would rule me out (were it even possible for me...

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

    #1256363

  • RE: Analysing dm_db_index_physical_stats result.

    Can you rerun the query and include the page count in there? record_count, ghost_record_count and fragment_count not needed.

    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 29, 2010 at 10:46 am

    #1256359

  • RE: Are the posted questions getting worse?

    Craig Farrell (11/29/2010)

    "Sir, we're screwed, the contractor was right!"

    "Well, under all that's holy don't let THEM know that, peon!"

    "Of course sir, we've made it a 'vague managemental decision'."

    "Good peon. ...

    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 29, 2010 at 10:45 am

    #1256358

  • RE: Need to bring db online (db offline) log missing and no backups.

    You can hack it in. You will likely lose data, you may even end up with an unusable database.

    http://sqlinthewild.co.za/index.php/2009/06/09/deleting-the-transaction-log/

    How come no backups? Someone not doing their job.

    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 29, 2010 at 10:43 am

    #1256355

  • RE: Execution Plan -- Clustered Index Update

    Please note: Almost 2 year old thread.

    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 29, 2010 at 10:38 am

    #1256349

  • RE: DBCC

    Ninja's_RGR'us (11/29/2010)

    And then again this is usefull only before doing something about the problem at end in a scheduled job...

    Or maybe when trying to diagnose the reason for poor...

    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 29, 2010 at 8:22 am

    #1256287

  • RE: receiving error message Error: 701, Severity: 17, State: 123.

    Please post new questions in a new thread. Thank 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

    November 29, 2010 at 8:12 am

    #1256283

  • RE: DBCC

    Ninja's_RGR'us (11/29/2010)

    GilaMonster (11/29/2010)

    Which DBCC commands and what's the reasoning behind this?

    I just hope it's not about shrinking ;-).

    🙂

    Not too many DBCC commands that I could think would be really useful...

    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 29, 2010 at 8:05 am

    #1256276

  • RE: DBCC

    Which DBCC commands and what's the reasoning behind 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

    November 29, 2010 at 7:56 am

    #1256267

Viewing 15 posts - 29,131 through 29,145 (of 49,552 total)