Just an FYI for those of you on SQL Server 2014 SP2 that there is a new CU available for download can can be found here. Also if you are still on SP1 for SQL Server 2014 you can get CU10 as well here. https://www.microsoft.com/en-us/download/details.aspx?id=51186 There are a number of interesting fixes but one in particular that has caused issues for me is described in this KB here. It is when statistics are blown away when you rebuild a partition on a partition aligned index. I for one am happy to see this finally fixed but there are many more. Check them out and happy updating.