Forum Replies Created

Viewing 15 posts - 27,631 through 27,645 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    GSquared (2/21/2011)

    jcrawf02 (2/21/2011)

    Jeff Moden (2/21/2011)

    jcrawf02 (2/21/2011)

    Jeff Moden (2/21/2011)

    WayneS (2/20/2011)

    For those going to SQL Saturday #69 in Philly, I'll be presenting @ 2:15. I'm getting pretty excited about this!

    Click here for...

    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

    February 21, 2011 at 4:23 pm

    #1289648

  • RE: Enough memory to load entire DB?

    And also note that memory is required for other things than data pages. Plan cache, lock memory, thread stacks, token store, backup buffers, query grants, temp tables, work tables, etc,...

    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

    February 21, 2011 at 3:21 pm

    #1289633

  • RE: How to tune text queries

    AJ-636201 (2/21/2011)

    I have created only one clustered index and that is on FirstName column, and no other index has been created not even any non clustered index.

    That's not usually...

    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

    February 21, 2011 at 1:52 pm

    #1289604

  • RE: Are the posted questions getting worse?

    GSquared (2/21/2011)

    GilaMonster (2/21/2011)

    Jeff Moden (2/21/2011)

    Heh... no one even noticed recently... I slipped over the 24,000 post line, Gail topped 22,000 posts, and Gus has put the hammer on 10,000 posts.

    Now...

    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

    February 21, 2011 at 1:49 pm

    #1289603

  • RE: Why is my transaction log full?

    Slick84 (2/21/2011)

    It was just a question. I've seen that error before, I'll typically check the open trans and if/when the log was backed up.

    Which will only help you if...

    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

    February 21, 2011 at 1:48 pm

    #1289602

  • RE: Why is my transaction log full?

    Thanks everyone. Glad you're enjoying 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

    February 21, 2011 at 1:25 pm

    #1289594

  • RE: Are the posted questions getting worse?

    Jeff Moden (2/21/2011)

    Heh... no one even noticed recently... I slipped over the 24,000 post line, Gail topped 22,000 posts, and Gus has put the hammer on 10,000 posts.

    Now here's 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

    February 21, 2011 at 1:25 pm

    #1289593

  • RE: Why is my transaction log full?

    Slick84 (2/21/2011)

    Now.. how can I manually activate/deactivate VLF's within a transaction log?

    You can't. What are you trying to do?

    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

    February 21, 2011 at 1:23 pm

    #1289592

  • RE: tasks for dba in developer enviroments

    It's very, very rare for an entire database to move from development to production. More common, just new objects, just changes.

    The advice that Grant gave you earlier (http://www.sqlservercentral.com/Forums/FindPost1066900.aspx) applies

    P.S. 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

    February 21, 2011 at 10:40 am

    #1289503

  • RE: Are the posted questions getting worse?

    Grant Fritchey (2/21/2011)

    And this post makes 10,000 points. On to getting 10,000 posts.

    Congrats. Side effect of having a cushy job now? 😉 😀

    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

    February 21, 2011 at 8:00 am

    #1289436

  • RE: SSIS Script datetime conversion

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

    February 21, 2011 at 4:10 am

    #1289345

  • RE: Transaction Log Growing Despite Simple Recovery

    brainy (2/21/2011)

    What is the difference between minimally logged and fully logged. As per my knowledge, only the difference is, in minimally logged the the log will be reused after...

    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

    February 21, 2011 at 4:10 am

    #1289344

  • RE: sql server MCQs , at DBA level

    shiwani.plrs (2/21/2011)

    MCQ is

    Multiple choice questions

    So you want us to help you cheat on an exam? Or on an interview?

    If you're asking for questions and answers for the Microsoft certification...

    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

    February 21, 2011 at 2:23 am

    #1289321

  • RE: Problem in WITH

    WITH A AS (

    SELECT C1,C2,C3 FROM TABLE)

    SELECT *, COUNT(*) OVER ( PARTITION BY (SELECT 1)) AS TotalCount FROM 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

    February 21, 2011 at 2:16 am

    #1289317

  • RE: Transaction Log Growing Despite Simple Recovery

    brainy (2/21/2011)

    But most of the people will think bcp will not be logged where as a simple insert command will log, that's why bcp is fast and dont eat disk...

    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

    February 21, 2011 at 2:13 am

    #1289316

Viewing 15 posts - 27,631 through 27,645 (of 49,552 total)