How to approach performance tuning your SQL query

A question that I have been asked several times is how to go about performance tuning with your query. Let’s use a simple scenario here: a colleague comes to you and says, “I’ve written this query and its taking forever! Can you help?” How should you…

Searching Like a Pro

You are a consultant, solving problems is what you do.  If someone has a question you usually have an answer.  If you’re anything like me, though, the majority of those answers don’t just miraculously pop into your head. As a general rule, if your initial…