Database Administrators

Help Center > Badges > Editor

 Editor
First edit.
Awarded 22335 times.
MySQL 8 is slower than MySQL 5.7
Awarded Feb 3 at 9:35
SQL Server database in Recovery mode, how to troubleshoot?
Awarded Feb 3 at 9:10
ERROR 1091 (42000): Can't DROP 'created_date'; check that column/key exists
Awarded Feb 3 at 6:15
How to “select * from table from database” with -e?
Awarded Feb 2 at 22:30
Does reordering table rows reduce the time for subsequent ordering with the ORDER BY clause?
Awarded Feb 2 at 12:35
Many to Many association table PK as FK in other table
Awarded Feb 2 at 10:45
Bigint and SQL Server performance
Awarded Feb 2 at 2:40
(post deleted or otherwise unavailable)
Awarded Feb 1 at 17:40
MySQL COUNT based on a condition [duplicate]
Awarded Feb 1 at 15:35
accelerating a SQL quadruple self-join with a complex alternation in the WHERE clause
Awarded Feb 1 at 13:20
(post deleted or otherwise unavailable)
Awarded Feb 1 at 10:50
(post deleted or otherwise unavailable)
Awarded Jan 31 at 20:35
MySQL database cluster vs. replication setup for large crawler indexes
Awarded Jan 31 at 18:25
Optimizing a user retention query
Awarded Jan 31 at 8:25
Shall I use enum when are too many “categories” with PostgreSQL?
Awarded Jan 30 at 22:25
Does amazon rds PostgreSQL require vacuum?
Awarded Jan 30 at 20:20
How to setup db credentials for `sqlcmd` using a config file?
Awarded Jan 30 at 15:25
Error while creating Extended Events on 2008 SQL Server
Awarded Jan 30 at 14:30
Postgres 10 - Query slows down with order by
Awarded Jan 30 at 13:10
Storing a very large matrix on Postgresql
Awarded Jan 30 at 12:25
FIll missing history records
Awarded Jan 30 at 11:40
MS SQL 2008 R2 - How to use a production database through dev/test environments or how to copy a SQL schema and all its data to another
Awarded Jan 30 at 9:55
adding and removing a node from a mongo replica set
Awarded Jan 30 at 8:45
Overwriting MySQL database to only store 1 month of data
Awarded Jan 30 at 3:40
Mysql Performance issue with millions rows and group by
Awarded Jan 29 at 20:20
Order by date then Group By by Name / Type before proceeding with the rest of results
Awarded Jan 29 at 18:15
How to stuff together earliest date and or text
Awarded Jan 29 at 17:40
Design ER with complicated relationships between different tables
Awarded Jan 29 at 17:20
Calculate start and end dates from a list of only start dates and partitioned
Awarded Jan 29 at 16:50
Delete relations efficiency in PostgreSQL [closed]
Awarded Jan 29 at 16:40
(post deleted or otherwise unavailable)
Awarded Jan 29 at 15:50
What is controlling SQL Server's page file usage? SQL Server or Windows?
Awarded Jan 29 at 14:30
Very slow DELETE in PostgreSQL, workaround?
Awarded Jan 29 at 14:20
Can multi indexing speed up “AND” of comparisons?
Awarded Jan 29 at 13:35
Unable to generate DDL statements using impdp 12c
Awarded Jan 29 at 1:05
(post deleted or otherwise unavailable)
Awarded Jan 28 at 18:35
How should I design a multi-purpose table?
Awarded Jan 28 at 17:45
MongoDB new secondary replica set node has much smaller data folder (dbPath)
Awarded Jan 28 at 13:15
(post deleted or otherwise unavailable)
Awarded Jan 28 at 12:40
Perform TABLESAMPLE with WHERE clause in PostgreSQL
Awarded Jan 28 at 12:15
Mongo E11000 duplicate key error collection after mongo 3.4 to 3.6 upgrade
Awarded Jan 28 at 11:40
SQL Server Insert Into - How to identify the column that is causing truncation error
Awarded Jan 28 at 10:50
Why do databases in mongodb have roles?
Awarded Jan 28 at 8:35
Fuzzystrmatch Postgresql similarity func with array
Awarded Jan 27 at 23:50
MariaDB 5.5 InnoDB keeps opening files up to 200k until system hangs
Awarded Jan 27 at 21:20
Readonly table permissions not applying to new tables
Awarded Jan 27 at 16:30
Is it possible to tell if a database has AUTOMATIC_TUNING switched on?
Awarded Jan 27 at 15:40
Freeze I/O on purpose like a vss snapshot
Awarded Jan 27 at 9:55
How can I connect to an Oracle Autonomous Data Warehouse with a 3rd party IDE (DataGrip)?
Awarded Jan 25 at 20:05
MySQL query of Hotel database [closed]
Awarded Jan 25 at 19:00
(post deleted or otherwise unavailable)
Awarded Jan 25 at 18:20
(post deleted or otherwise unavailable)
Awarded Jan 25 at 11:10
i want fetch json data in mysql [closed]
Awarded Jan 25 at 8:50
(post deleted or otherwise unavailable)
Awarded Jan 25 at 7:40
MariaDB REGEXP_REPLACE Invalid utf8 byte sequence
Awarded Jan 24 at 23:25
CMS - Database Schema Review / Questions [closed]
Awarded Jan 24 at 21:05
How to perform schema migration from array to many-to-many to lookup table?
Awarded Jan 24 at 20:25
error while importing data in MySQL workbench
Awarded Jan 24 at 20:00
Calculate size of the filtered rows of a table in sql server
Awarded Jan 24 at 14:55
What is the optimal configuration for MariaDB ? (CentOS 8, MariaDB 10.5)
Awarded Jan 24 at 10:00
1 2 3 4 5 … 373