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......
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......
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......
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......