Latest Contributions by VinceAngelo

See the documentation for the 'sdeservice' command (Windows only). - V ... View more

Joins on real values are notorious for lack of reliability.  You might want to consider creating an integer factor (*100) or string equivalent, to take the floating point representation issues out of the equation. You can also gain significant performance benefit by using the SQL engine to drive the joins (in the database, vice in ArcGIS), mostly through the use of views.  Joins across databases are not supported; this even more true for joins across servers, but you can probably make this work if you initially create a table in the the local database, then after the app is working, rename the table and configure a foreign table reference in its stead.  Performance in this situation is often poor (vice local tables, due to the lack of indexes, caching, or optimizer configuration), and most folks usually wind up using some form of replication to push the foreign table into the local database as the long-term solution. - V ... View more

There are several issues here, but they all depend on your environment -- + Which operating system are you using? + Which database are you using? In general, the DBA (or SysAdmin) can change a lost password, but you need to make sure the service start-up utility (as appropriate to the OS) has the new password, or there will be trouble down the line. - V ... View more

To the best of my knowledge, there is no such standard.  This may be a reference to a *metadata* standard, but there are several of these as well. "The nice thing about standards is there are so many to choose from." - V ... View more

I did not assert that the combinarion was unsupported -- I started the sentence with "If". Please do not over-interpret what I write; I might be discouraged from writing at all. - V ... View more

You'd probably be better off asking the person who introduced the concept what they're talking about.  There are more "standards" than you can shake a stick at, but the odds of there being any one international standard for geodatabase creation, even in any one domain, seems awful slim. - V ... View more

IF you are using a user-schema geodatabase, and IF there are no other owners in that schema geodatabase, then you *should* be able to delete it safely. I haven't ever used a user-schema geodatabase, so don't know what other complications might be lurking. You should certianly have a full, tested backup of the database instance before attempting removal.  Good luck. - V ... View more

SDE.ST_GEOMETRY has consistently better performance than SDE_LOB.  You should evaluate the cost of moving to LOBs before deciding to do so. - V ... View more

I'm running on 32-bit RHEL 5.4 at home, and haven't had problems that couldn't be attributed to running on a six year old P4 host with only 2Gb RAM, but I'm not using 11.2.0.3.  If both Oracle and Esri don't support 5.4, then that should be a source of real concern. - V ... View more

That URL always has the current information (by definition). The support for newer patches of a certified release continues to be "assumed to work, unless otherwise noted."  It's unlikely that anyone at Esri will promise support for any release which has not been certified (certification tests are exhaustive and exhausting; they are not done lightly, and usually only on the reference OS available a year or more before the ArcGIS release date). - V ... View more

You should not touch the ArcSDE-managed tables in a user-schema geodatabase.  Instead, use the sdesetup utility to delete the geodatabase. - V ... View more

It *likely* will be in the same order, it might even *always* be, but it's not required. The issue is addition of new tables (removal too), where you'd get better performance if you *didn't* use this alphabetical model. I don't believe the dictionary tables are exposed (I've always gone on file size changes to determine which file corresponds to which table). In a replication model, only the changed *rows* would be transferred, not the files which contain changed rows (and their indexes).  This is where the real storage savings lives. - V ... View more

The file geodatabase filesystem model was never really intended for piecemeal distribution like this -- There are so many ways that this process could break down and corrupt the remote geodatabases that I can't recommend it. You might want to look into geodatabase replication or using the FileGDB API to transmit a custom set of change messages (though detecting the changes would not be easy). - V ... View more

If the connections are being terminated from the database side during a backup script, it's possible that a restart of the database is severing the connections. Are you sure you want TCPKEEPALIVE enabled?  It adds network overhead to the communication protocol to detect the difference between a quiet connection and a hung client, and terminates the connection when timeout is detected. - V ... View more

How does the query performance compare between the SQL prompt and through Query Layers? ArcSDE adds optimization based on layer metadata -- you might need to provide hints in your view to achieve equivalent optimization. - V ... View more