topic How to change default storage type SDE 10.1 on SQLServer 2008 R2? in Data Management Questions https://community.esri.com/t5/data-management-questions/how-to-change-default-storage-type-sde-10-1-on/m-p/234951#M13339 <HTML><HEAD></HEAD><BODY><SPAN>I have to change a default storage type of SDE 10.1 on SQLServer 2008 R2.</SPAN><BR /><SPAN>1. How can I do it?</SPAN><BR /><SPAN>2. Is it enough to update ONLY ONE row (field config_string)(GEOMETRY-&gt;SDEBINARY) in dbo.SDE_dbtune table (where keyword='DEFAULTS' and parameter_name='GEOMETRY_STORAGE')?</SPAN><BR /><BR /><SPAN>Any ideas would be appreciated.</SPAN></BODY></HTML> Thu, 06 Feb 2014 04:55:44 GMT MarkMindlin 2014-02-06T04:55:44Z How to change default storage type SDE 10.1 on SQLServer 2008 R2? https://community.esri.com/t5/data-management-questions/how-to-change-default-storage-type-sde-10-1-on/m-p/234951#M13339 <HTML><HEAD></HEAD><BODY><SPAN>I have to change a default storage type of SDE 10.1 on SQLServer 2008 R2.</SPAN><BR /><SPAN>1. How can I do it?</SPAN><BR /><SPAN>2. Is it enough to update ONLY ONE row (field config_string)(GEOMETRY-&gt;SDEBINARY) in dbo.SDE_dbtune table (where keyword='DEFAULTS' and parameter_name='GEOMETRY_STORAGE')?</SPAN><BR /><BR /><SPAN>Any ideas would be appreciated.</SPAN></BODY></HTML> Thu, 06 Feb 2014 04:55:44 GMT https://community.esri.com/t5/data-management-questions/how-to-change-default-storage-type-sde-10-1-on/m-p/234951#M13339 MarkMindlin 2014-02-06T04:55:44Z Re: How to change default storage type SDE 10.1 on SQLServer 2008 R2? https://community.esri.com/t5/data-management-questions/how-to-change-default-storage-type-sde-10-1-on/m-p/234952#M13340 <HTML><HEAD></HEAD><BODY><SPAN>The 'sdedbtune' utility will upload a DBTUNE file into a database, but you can update the</SPAN><BR /><SPAN>GEOMETRY_STORAGE key using SQL as well.&nbsp; The GEOMETRY type is a bit quirky, but</SPAN><BR /><SPAN>it's also usually faster than the 3-table SDEBINARY format.</SPAN><BR /><BR /><SPAN>- V</SPAN></BODY></HTML> Thu, 06 Feb 2014 10:36:08 GMT https://community.esri.com/t5/data-management-questions/how-to-change-default-storage-type-sde-10-1-on/m-p/234952#M13340 VinceAngelo 2014-02-06T10:36:08Z