Forum Replies Created

Viewing 15 posts - 29,971 through 29,985 (of 49,552 total)

  • RE: DB Crash / Bad LDF file

    mattwilson247 (10/14/2010)

    The transaction log is bad so I can't re-build from it. I have a good MDF file though.

    Did you try Paul's suggestion?

    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

    October 14, 2010 at 10:44 am

    #1237044

  • RE: MSDB in a Cluster

    In a clustered environment, all SQL databases and any other resources it needs must be on shared drives (drives visible to both cluster nodes)

    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

    October 14, 2010 at 10:42 am

    #1237043

  • RE: Shrink database

    Why do you want to shrink? Databases tend to grow as more data gets put in them. It's in their nature.

    Shrinking causes massive fragmentation and will just result in 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

    October 14, 2010 at 10:39 am

    #1237039

  • RE: Update Statistics Maint.plan Job

    ravz.sqldba (10/14/2010)

    Now I have issue with Update Statistics is taking to long to complete

    as mentioned in my 1st post.

    Since it's running after the index rebuild, make sure that (if it'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

    October 14, 2010 at 10:38 am

    #1237038

  • RE: Update Statistics Maint.plan Job

    Well there's no difference which way around providing you don't have the stats update update the index statistics.

    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

    October 14, 2010 at 6:13 am

    #1236763

  • RE: Update Statistics Maint.plan Job

    MindOptimizer (10/14/2010)

    GilaMonster (10/14/2010)

    Since it's running after an index rebuild, you only need to update column statistics, not index statistics.

    Will it get benefit, if we go for first "update statistics"...

    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

    October 14, 2010 at 5:52 am

    #1236750

  • RE: Update Statistics Maint.plan Job

    Since it's running after an index rebuild, you only need to update column statistics, not index statistics.

    Shouldn't be running that long, I've had TB size databases where the stats update...

    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

    October 14, 2010 at 5:36 am

    #1236739

  • RE: DBCC issue

    ps. (10/14/2010)

    No. DBCC is scheduled on a daily basis. Since we support several hundred servers, its not feasible to login manually and check on each server.

    What????

    Whoever said anything about 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

    October 14, 2010 at 3:52 am

    #1236709

  • RE: DBCC issue

    Edit: Dup

    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

    October 14, 2010 at 3:36 am

    #1236704

  • RE: DBCC issue

    ps. (10/14/2010)

    I cannot find who altered the objects in 2000 coz this was migrated a year back. doubt we have trace information for that period. need to check. we 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

    October 14, 2010 at 3:35 am

    #1236702

  • RE: Are the posted questions getting worse?

    Craig Farrell (10/14/2010)

    I'd be hanging up my 'despair poster a day' calendar.

    You mean like this?

    That's a photo of part of my study at home. If it's not clear, 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

    October 14, 2010 at 3:26 am

    #1236698

  • RE: DBCC issue

    ps. (10/14/2010)

    So i need to script out the SPs/Views/Functions, drop them and recreate them. Am i right?

    Script them and their permissions, drop and recreate.

    Once done, run checkDB again, 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

    October 14, 2010 at 3:25 am

    #1236697

  • RE: Are the posted questions getting worse?

    ALZDBA (10/14/2010)

    GilaMonster (10/14/2010)

    ... *hopeful* *optimistic* ...

    DBA-part taking over :w00t:

    Developer-side. My DBA side is extraordinarily pessimistic

    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

    October 14, 2010 at 3:15 am

    #1236691

  • RE: Are the posted questions getting worse?

    *Dupe*

    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

    October 14, 2010 at 3:06 am

    #1236687

  • RE: Are the posted questions getting worse?

    GilaMonster (10/13/2010)

    Not from here, but how's this one:

    http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=151492

    Background is that he mailed me twice within 10 min, subject line 'Answer this' and just a link to that thread.

    Update:

    He apparently made...

    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

    October 14, 2010 at 2:42 am

    #1236680

Viewing 15 posts - 29,971 through 29,985 (of 49,552 total)