Skip to main content
Database Administrators

Enlightened

 Enlightened
First to answer and accepted with score of 10 or more. This badge can be awarded multiple times.
Awarded 3378 times.
How can I synchronize data between two RDS MySQL databases
Awarded Jun 21, 2024 at 14:35
What SQL Server edition supports CDC?
Awarded Jun 18, 2024 at 16:07
How should MAXDOP be configured on stacked instances?
Awarded Jun 17, 2024 at 7:35
EXISTS() vs EXISTS() = TRUE in Postgres
Awarded Jun 14, 2024 at 17:49
Debug query on big table that is sometimes slow
Awarded Jun 14, 2024 at 4:16
Why does DELETE leave a lingering effect on performance?
Awarded Jun 11, 2024 at 18:17
Why does SQL-Server Management Studio change "Execute Query" into "Save Results"?
Awarded Jun 7, 2024 at 22:51
XML Query keeps converting < to &lt; and > to &gt;
Awarded Jun 6, 2024 at 15:17
Multiple concurrent connections to same large SQLite file on a network share
Awarded Jun 5, 2024 at 11:20
Double entry accounting schema design
Awarded Jun 5, 2024 at 7:36
Is the size limit of a json field before or after compression in Postgres?
Awarded Jun 2, 2024 at 16:56
Best practices for updating data on a "live" table
Awarded May 31, 2024 at 12:46
Execution slow in stored procedure; fast when run ad hoc
Awarded May 29, 2024 at 20:40
Avoid output disappearing in psql
Awarded May 29, 2024 at 15:52
Giving server-role to login breaks stored procedures
Awarded May 28, 2024 at 7:42
What does SQL Server's Error Log actually log?
Awarded May 25, 2024 at 18:47
Index seek to specific multi-column key, then get some rows in lexicographical order
Awarded May 21, 2024 at 3:17
MySQL settings useful to speed up a mysqldump import
Awarded May 19, 2024 at 12:47
How to handle versions of an Entity in Database Design
Awarded May 17, 2024 at 13:25
Restoring a backup to an older version of SQL Server
Awarded May 17, 2024 at 13:25
Postgres choosing a filter instead of index cond when OR is involved
Awarded May 17, 2024 at 4:15
Extra NESTED LOOP / INNER JOIN causing NO JOIN PREDICATE warning
Awarded May 16, 2024 at 8:40
BLOBs or references in PostgreSQL
Awarded May 15, 2024 at 19:48
What does PostgreSQL Status active (exited) mean?
Awarded May 14, 2024 at 13:05
Removing leading zeros from month and day
Awarded May 14, 2024 at 4:18
PostgreSQL - How to list all foreign key link to Primary key of a table
Awarded May 13, 2024 at 8:01
If RAISERROR is as good as deprecated, how are you supposed to flush the PRINT buffer?
Awarded May 9, 2024 at 23:45
Is it possible to mysqldump a subset of a database required to reproduce a query?
Awarded May 9, 2024 at 0:56
the REFERENCES privilege is only about creating a foreign key constraint? Practical use cases?
Awarded May 8, 2024 at 14:45
Why isn't to_char IMMUTABLE, and how can I work around it?
Awarded May 2, 2024 at 2:41
How to get the schema name of a table of type regclass in PostgreSQL?
Awarded May 2, 2024 at 2:41
How do you get an average of job history times?
Awarded May 1, 2024 at 12:40
What is the difference between POSTGRES _text and text[][] array types?
Awarded Apr 29, 2024 at 13:01
Why is COALESCE not a function?
Awarded Apr 29, 2024 at 4:08
Specify type on SQL Server Computed Column
Awarded Apr 19, 2024 at 6:10
Is a serialization anomaly only possible with SUM/COUNT?
Awarded Apr 12, 2024 at 0:41
How to properly align columns in SQLite?
Awarded Apr 10, 2024 at 18:46
Is it possible to choose RAISERROR or THROW depending on SQL Server version?
Awarded Apr 10, 2024 at 11:46
Cannot connect database as sys as sysdba using sqlplus
Awarded Apr 7, 2024 at 18:55
Single Predicate Check Constraint Gives Constant Scan but Two Predicate Constraint does not
Awarded Apr 5, 2024 at 12:49
PostgreSQL SELECT primary key as "serial" or "bigserial"
Awarded Apr 3, 2024 at 6:50
Are PostgreSQL clusters and servers the same thing?
Awarded Apr 2, 2024 at 23:51
Complex constraint across all data in a table
Awarded Apr 2, 2024 at 14:56
Trying to understand TID definition from PostgreSQL documentation
Awarded Mar 27, 2024 at 21:33
Bitmap Creation in Execution Plan Causes bad Estimate on Clustered Index Scan
Awarded Mar 26, 2024 at 12:06
SSIS File System Task Copy File Could not find part of the path error
Awarded Mar 25, 2024 at 20:33
Create foreign key on foreign table in postgresql
Awarded Mar 25, 2024 at 14:56
How to find out the account(s) under which the sql server is running?
Awarded Mar 21, 2024 at 6:56
How do I create an insert-only user for a Postgres table with an index?
Awarded Mar 20, 2024 at 20:10
How to remove SQL Server Error Logs
Awarded Mar 18, 2024 at 21:31
Operand type clash: int is incompatible with datetime2
Awarded Mar 17, 2024 at 16:03
Why is postgreSQL using 1-based arrays?
Awarded Mar 2, 2024 at 1:20
Implications of changing compatibility mode in SQL Server from 100 to 110
Awarded Feb 20, 2024 at 19:00
SQL Server: Max memory same as Min memory?
Awarded Feb 16, 2024 at 15:31
How to insert values in junction table for many to many relationships?
Awarded Feb 5, 2024 at 12:46
How does UPDATE FROM work?
Awarded Feb 2, 2024 at 16:56
PostgreSQL nondeterministic collations are not supported for LIKE
Awarded Feb 1, 2024 at 14:27
Set PostgreSQL table to LOGGED after data loading
Awarded Jan 31, 2024 at 17:07
CREATE DATABASE AS COPY does not work with Azure
Awarded Jan 25, 2024 at 23:57
Why does this LEFT JOIN perform so much worse than LEFT JOIN LATERAL?
Awarded Jan 24, 2024 at 16:48
1 2
3
4 5
…
57