I have a client with data that is currently in a State Plane coordinate system. They are looking to store this data in SQL Server 2008R2.
SQL does not "support" the SRID for the State Plane in question.
I've seen some people suggesting using geometry instead of geography for storing State Plane data.
I also know that I could convert the State Plane data over to WGS84 if necessary.
What I'm wondering is what's the "best" way to store State Plane data in SQL 2008R2?