email-935809 (8/10/2010)
I've noticed some blocking sessions caused by the following SQL but it's nowhere to be found in my SP's and Exe's. Anyone know what this is? Is it stats / indexes being rebuilt?insert [dbo].[CLIENT] select * from [dbo].[CLIENT] option (maxdop 1)
I know this is a very old post, I just had the same query execute on my server as wondering what it is? Is this Index rebuilding or mirroring? There aren't any duplicate records in the table and it is being called by the 'sa' user.