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.
I caution about using DROP COLUMN without immediately rebuilding the table. Wasted space is a concern; data loss is worse.
With additional tests comparing splitting techniques to TVPs, I round out my series on STRING_SPLIT() in SQL Server 2016.
I share slides and demos from his two SQL Intersection.
I follow up on a recent post about the performance of STRING_SPLIT() with a few additional reader-motivated tests.
I explore yet another scenario where a date/time function seems to cause the optimizer to behave unexpectedly.
I give four quick tips on using date and time values effectively in SQL Server.
Ken Van Hyning, Engineering Manager for SQL Server Client Tools, fields a few questions from yours truly.
After the first Visual Studio 2015-based SSMS build is released, I talk about changes you will notice, and changes you might not.
I talk about some of the upcoming changes to telemetry and other privacy settings in SQL Server 2016.