• ChrisM@Work (3/5/2014)


    If the person looking at your query is a bogstandard TSQL developer, what would you expect them to know about index internals?

    Nothing. I have to assume that because I'm working with client after client with people at various levels. Is the developer who I taught index internals going to be there next month? Is he going to remember, when looking at the scripts I give him, details of internals? Is he going to be in a rush? Is he going to pass it off to the brand new junior? 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