Yes, SSDT is installed - release number 17.4 (build 14.0.61712.050).  No, we cannot make the jump to VS2017.  Also, the link you posted takes me to a page about ALTER...

Thanks, yes, we've thoroughly checked all of this and no luck.  If we drop and recreate the same exact index, and then run the same exact MERGE statement with the...

Thanks - that certainly sounds a lot like my issue, but we're currently on SQL Server 2014 SP2 CU4 (12.0.5540.0)...

FWIW, if you are writing to clustered columnstore indexes while you see a spike in the RESERVED_MEMORY_ALLOCATION_EXT wait type, it could be an issue described here: https://orderbyselectnull.com/2018/03/06/large-cci-etls-cannot-scale-without-tf-834/

Hi, when I try to run the sql script, I get the following error: "Invalid object name 'sys.syscommittab'".  Any advice on how to get this working?

Hi Brad, 
No, the query isn't trying to select specific rows; it's aggregating data with some GROUP BY logic - it's a fact table in a data warehouse with 35M...

Thanks caffeinated - that's approach #3 in the original link I sent.  Unfortunately, it returns an approximate row count - it will not be exact, particularly for tables that have...

Hi Ed,
Thanks for the response.  The source tables all have clustered indexes.  I don't have a lot of flexibility when it comes to index tweaking on the source...

Thanks Sue and Jason.  We have 15,000 - 20,000 report runs per day, so the volume is pretty significant.  Our ETL runs several times per day.  The volume of data...

Thanks Sue. As far as I can tell, this is the order of operations after running "EXEC dbo.AddEvent @EventType = 'SharedSchedule' , @EventData = @ScheduleID;":

1. A single "shared...