I just finished reading an excellent CSS article, How Simple Parameterization works, which is well written and well worth a look. In short, it outlines a customer performance issue caused by a change in the query plan – from parameterized to unparameterized – and a few considerations on resolving it. Concepts worth digging into that […]
Category: Tech and Learning
Be a Brilliant DBA
John Sanson (b|t) recently asked a bunch of us, “If you could give a DBA just one piece of advice, what would it be?” This post is my answer! This, and other articles like it, is available as a downloadable FREE e-book – DBA Jumpstart – at http://www.johnsansom.com/dba-jumpstart/ Grab your copy, and pass along the URL! “If you could […]
Compare tables to find missing rows
Let’s talk about the case where you want to compare tables to see what’s missing. We might be comparing a list of orders to an imported set of data in a staging table. Or, we’re identifying customers in the database that aren’t on the call list. Whatever the application, finding out the difference between one […]