Forum Replies Created

Viewing 15 posts - 38,866 through 38,880 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    David Burrows (5/27/2009)

    Lynn Pettis (5/27/2009)

    Here is another OMG moment.

    OK, hang on, I'll get my Ouija board and crystal ball :w00t:

    I have a tarot deck if you think that it 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

    May 27, 2009 at 8:46 am

    #1000684

  • RE: Are the posted questions getting worse?

    Roy Ernest (5/27/2009)

    I remember what my teacher told me when she first taught us about index. "Index works the same as index section in a book. It helps to go...

    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

    May 27, 2009 at 8:43 am

    #1000680

  • RE: Index on Foreign Key

    It might help, depends how the optimiser chooses to do the joins. Test some of your queries both ways and see.

    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

    May 27, 2009 at 8:26 am

    #1000651

  • RE: Are the posted questions getting worse?

    Lynn Pettis (5/27/2009)

    I've never written a book. What would be the process of doing a group project like this? I wouldn't mind assisting in some way to make...

    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

    May 27, 2009 at 8:07 am

    #1000624

  • RE: Are the posted questions getting worse?

    Grant Fritchey (5/27/2009)

    Actually, I do know of a publisher that tackles those specialized little books. They've put out one on Profiler and one on execution plans. I suspect they might...

    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

    May 27, 2009 at 7:55 am

    #1000605

  • RE: Performance tuning

    There's a book that Grant Fritchey wrote, not sure if it's still available electronically. Also you could take a look at my blog.

    http://sqlinthewild.co.za/index.php/2007/08/20/reading-execution-plans/

    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

    May 27, 2009 at 7:52 am

    #1000601

  • RE: READ UNCOMMITTED vs. NOLOCK

    NOLOCK/READ UNCOMMITTED only apply to selects. All data modifications will ignore that hint, they have to lock exclusive.

    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

    May 27, 2009 at 7:46 am

    #1000595

  • RE: Are the posted questions getting worse?

    Grant Fritchey (5/27/2009)

    Gail was still right. There is not a single source for detailed information about indexes and indexing. Certainly that kind of serious detail won't be found in my...

    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

    May 27, 2009 at 7:39 am

    #1000578

  • RE: Performance tuning

    narendra.pola (5/27/2009)

    What are the ways that can be done to improve

    Generally, change the queries to remove unnecessary operations and to allow them to use indexes effectivly and then tune...

    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

    May 27, 2009 at 7:31 am

    #1000571

  • RE: What Level of Normalization Would This Be?

    GDI Lord (5/27/2009)

    Me

    The benefits that I my boss can see with tbl_Users1 would be the schlep of looking up addresses would be avoided.

    However, I think that alternate/"out of town"...

    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

    May 27, 2009 at 6:38 am

    #1000524

  • RE: Are the posted questions getting worse?

    Florian Reischl (5/27/2009)

    Lynn Pettis (5/26/2009)

    OMG, you really have to be kidding here...

    Notice, more than 800 points.

    Lots and lots of questions.

    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

    May 27, 2009 at 3:33 am

    #1000432

  • RE: Index Selection- Query Optimizer

    This subject needs a good book.

    There are pieces in lots of places, but nothing that I've found that tells the complete indexing story in one place.

    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

    May 27, 2009 at 3:19 am

    #1000424

  • RE: Index Selection- Query Optimizer

    Paul White (5/27/2009)

    However, if a non-clustered index exists which covers the query completely, the optimizer will choose that - since the entire query can be resolved simply from the NC...

    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

    May 27, 2009 at 3:07 am

    #1000419

  • RE: Index Selection- Query Optimizer

    As far as I'm aware, yes. If an index is unique, mark it as unique.

    You may find this useful - http://sqlinthewild.co.za/index.php/2009/02/06/index-columns-selectivity-and-inequality-predicates/

    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

    May 27, 2009 at 2:33 am

    #1000403

  • RE: Index Selection- Query Optimizer

    wellygee (5/27/2009)

    This being the case i would expect the clustered index to satisfy the query more efficiently by itself instead of doing a further scan via the NC since 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

    May 27, 2009 at 1:59 am

    #1000391

Viewing 15 posts - 38,866 through 38,880 (of 49,552 total)