Latest Contributions by CraigSwadner

What does your compress log say for that database ? Craig Swadner (GIS Coordinator) City of Cape Coral 1015 Cultural Park Blvd. Cape Coral, Fl 33990 Did you know the best way to report issues to ITS is to use the Service Desk system? This will ensure someone in ITS gets your request and allows us to track the progress. Please enter all your issues and/or questions by clicking https://breeze.cape.capecoral.net ... View more

We have done this, its just a bit painful ,…. This can get you started https://desktop.arcgis.com/en/arcmap/10.3/manage-data/using-sql-with-gdbs/edit-versioned-data-using-sql-sqlserver.htm Craig Swadner (GIS Coordinator) City of Cape Coral 1015 Cultural Park Blvd. Cape Coral, Fl 33990 Did you know the best way to report issues to ITS is to use the Service Desk system? This will ensure someone in ITS gets your request and allows us to track the progress. Please enter all your issues and/or questions by clicking https://breeze.cape.capecoral.net ... View more

This happens sometimes also… https://www.mssqltips.com/sqlservertip/4801/sql-server-does-not-use-all-assigned-cpus-on-vm/ Craig Swadner (GIS Coordinator) City of Cape Coral 1015 Cultural Park Blvd. Cape Coral, Fl 33990 Did you know the best way to report issues to ITS is to use the Service Desk system? This will ensure someone in ITS gets your request and allows us to track the progress. Please enter all your issues and/or questions by clicking https://breeze.cape.capecoral.net ... View more

We modified this on our spatial database properties. Craig Swadner (GIS Coordinator) City of Cape Coral 1015 Cultural Park Blvd. Cape Coral, Fl 33990 Did you know the best way to report issues to ITS is to use the Service Desk system? This will ensure someone in ITS gets your request and allows us to track the progress. Please enter all your issues and/or questions by clicking https://breeze.cape.capecoral.net ... View more

You may check your compatibility settings ? I know when we went to sql 2017 we had to do some tweaks. Craig Swadner (GIS Coordinator) City of Cape Coral 1015 Cultural Park Blvd. Cape Coral, Fl 33990 Did you know the best way to report issues to ITS is to use the Service Desk system? This will ensure someone in ITS gets your request and allows us to track the progress. Please enter all your issues and/or questions by clicking https://breeze.cape.capecoral.net ... View more

If these are on different databases, have you ran the query though an analyzer ? Craig Swadner (GIS Coordinator) City of Cape Coral 1015 Cultural Park Blvd. Cape Coral, Fl 33990 Did you know the best way to report issues to ITS is to use the Service Desk system? This will ensure someone in ITS gets your request and allows us to track the progress. Please enter all your issues and/or questions by clicking https://breeze.cape.capecoral.net ... View more

Have you tried a select into statement? SELECT * INTO newtable FROM oldtable WHERE condition; Craig Swadner (GIS Coordinator) City of Cape Coral 1015 Cultural Park Blvd. Cape Coral, Fl 33990 Did you know the best way to report issues to ITS is to use the Service Desk system? This will ensure someone in ITS gets your request and allows us to track the progress. Please enter all your issues and/or questions by clicking https://breeze.cape.capecoral.net ... View more

I agree with George, if memory serves me correct (we have dozens of spatial views) 10.4 gave us issues also. Craig Swadner (GIS Coordinator) City of Cape Coral 1015 Cultural Park Blvd. Cape Coral, Fl 33990 Did you know the best way to report issues to ITS is to use the Service Desk system? This will ensure someone in ITS gets your request and allows us to track the progress. Please enter all your issues and/or questions by clicking https://breeze.cape.capecoral.net ... View more

You may want to have a meeting with everyone involved to determine your needs. One database may not be enough, in our environment we have a RO database for users / public to view and a RW database for users to edit. The edits are then synced every hour to the RO database. Every scenario requires different maintenance. Craig Swadner (GIS Coordinator) City of Cape Coral 1015 Cultural Park Blvd. Cape Coral, Fl 33990 Did you know the best way to report issues to ITS is to use the Service Desk system? This will ensure someone in ITS gets your request and allows us to track the progress. Please enter all your issues and/or questions by clicking https://breeze.cape.capecoral.net ... View more

This was useful to me, http://desktop.arcgis.com/en/arcmap/10.3/manage-data/using-sql-with-gdbs/edit-versioned-data-using-sql-sqlserver.htm Craig Swadner (GIS Coordinator) City of Cape Coral 1015 Cultural Park Blvd. Cape Coral, Fl 33990 Did you know the best way to report issues to ITS is to use the Service Desk system? This will ensure someone in ITS gets your request and allows us to track the progress. Please enter all your issues and/or questions by clicking https://breeze.cape.capecoral.net ... View more

When was the last time you did a full compress ? Craig Swadner (GIS Coordinator) City of Cape Coral 1015 Cultural Park Blvd. Cape Coral, Fl 33990 Did you know the best way to report issues to ITS is to use the Service Desk system? This will ensure someone in ITS gets your request and allows us to track the progress. Please enter all your issues and/or questions by clicking https://breeze.cape.capecoral.net ... View more

Attach the View code… Craig Swadner (GIS Coordinator) City of Cape Coral 1015 Cultural Park Blvd. Cape Coral, Fl 33990 Did you know the best way to report issues to ITS is to use the Service Desk system? This will ensure someone in ITS gets your request and allows us to track the progress. Please enter all your issues and/or questions by clicking https://breeze.cape.capecoral.net ... View more

Or you could create an ssrs report and email them a report. This is what we do… Craig Swadner (GIS Coordinator) City of Cape Coral 1015 Cultural Park Blvd. Cape Coral, Fl 33990 Did you know the best way to report issues to ITS is to use the Service Desk system? This will ensure someone in ITS gets your request and allows us to track the progress. Please enter all your issues and/or questions by clicking https://breeze.cape.capecoral.net ... View more

What is your CRM ? theoretically if data is in a modern database ie sql, oracle, Informix etc you should be able to see information in a spatial view. We do this here at the City. Craig Swadner (GIS Coordinator) City of Cape Coral 1015 Cultural Park Blvd. Cape Coral, Fl 33990 Did you know the best way to report issues to ITS is to use the Service Desk system? This will ensure someone in ITS gets your request and allows us to track the progress. Please enter all your issues and/or questions by clicking https://breeze.cape.capecoral.net ... View more

i have the same script and have shared it with others, however sometimes it works and other times it does not.  With no changes on our side, it just leads me to one conclusion..... ... View more