July 2016
T-SQL Tuesday #80: CREATE OR REPLACE

I submit a wish list item for the 80th T-SQL Tuesday: CREATE OR REPLACE, a cleaner way to deploy objects without losing permissions.

Paying attention to estimates

I follow up on a recent post about DATEFROMPARTS() with a deeper look into the estimates and potential mitigation techniques.

#BackToBasics: DATEFROMPARTS

I continue my #EntryLevel challenge, discussing DATEFROMPARTS() and similar functions introduced in SQL Server 2012.