The Most Underrated Features of SQL Server 2014 — Part 3


Guest Post by SQL Server Certified Master Warner Chaves


lb-chavez-290x290Hello everybody, my name is Warner Chaves, a SQL Server DBA for almost 10 years, MCM, and frequent community contributor. I currently work at Pythian and when speaking to many of our clients I frequently get asked to highlight for them some of the compelling reasons to upgrade to SQL 2014. In response to that, I created this 3 part series of the most underrated features in 2014 covering DelayedDurability, Parallel SELECT INTO, and New Partition Operations. Please comment, share opinions, or let me know of any other features that you would like to me to cover.

Check out parts 1 and 2 of this series.

In my final video in the series, I discuss SQL Server 2014’s parallel implementation of the SELECT INTO statement. In previous versions of SQL Server, it was always a one-threaded operation, using only one CPU—the new feature however, uses multiple threads. Learn common use cases and how to enable the new feature by watching my video The Most Underrated Features of SQL Server 2014 — Part 3 down below.


About Warner Chaves

Warner is a SQL Server Certified Master and a Principal Consultant at Pythian, a global Canadian-based company specialized in DBA services. After working for enterprise customers in Hewlett-Packard's ITO organization he transitioned to his current position at Pythian, managing multiple customers and instances while leading a highly talented team of SQL Server DBAs. When he's not working out of his office in Ottawa, Ontario he can be found in the sandy beaches of his home country of Costa Rica.

Twitter | Pythian BlogSQL Turbo Blog

Comments (0)

Skip to main content