I was watching an ESRI video called "Web Enabling Databases with ArcGIS for Server" and I thought I heard them say that SQL Geomety could be created on the fly in a view or in ESRI terms with a Query Layer.
Let me know if this is possible and more importantly, if there are some examples of doing so.
SELECT OBJECTID, Shape.STConvexHull() AS ShpConvexHull FROM [YOURCOMPUTERNAME\YOURDATABASENAME].YOURLAYERNAME
SELECT OBJECTID, Shape.STCentroid() AS ShpCentroid FROM [YOURCOMPUTERNAME\YOURDATABASENAME].YOURLAYERNAME
The principal problem with creating features on the fly is the inability to use a spatial index.
The draw performance is usually sufficiently awful that you'll be willing to jump through the
hoops necessary to have geometries added to the base table.
It's difficult to make 10k rows render slowly, but easy with 100k rows, and trivial with 1m.