I've noticed several instances of what looks like a recursive insert with the format:
insert [dbo].[MyTable] select * from [dbo].[MyTable]
I've been able to show that it isn't in fact inserting rows reclusively, but the most likely thing it seems to be associated with is a Create Clustered Index operation. Unfortunately I can't correlate every incident of this back to an index create statement.
Does anyone know what SQL is doing here and why?
- This topic was modified 5 hours, 2 minutes ago by Leo.Miller.
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.