This might help others using MSSQL 2008.
(Our problems revolved around very slow snapping, measure tool and any queries)
The SQL Spatial types have impaired our performance greatly. When running the same problematic features as SDEBinary, in the same Dataset, our performance issues are gone. Is this a fix for all using MSSQL 2008? I can't say that for sure, but it definitely has made a big difference on our data.
If you are running a similar setup. Simply copy and paste a feature into the same Dataset, and change the keyword to SDEBinary. If you don't see SDEBinary, you may be setup where the Binary option is your default. You could check DBTune to see the default "GEOMETRY_STORAGE", ours is set to "GEOMETRY".
Good luck.
This was also the solution for us, thanks!!! We have SQL 2008 R2 and ArcGIS 10.3.1. I did just loke Kevin mentioned, copied and pasted the feature classes into the same dataset, and changed the keyword to SDEBINARY. Then I deleted the old feature classes, renamed the new ones. I also used the batch create spatial indexes since those were gone, but the attribute indexes copied over fine.
I also noticed that this improved the performance when SELECTING features, especially annotation.
David
Just installed 10.2 and I am experiencing snapping problems also. Snapping works fine unless I try to snap to a layer that is joined to a table. Is anyone experiencing the same problem? Is there a solution besides 'unjoining' the table?
I am also seeing issues with snapping to any layer that is joined to a table in ArcMap 10.2. Removing the join makes snapping to that layer work again, and adding a join to any layer disables snapping to that layer.
I am having same issues, if I have a layer with a table join, snapping does not work, but once join is removed it works fine.
Very annoying to have to add and remove constantly.
Snapping does not work for me either. I am on 10.2.2.