Merging Overlapping Date Ranges in SQL Server 2014

Can EXEC and Select Into Be Combined in SQL Server?

Optimizing Indexing Strategies for High-Density Tables: A Guide to PK and Columnstore Indexes