A new superpower for SQL query tuners – Number of Rows Read

There’s a technique that I’ve been using for some time now, and been looking for going even further back, which has become immediately available to everyone who can see a query plan (version permitting). Some years back (ok, it was 2010), I started to present at conferences about SARGability and residual predicates. I had a … Continue reading A new superpower for SQL query tuners – Number of Rows Read

Does the paradigm fit the environment?

This month we see the 73rd T-SQL Tuesday come around – six years were completed last month (the first was in December 2009), and this is the start of year seven. It’s hosted this month by Bradley Ball (@sqlballs), and he asks a question about whether our environments are naughty or nice. Now, I’m a … Continue reading Does the paradigm fit the environment?