Monthly Archives: May 2017

Optimization Smarts! Join Simplification

Someone recently read a post by Erik Darling over at BrentOzar.com titled Is it ever worth adding indexes to table variables.  They were a little confused by the post and asked me about it. I thought I would break it...
Continue Reading →

Idempotent statements

Idempotent statements are those where applying the statement multiple times yields the same result. Commonly in database development this is significant during deployment activities. If we create a new table the deployment script will merely have the CREATE TABLE syntax....
Continue Reading →

SSIS Package Parts First Impressions

Reading the way package parts were described in the SQL 2016 release notes I was pretty excited. I remember having hundreds of SSIS packages where the overall structure was fairly redundant, this was before BIML was a thing, and package...
Continue Reading →

Planning Upgrades, Migrations, Consolidations.. SQL and more

Steve Jones posted a good editorial a month or so ago about why he typically prefers side-by-side migrations over in-place upgrades. If you are running virtualized and want to upgrade in-place then it is not horrendous if you need to revert back...
Continue Reading →