I have to change a default storage type of SDE 10.1 on SQLServer 2008 R2. 1. How can I do it? 2. Is it enough to update ONLY ONE row (field config_string)(GEOMETRY->SDEBINARY) in dbo.SDE_dbtune table (where keyword='DEFAULTS' and parameter_name='GEOMETRY_STORAGE')?
The 'sdedbtune' utility will upload a DBTUNE file into a database, but you can update the GEOMETRY_STORAGE key using SQL as well. The GEOMETRY type is a bit quirky, but it's also usually faster than the 3-table SDEBINARY format.