Guest Post by SQL Server Certified Master Warner Chaves
Hello 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.
In this second video in the series, I discuss the significance of New Partition Operations, which make online index rebuilds and incremental statistics much more efficient. “For many clients, it was really hard to find maintenance windows that were big enough to actually rebuild the entire set [of partition tables] when they had fragmentation issues. 2014 now has online index rebuild on a partition level.” In this video, The Most Underrated Features of SQL Server 2014 — Part 2, you’ll hear use cases for new partition operations and learn why incremental statistics are more efficient.
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.