Forum Replies Created

Viewing 15 posts - 38,176 through 38,190 (of 49,552 total)

  • RE: Trusting Online

    Gaby Abed (6/25/2009)

    I can only imagine the discussions that Paul and his wife, Kimberly Tripp[/url], have when they catch each other's mistakes, rare as they may be. Eventually will...

    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

    June 25, 2009 at 12:16 pm

    #1015530

  • RE: Responding to Email Received Through the Board

    Not that I'm aware. Maybe ask Steve to do a query against the DB.

    I've asked that the username be included for exactly this reason. Personally, unless the email comes from...

    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

    June 25, 2009 at 11:55 am

    #1015517

  • RE: Failed BackUp

    Ah, that's what I was suspecting. BackupExec has been noted in the past to cause exactly this problem - error saying that no full backup available, even though one's been...

    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

    June 25, 2009 at 11:52 am

    #1015514

  • RE: Tlog space can't be reused

    nscott (6/25/2009)

    P.S. I went into the properties of the main DB in question and set the tlog to unrestricted. But when I went back in to view the properties,...

    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

    June 25, 2009 at 11:33 am

    #1015504

  • RE: Failed BackUp

    Tom Breit (6/25/2009)

    No, I haven't tried running the command in t-sql.

    In fact, looking at the error message in the history says 'cannot perform a differential backup... because a current...

    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

    June 25, 2009 at 11:31 am

    #1015501

  • RE: Simple SQL Grouping Question

    To do that you need a calendar table, one that has all the months in it. Then join the tables together (left join) and group.

    Edit: And you're probably going to...

    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

    June 25, 2009 at 11:30 am

    #1015497

  • RE: Are the posted questions getting worse?

    Florian Reischl (6/25/2009)

    @Gail

    Somebody has stolen your name. There is another "GilaMonster" on Twitter. Apparently it's not you if your second name isn't "Tim" with a Dutch homepage...

    Yeah, I know. 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

    June 25, 2009 at 10:55 am

    #1015463

  • RE: Advantagess/Disadvantages of "INCLUDE" on Index

    Take DTA's recommendations with a large pinch of salt. It tends to suggest wide indexes and way too many of them. I've seen it before now suggest 3 indexes 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

    June 25, 2009 at 10:25 am

    #1015443

  • RE: Index Usage Question

    Tim Walker (6/25/2009)

    Hey Gail, do you know what would happen if one index was narrower but fragmented so actually occupied more pages than a wider one? Which would be chosen...

    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

    June 25, 2009 at 10:21 am

    #1015436

  • RE: Differential backup

    Jus (6/25/2009)

    No. my question was......If you take the differential back up second time after the full backup, will it (second differential backup file) be holding the data changed after 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

    June 25, 2009 at 10:03 am

    #1015420

  • RE: Are the posted questions getting worse?

    Grant Fritchey (6/25/2009)

    Miracles can happen.

    Indeed, and SA's through to the quarter finals which is nearly as astonishing. Our local team's been playing so poorly lately.

    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

    June 25, 2009 at 10:02 am

    #1015419

  • RE: Why Cursors so bad

    Grant Fritchey (6/25/2009)

    Oooh. That's a good one.

    I'd give credit, but I have no recollection who initially said 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

    June 25, 2009 at 10:01 am

    #1015415

  • RE: WHY CHECK CONSTRINT IS NOT WORKING

    saidwarak01 (6/25/2009)

    My simple advise to moderators is any kind of post whether it is simple or tuff. It should be properly handled by giving some solution.

    And it has...

    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

    June 25, 2009 at 9:50 am

    #1015410

  • RE: Why Cursors so bad

    Grant Fritchey (6/25/2009)

    Cursors operate on each row, one at a time. SQL is a set based language designed to work on blocks of data. Which is faster, one thing at...

    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

    June 25, 2009 at 9:44 am

    #1015402

  • RE: Index Usage Question

    GDI Lord (6/25/2009)

    IWhy would it use IX_Tmp_bob_pkColB if I haven't included any reference/data/information about pkColA in it? ("RTFM on covering indices!"?)

    As I mentioned earlier, the clustering key is always part...

    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

    June 25, 2009 at 9:42 am

    #1015401

Viewing 15 posts - 38,176 through 38,190 (of 49,552 total)