A "drop column" fix you will want for SQL Server 2012 / 2014
I caution about using DROP COLUMN without immediately rebuilding the table. Wasted space is a concern; data loss is worse.
Monthly Archive: April 2016
STRING_SPLIT() in SQL Server 2016 : Follow-Up #2
With additional tests comparing splitting techniques to TVPs, I round out my series on STRING_SPLIT() in SQL Server 2016.
Slide Decks & Demos from SQLintersection
I share slides and demos from his two SQL Intersection.
STRING_SPLIT() in SQL Server 2016 : Follow-Up #1
I follow up on a recent post about the performance of STRING_SPLIT() with a few additional reader-motivated tests.
Performance Surprises and Assumptions : DATEADD
I explore yet another scenario where a date/time function seems to cause the optimizer to behave unexpectedly.
#BackToBasics: Dating Responsibly
I give four quick tips on using date and time values effectively in SQL Server.
An Interview with Ken Van Hyning
Ken Van Hyning, Engineering Manager for SQL Server Client Tools, fields a few questions from yours truly.
What Might the SSMS Changes Mean to You?
After the first Visual Studio 2015-based SSMS build is released, I talk about changes you will notice, and changes you might not.
On Telemetry and Other Data Collected by SQL Server
I talk about some of the upcoming changes to telemetry and other privacy settings in SQL Server 2016.