Database Administrators

Excavator

 Excavator
Edit first post that was inactive for 6 months.
Awarded 1392 times.
SQL Install Fail - 2012 on Win11
Awarded Mar 27 at 4:25
I need to run VACUUM FULL with no available disk space
Awarded Mar 16 at 15:27
What is the best way to get a random ordering?
Awarded Mar 15 at 5:47
Long running VACUUM VERBOSE in Postgres 9.5 - how much time remaining?
Awarded Mar 15 at 5:47
Partitioning tables with foreign key MYSQL
Awarded Mar 9 at 4:27
How to manipulate join order of PostgreSQL optimizer?
Awarded Mar 3 at 4:18
how to update a property value of a jsonb field?
Awarded Feb 17 at 4:57
Why Sql Server management studio use English regional settings instead my local Windows settings?
Awarded Feb 11 at 0:26
Dump only the Stored Procedures in MySQL
Awarded Jan 31 at 4:03
Index max row size error
Awarded Jan 29 at 5:09
MySQL: How to create Column if not exists?
Awarded Jan 26 at 4:35
What are the differences between "Stored Procedures" and "Stored Functions"?
Awarded Jan 25 at 5:41
How to identify what is causing unusually high CPU load in MySQL?
Awarded Jan 25 at 5:41
How to install the additional module pg_trgm
Awarded Jan 23 at 4:43
How do I cleanup Postgres WAL?
Awarded Jan 13 at 5:16
MySQL DB import/export command line in Windows
Awarded Jan 8 at 6:22
how to update SSRS execution account automatically through powershell?
Awarded Jan 7 at 4:08
How to make mysqldump use /*!40101 SET character_set_client = utf8mb4 */;?
Awarded Jan 7 at 4:08
How can I get the actual data size per row in a SQL Server table?
Awarded Dec 30, 2022 at 4:34
When the primary key is also the foreign key, in Postgres
Awarded Dec 29, 2022 at 6:16
SQL Get Users By One Group But Exclude Others
Awarded Dec 24, 2022 at 5:05
PostgreSQL: How to create full copy of database schema in same database?
Awarded Dec 23, 2022 at 5:06
Error 1062: Duplicate entry 'mydb/regimes' for key 'name'
Awarded Dec 20, 2022 at 4:17
How to reduce the size of a SQL Server-Database?
Awarded Dec 20, 2022 at 4:17
Is it possible to remove a JSON array element by value in MySQL?
Awarded Dec 16, 2022 at 4:17
Update two tables, each on separate MySQL servers, on two different machines in one query?
Awarded Dec 15, 2022 at 15:18
How can I dump all tables to CSV for a PostgreSQL schema?
Awarded Dec 13, 2022 at 4:04
Why does a UNIQUE constraint allow only one NULL in SQL Server?
Awarded Dec 10, 2022 at 4:47
Combining GROUP BY and JOIN
Awarded Dec 9, 2022 at 5:02
How to find the count of words (all and unique) in a column row-wise?
Awarded Dec 9, 2022 at 5:02
Relational Model Design - Entity with one attribute
Awarded Dec 8, 2022 at 4:31
how to let dbeaver to highlight sql error for easier development process
Awarded Dec 1, 2022 at 4:42
ALTER DEFAULT PRIVILEGES - permission denied
Awarded Nov 30, 2022 at 4:50
Adding soft delete to a database after having used hard delete
Awarded Nov 25, 2022 at 4:27
How do I best measure the query performance?
Awarded Nov 17, 2022 at 4:42
Is the double dollar sign ($$) quotation method in SQL standard?
Awarded Nov 16, 2022 at 6:11
Why Does the Transaction Log Keep Growing or Run Out of Space?
Awarded Nov 15, 2022 at 4:15
Moving postgresql data to different drive
Awarded Nov 10, 2022 at 6:16
MariaDB Optimization - insert and select
Awarded Nov 10, 2022 at 6:16
Deleting old rows when a new one is added and there are more than 100 rows
Awarded Nov 9, 2022 at 4:05
Can I cluster PostgreSQL by sharing a data directory over NFS?
Awarded Nov 7, 2022 at 5:43
Should binary files be stored in the database?
Awarded Nov 7, 2022 at 5:43
Query "all of" across many-to-many relation
Awarded Nov 5, 2022 at 4:06
Postgres, benefit of named schema vs public schema?
Awarded Nov 4, 2022 at 4:25
MariaDB 10.3.9 can not start
Awarded Nov 2, 2022 at 4:11
How to change definition of a Postgres GENERATED (stored) column
Awarded Nov 1, 2022 at 4:16
sqlldr running slow after indexes created
Awarded Oct 23, 2022 at 4:15
MySQL general_log only shows a hex number instead of SQL?
Awarded Oct 17, 2022 at 4:11
How do I move SQL Server database files?
Awarded Oct 15, 2022 at 4:09
How to change data structure in mysql using mysqldump without deleting files
Awarded Oct 14, 2022 at 5:17
Constructing an SQL query with time intervals
Awarded Oct 2, 2022 at 4:06
Concerned about hitting max_connections with many IDLE State connections
Awarded Oct 1, 2022 at 5:26
TRY .. CATCH sometimes fails to catch PRIMARY KEY VIOLATION
Awarded Sep 28, 2022 at 4:56
Can MySQL reasonably perform queries on billions of rows?
Awarded Sep 14, 2022 at 5:02
which way is better to design shopping Cart Table - SQL Server
Awarded Sep 1, 2022 at 4:28
Which of these structures are good for maintaining historical data?
Awarded Aug 31, 2022 at 4:15
How to reclaim disk space on PostgreSQL?
Awarded Aug 26, 2022 at 4:47
Where can I find old versions of SQL Developer (4.x)?
Awarded Aug 19, 2022 at 4:37
How to speed up update join query between 2 mysql tables?
Awarded Aug 19, 2022 at 4:37
How to use postgresql variable in where clause
Awarded Aug 12, 2022 at 4:04
1
2 3 4 5
…
24

Your privacy

By clicking “Accept all cookies”, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy.