Forum Replies Created

Viewing 15 posts - 30,256 through 30,270 (of 49,552 total)

  • RE: How to stop this message in SQL Server Logs : FILESTREAM: effective level = 0...........

    It should only appear either when SQL starts up or when the database is opened. Can't recall which. Maybe a database with filestream has autoclose on and is repeatedly getting...

    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 1, 2010 at 10:39 am

    #1230370

  • RE: How can you see the Recovery Model?

    SwayneBell (10/1/2010)

    See my 'RAID is not a backup' comments. In that case, your recovery plan is not worth the virtual paper it is printed on. If the log fails (corrupted)...

    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 1, 2010 at 10:31 am

    #1230364

  • RE: Race to post 1,000,000

    Could be from accounts that Steve has deleted from time to time.

    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 1, 2010 at 10:11 am

    #1230341

  • RE: Help with 250 million row table and Suspect mode

    Best bet - drop the database and restore from backup (make space, get an external drive if necessary)

    There's no way to manually drop the damaged pages, that's what checkDB 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

    October 1, 2010 at 9:31 am

    #1230313

  • RE: How can you see the Recovery Model?

    SwayneBell (10/1/2010)

    Hi Gail;

    Yes, the logs are mirrored with RAID 1.

    See my 'RAID is not a backup' comments. In that case, your recovery plan is not worth the virtual paper 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

    October 1, 2010 at 9:16 am

    #1230302

  • RE: Are the posted questions getting worse?

    jcrawf02 (10/1/2010)

    GilaMonster (10/1/2010)

    Craig Farrell (9/30/2010)

    GilaMonster (9/30/2010)

    What's Sanctuary?

    Fun Monsters and Mayhem Sci Fi TV show set in modern day.

    Hmmm... Must see if I can track that down locally.

    http://www.hulu.com/sanctuary

    Key word there being...

    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 1, 2010 at 9:14 am

    #1230300

  • RE: attach database error

    DTS (deprecated and shouldn't be used any more), SSIS, BCP, import/export wizard. All about the same.

    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 1, 2010 at 9:11 am

    #1230295

  • RE: Help using the Transfer Jobs task

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

    October 1, 2010 at 5:02 am

    #1230107

  • RE: Are the posted questions getting worse?

    Craig Farrell (9/30/2010)

    GilaMonster (9/30/2010)

    What's Sanctuary?

    Fun Monsters and Mayhem Sci Fi TV show set in modern day.

    Hmmm... Must see if I can track that down locally.

    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 1, 2010 at 2:24 am

    #1230081

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (9/30/2010)

    GilaMonster (9/30/2010)

    The problem is what he's mapping out in the project plan is actual elapsed time, not time spent on his project. Since neither developer is full time (both...

    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 1, 2010 at 2:22 am

    #1230076

  • RE: Replication monitoring

    Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic996423-291-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

    October 1, 2010 at 2:12 am

    #1230070

  • RE: Using several insert into statements in a stored procedure

    Cath Trimble (10/1/2010)

    GO is a batch separator, so your SP is only executing up to the end of the first INSERT. Remove all but the final GO and you'll...

    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 1, 2010 at 2:10 am

    #1230069

  • RE: Get the page number of a certain record to where it is included

    There's an undocumented feature or two.

    I do have to ask though. Why?

    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 1, 2010 at 2:07 am

    #1230067

  • RE: Commit, Checkpoint and Truncate.

    For commit and checkpoint the links I've given you should do. For the last, google "backup log" "truncate only" and I'm sure you'll have more reading than you'll need.

    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 1, 2010 at 1:56 am

    #1230063

  • RE: Are the posted questions getting worse?

    The problem is what he's mapping out in the project plan is actual elapsed time, not time spent on his project. Since neither developer is full time (both consultants) 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

    September 30, 2010 at 3:30 pm

    #1229953

Viewing 15 posts - 30,256 through 30,270 (of 49,552 total)