Database Administrators

Good Answer

 Good Answer
Answer score of 25 or more. This badge can be awarded multiple times.
Awarded 1480 times.
restoring Postgres database: pg_restore -vs- just using psql
Awarded Jan 3, 2021 at 7:08
Postgres error [column must appear in the GROUP BY clause or be used in an aggregate function] when sub query is used
Awarded Dec 31, 2020 at 15:26
How to insert in a table with only an IDENTITY column?
Awarded Dec 26, 2020 at 13:35
How to view the query of another session in pg_stat_activity without being super user?
Awarded Dec 25, 2020 at 23:12
How to Drop Database in Single_User Mode
Awarded Dec 18, 2020 at 0:47
What is a valid use case for using TIMESTAMP WITHOUT TIME ZONE?
Awarded Dec 17, 2020 at 16:17
How can I insert smiley faces into MySQL ( 😊 )
Awarded Dec 17, 2020 at 15:25
How to search for a specific column name in all the tables in MySQL Workbench?
Awarded Dec 17, 2020 at 11:51
'Access denied; you need (at least one of) the PROCESS privilege(s) for this operation' when trying to dump tablespaces
Awarded Dec 16, 2020 at 8:18
Modify table constraint in PostgreSQL
Awarded Dec 14, 2020 at 18:56
How to list all table columns in sorted order on Postgres?
Awarded Dec 11, 2020 at 22:21
How to toggle a boolean field by sql in postgresql?
Awarded Dec 8, 2020 at 10:10
PostgreSQL Change owner of all tables under a specific schema
Awarded Dec 7, 2020 at 15:27
Backup only one schema and restore it on another server
Awarded Dec 7, 2020 at 12:05
10 TB database backup / restore Question
Awarded Dec 7, 2020 at 3:16
Only first column in ORDER BY clause is sorted
Awarded Dec 1, 2020 at 15:05
How do I find PostgreSQL's data directory?
Awarded Nov 26, 2020 at 4:04
How do I get the current unix timestamp from PostgreSQL?
Awarded Nov 25, 2020 at 16:18
Sql Server Maintenance Plan - Best Practices on Tasks and Scheduling
Awarded Nov 23, 2020 at 9:08
How to insert (file) data into a PostgreSQL bytea column?
Awarded Nov 21, 2020 at 8:05
Get partial match from GIN indexed TSVECTOR column
Awarded Nov 13, 2020 at 18:18
How do I decompose ctid into page and row numbers?
Awarded Nov 13, 2020 at 1:37
Trigger firing despite no rows being affected
Awarded Nov 9, 2020 at 21:34
Why don't my .my.cnf settings work?
Awarded Nov 5, 2020 at 15:28
How to remove line breaks in SSMS?
Awarded Nov 5, 2020 at 14:57
Improve delete speed for SQL Server
Awarded Nov 4, 2020 at 13:34
PostgreSQL: How to create full copy of database schema in same database?
Awarded Nov 3, 2020 at 22:15
Could a null column be part of a primary key?
Awarded Oct 29, 2020 at 19:20
Writing select result to a csv file
Awarded Oct 28, 2020 at 15:31
Comparing Columns that can contain NULLS - is there a more elegant way?
Awarded Oct 27, 2020 at 15:06
Decode Base64 String Natively in SQL Server
Awarded Oct 27, 2020 at 14:28
SQL-Server: Why do we use FILE = 1 in scripts for restoring a database
Awarded Oct 27, 2020 at 13:21
Is it possible to modify an existing trigger definition in MySQL?
Awarded Oct 18, 2020 at 4:04
Benefits of using backtick (`) in MySQL queries?
Awarded Oct 16, 2020 at 18:47
Why filtered index on IS NULL value is not used?
Awarded Oct 16, 2020 at 11:05
List the database privileges using psql
Awarded Oct 14, 2020 at 13:46
Write a slow query to test slow query logging?
Awarded Oct 13, 2020 at 18:40
'Access denied; you need (at least one of) the PROCESS privilege(s) for this operation' when trying to dump tablespaces
Awarded Oct 9, 2020 at 7:57
Why are the plans different if the queries are logically alike?
Awarded Oct 9, 2020 at 7:18
How to know when/if I have too many indexes?
Awarded Oct 8, 2020 at 6:31
How can I force MySQL to IGNORE ALL indexes?
Awarded Oct 5, 2020 at 16:09
Is there an alternative to "Create or replace procedure" in MySQL?
Awarded Oct 1, 2020 at 18:50
Sql Server - Best Practices for Growing Database Files
Awarded Sep 30, 2020 at 22:02
How to make multiple counts in one query?
Awarded Sep 29, 2020 at 9:57
What is an audit table?
Awarded Sep 26, 2020 at 23:56
can't connect to remote postgresql database
Awarded Sep 22, 2020 at 10:35
When to use sort_in_tempdb when rebuilding indexes?
Awarded Sep 18, 2020 at 23:42
Why is "select *" faster than "select top 500 *" in SQL Server?
Awarded Sep 8, 2020 at 7:27
Disconnect from network without stopping the query
Awarded Sep 4, 2020 at 10:47
How to list all views in SQL in PostgreSQL?
Awarded Sep 1, 2020 at 17:41
Get second highest value in a table
Awarded Aug 28, 2020 at 0:11
Is it safe to rely on the order of an INSERT's OUTPUT clause?
Awarded Aug 25, 2020 at 5:56
How to run recurring tasks on Postgresql without an external cron-like tool?
Awarded Aug 22, 2020 at 2:20
Passing array parameters to a stored procedure
Awarded Aug 19, 2020 at 9:40
What does a RED X on a database user mean?
Awarded Aug 19, 2020 at 0:03
How to use psql with no password prompt?
Awarded Aug 18, 2020 at 6:48
Combining separate ranges into largest possible contiguous ranges
Awarded Aug 14, 2020 at 15:25
How to ORDER BY typical software release versions like X.Y.Z?
Awarded Aug 12, 2020 at 15:30
MongoDB using too much memory
Awarded Aug 3, 2020 at 23:52
Granting access to all tables for a user
Awarded Aug 1, 2020 at 20:12
1
…
5 6
7
8 9
…
25