Dba Help

In PostGIS, how do I swap the lat/log of invalid points, like MySQL ST_SwapXY?

sql spatial postgis
Updated June 22, 2018 07:06 AM

Spatial Index on an InnoDB table

mysql index innodb myisam spatial
Updated June 22, 2018 06:06 AM

PostGIS radius query

sql postgresql spatial postgis
Updated June 22, 2018 06:06 AM

How do I render GeoHashes with PostgreSQL?

postgresql spatial postgis
Updated June 22, 2018 06:06 AM

How do I store spatial coordinates in SQL Server 2005

sql-server sql-server-2005 t-sql spatial
Updated June 22, 2018 06:06 AM

How does Yelp efficiently calculate distance in the database?

optimization mysql-5.5 relational-theory spatial
Updated June 22, 2018 06:06 AM

Installing pgAdmin4 :AttributeError: 'Babel' object has no attribute 'load_locale'

installation pgadmin-4
Updated June 22, 2018 03:06 AM

Triggers vs Views in MySQL

mysql trigger view
Updated June 22, 2018 03:06 AM

How does a linked server based select statement works in SQL Server?

sql-server linked-server
Updated June 22, 2018 03:06 AM

When will InnoDB support triggers on cascaded update/deletes with foreign keys?

mysql innodb mysql-5.5 trigger foreign-key
Updated June 22, 2018 03:06 AM

Deleting a Large Crashed MyISAM Table

mysql myisam
Updated June 22, 2018 03:06 AM

Latitude & longitude universal format

database-design migration datatypes
Updated June 22, 2018 03:06 AM

SQL Transaction Log Shipping Status Primary Server not Shown on Secondary Monitoring Server

sql-server sql-server-2012 log-shipping
Updated June 22, 2018 00:06 AM

Compare Two Columns, Remove Duplicate Characters

sql sqlite
Updated June 22, 2018 00:06 AM

Tableau and PostgreSQL

postgresql
Updated June 21, 2018 23:06 PM

Speed up the Postgres query with ORDER BY clause

postgresql query-performance postgresql-9.6
Updated June 21, 2018 23:06 PM

Read Committed Snapshot Isolation vs Read Committed - pros and cons?

sql-server isolation-level
Updated June 21, 2018 23:06 PM

What is the best solution to catch and alert me to run a FULL backup to shrink the nightly DIFF when it grows too big?

sql-server t-sql backup alerts
Updated June 21, 2018 23:06 PM

Portability of stored procedures between different vendors

sql-server stored-procedures migration aws cloud
Updated June 21, 2018 22:06 PM

Trying to extract data from multiple table and display the information quickly

sql
Updated June 21, 2018 22:06 PM

Showing Page 1 of 1698