POST
|
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
12-13-2019
01:05 PM
|
0
|
0
|
844
|
POST
|
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
12-13-2019
01:04 PM
|
0
|
0
|
844
|
POST
|
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
12-13-2019
12:58 PM
|
0
|
0
|
844
|
POST
|
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
12-13-2019
10:59 AM
|
0
|
4
|
844
|
POST
|
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
11-26-2019
02:40 PM
|
0
|
0
|
1029
|
POST
|
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
10-10-2019
10:54 AM
|
1
|
2
|
3370
|
POST
|
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
10-10-2019
10:52 AM
|
1
|
0
|
385
|
POST
|
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
10-10-2019
05:21 AM
|
0
|
0
|
820
|
POST
|
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
10-09-2019
05:17 AM
|
0
|
0
|
2250
|
POST
|
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
07-01-2019
05:17 AM
|
0
|
2
|
779
|
POST
|
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
06-20-2019
10:57 AM
|
1
|
0
|
617
|
POST
|
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
06-20-2019
05:51 AM
|
0
|
0
|
408
|
POST
|
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
05-24-2017
10:56 AM
|
0
|
1
|
1595
|
POST
|
We use spatail view all the time, for Desktop, Server, and Apps without issue. Are you the database admin ?
... View more
03-08-2017
05:27 AM
|
0
|
1
|
595
|
POST
|
hey kevin i created a new idea here https://community.esri.com/ideas/13187 if you wouldnt mind voting that would be greatly appreciated
... View more
03-03-2017
06:00 AM
|
0
|
0
|
1595
|
Title | Kudos | Posted |
---|---|---|
2 | 10-30-2020 05:28 AM | |
1 | 10-10-2019 10:54 AM | |
1 | 10-10-2019 10:52 AM | |
1 | 07-06-2020 05:27 AM | |
1 | 01-08-2020 05:24 AM |
Online Status |
Offline
|
Date Last Visited |
01-22-2024
04:18 PM
|