Derik Hammer

Posts by: Derik Hammer

Query Cached Execution Plans

Often I need to examine an execution plan from a production server. Just as often, I can’t re-run the stored procedure in that environment. There are several techniques for simulating the environment on a test server such as exporting statistics…

You must just have the touch

Over the years, I’ve found my professional maturity to be a growing entity. One piece of evidence of this is how I react to being the most knowledgeable person in the room. Now, understand I’m not being arrogant, I mean, “the room,” literally. I…