Forum Replies Created

Viewing 15 posts - 29,356 through 29,370 (of 49,552 total)

  • RE: difference between index scan, index seek and table scan

    Or http://sqlinthewild.co.za/index.php/2007/11/15/execution-plan-operations-scans-and-seeks/

    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 15, 2010 at 10:30 pm

    #1251096

  • RE: Really? Then how? (Rant/Vent)

    David Lester (11/15/2010)

    Consultant, 'You know, you could stop out at a PC store, pick up a cheap laptop and run better than this server does'

    I've used that line...

    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 15, 2010 at 1:50 pm

    #1250981

  • RE: Burned Out?

    Craig Farrell (11/15/2010)

    The worst for me is emotional burnout. You're so busy doing ten million things you realize you haven't called your best friend in 6 months and your...

    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 15, 2010 at 1:49 pm

    #1250978

  • RE: 2 processors, 4 cores but 8 threads

    There's no single ideal setting for MAXDOP. This is one of those 'It Depends' scenarios. It depends what you're running.

    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 15, 2010 at 1:48 pm

    #1250976

  • RE: Is LogReader Agent required for Snapshot replication? -OR- My Crazy Transaction log issue.

    skrilla99 (11/15/2010)

    Could it be the snapshot agent that creates or marks the transaction(s) as replicated?

    No, transactions are marked as to-be-replicated when they're initially logged, if SQL thinks they're needed. It...

    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 15, 2010 at 1:38 pm

    #1250971

  • RE: Burned Out?

    WayneS (11/15/2010)

    The last time I had a major burn out phase, it took over 6 months.

    For me it was closer on 18 months, and I'm not sure it's over even...

    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 15, 2010 at 1:37 pm

    #1250968

  • RE: Burned Out?

    Jack Corbett (11/15/2010)

    I was actually counting on the Summit to get me going.

    Be careful. In Grant's case it may help, but in mine attending a conference just made things...

    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 15, 2010 at 1:32 pm

    #1250958

  • RE: Sql server went offline because of master DB

    sandhyarao49 (11/15/2010)

    "The SQL Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b, state: 3. Failure to register an SPN may cause...

    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 15, 2010 at 1:19 pm

    #1250948

  • RE: Burned Out?

    How have I, or how do I think (looking back) I should?

    i have a partially written blog post, just trying to decide if i want to expose that much....

    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 15, 2010 at 8:40 am

    #1250771

  • RE: If log file goes corrupt

    mohammed moinudheen (11/15/2010)

    But what if the log backup that you already have is showing as corrupt.

    Then point in time recovery is not possible right?

    If one of your log backups is...

    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 15, 2010 at 7:04 am

    #1250707

  • RE: Sql server went offline because of master DB

    sandhyarao49 (11/15/2010)

    Seems the database has been corrupted.

    Can you please help me to understand why the database has been corrupted.

    Yup. Probably something to do with the unexpected reboot. Likely something in...

    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 15, 2010 at 7:01 am

    #1250700

  • RE: If log file goes corrupt

    muthukkumaran (11/15/2010)

    If you database log file still online/accessible ,then you can take the tail of log and you can restore the PIT.

    Typically if the transaction log is corrupt, you cannot...

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

    #1250696

  • RE: Tempdb database will depend on the number of CPUs (logical or physical)

    Before you consider implementing that, read this: http://sqlskills.com/BLOGS/PAUL/post/A-SQL-Server-DBA-myth-a-day-(1230)-tempdb-should-always-have-one-data-file-per-processor-core.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

    November 15, 2010 at 6:53 am

    #1250692

  • RE: Sql server went offline because of master DB

    Restore your latest backup of master. Refer to Books Online for the proper procedure, it's not as simple as restoring as user database.

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

    #1250683

  • RE: If log file goes corrupt

    muthukkumaran (11/15/2010)

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

    Aaah. That link's for people how have stupidly deleted their transaction logs, not for a corrupt log.

    Often the best solution for a corrupt log is to restore from 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

    November 15, 2010 at 2:17 am

    #1250578

Viewing 15 posts - 29,356 through 29,370 (of 49,552 total)