I have the following query:
Insert into PropertyTractsTemp
P.field1 as field1 ,
P.field2 as field2,
P.field3 as field3,
P.field4 as field4,
P.field5 as field5
from PROPERTY_PARAMETERS P
join BH_EDW.dbo.REF_GEOID_GEOG G WITH(INDEX([geog_sidx]))on G.geom.STIntersects(P.GeoLocation) =1
where P.GEOID is null
This may have 1,000 to 100Mil records to match up.
Either way, the query stops and I receive this error:
Msg 10316, Level 16, State 1, Line 3
The app domain with specified version id (4) was unloaded due to memory pressure and could not be found.
The statement has been terminated.
I'm told it's a CLR error, and it has something to do with the spatial index but no explanation on how to troubleshoot it.
Any wisdom would be greatly appreciated.