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.
using "\dp table_name" in "psql" throws "operator is not unique"
Awarded Nov 7 at 18:42
Subtracting sum of previous rows' data from current row's data in SQL
Awarded Nov 3 at 3:09
Is it possible to enforce unique values in a column, excluding nulls?
Awarded Nov 3 at 3:09
Change SELECT DISTINCT to UPDATE DISTINCT
Awarded Nov 3 at 3:09
INSERT performance difference between temporary tables and table variable
Awarded Nov 3 at 1:09
What is Microsoft SQL Server doing when I manually reduce the file size in Database Properties > Files?
Awarded Oct 31 at 21:39
How to release unused space?
Awarded Oct 21 at 13:46
What does SOS in SQL Server stand for?
Awarded Sep 30 at 19:04
PostgreSQL: Auto update updated_at with custom column
Awarded Sep 12 at 14:48
Alter table alter column does not work with user defined types
Awarded Sep 11 at 10:34
Reducing database size to restore to SQL Server Express
Awarded Sep 2 at 17:01
Meaning of '#' suffix on SQL Server columns
Awarded Sep 2 at 11:34
How to control psql displaying rows with (END)?
Awarded Aug 25 at 14:40
Statistics on temp tables
Awarded Aug 15 at 2:00
Unable to Create COMMIT inside PostgreSQL 11.5 Procedure
Awarded Jul 29 at 23:38
How do I do a JOIN in ANSI SQL 89 syntax?
Awarded Jul 21 at 4:20
PgAdmin 4 - How to connect to database using unix socket via ssh tunnel?
Awarded Jul 18 at 7:06
Problem with mysqldump and view
Awarded Jul 12 at 0:25
Interpreting SQL Server's Showplan XML
Awarded Jul 1 at 18:42
Change Data Capture vs trigger for logging changes
Awarded Jun 29 at 6:24
How to change table and sequence owner to another user with PostgreSQL?
Awarded Jun 23 at 21:37
Why and how and where to use user without login
Awarded Jun 22 at 17:48
If no plans to uninstall, can Log and Update Cache folders in Setup Bootstrap folder be removed?
Awarded Jun 18 at 19:48
What is considered for output from an sql server job step?
Awarded Jun 10 at 20:34
How to select sub-object with given keys from JSONB?
Awarded Jun 9 at 12:24
Cannot rename the table because it is published for replication
Awarded Jun 3 at 18:07
PostgreSQL: Why is the schema owner not the database owner
Awarded May 30 at 13:08
SQL Server Instance How to recover memory used
Awarded May 29 at 19:49
SQL Server does CU+GDR also install the CU as well as the GDR
Awarded May 28 at 19:48
SSMS 21.0.1 - can copilot integration be stopped?
Awarded May 25 at 17:09
If all of the indexes of a table are partitioned with the same function and scheme but on different columns, is it still considered aligned?
Awarded May 20 at 14:26
ORDER BY and comparison of mixed strings of letters and numbers
Awarded May 17 at 3:58
How to return the value from a query with SP_EXECUTESQL in a stored procedure
Awarded May 16 at 11:11
Microsoft SQL Server | Investigate Root Cause of DBCC CHECKDB error | (SQLSTATE 42000)(Error 8992 | Catalog Msg 3853)
Awarded May 8 at 8:24
Union does not always eliminate duplicates
Awarded May 6 at 18:02
how come a table variable is improving the performance of a query in this circumstance?
Awarded May 5 at 18:32
Why not use Snapshot isolation for everything read-only?
Awarded May 3 at 20:38
Can I grant a user ALTER TRACE permission to a single database?
Awarded Apr 17 at 1:39
Multi language full text search using postgresql
Awarded Apr 16 at 8:32
What are some common and useful fields for a users table in a database?
Awarded Apr 11 at 0:21
MySQL replication working fine, but still shows "Waiting for master to send event" at 280000 seconds
Awarded Apr 4 at 19:25
PostgreSQL seems to ignore RAISE EXCEPTION in a CTE
Awarded Apr 1 at 20:46
Clustered Index Update operator performing excessive Logical Reads after query change
Awarded Mar 18 at 18:06
mariadb: Aborted connection .. Got timeout reading communication packets
Awarded Mar 18 at 13:17
Syntax error only on one specific server
Awarded Mar 17 at 12:10
Index scan when more than 35 correlated subqueries are used with default cardinality estimation
Awarded Mar 10 at 19:06
Is it possible to extract the formula or expression of a field within a SQL Server Stored Procedure?
Awarded Mar 8 at 14:12
Why DB2 cannot allow creation of database with keyword "BACKUP" in its name?
Awarded Mar 8 at 7:19
How is this a feature of sqlite3? Foreign key relationship gone wrong
Awarded Mar 5 at 22:34
Storing arrays in MYSQL?
Awarded Mar 1 at 7:55
postgresql bigserial or sequence using jpa
Awarded Feb 26 at 22:33
Why SUM function returning 4 decimal places, but AVG function returning 6 decimal places
Awarded Feb 25 at 16:34
NVARCHAR(MAX) string appears to have 6326 characters but won't PRINT them all
Awarded Feb 24 at 14:58
Unnecessary sort with TOP PERCENT?
Awarded Feb 18 at 20:19
SQL Server instance using only a few hundred MB. Well below the minimum server memory setting
Awarded Feb 6 at 15:12
When creating stored procedure, are the comments before the definition always preserved?
Awarded Feb 5 at 18:36
How do I move all tables from one Postgres schema to another
Awarded Feb 1 at 8:35
Can it be safe to disable binary logging in MySQL?
Awarded Jan 21 at 19:42
Best design to reference multiple tables from single column?
Awarded Jan 21 at 9:47
What permissions are needed to view dependencies?
Awarded Jan 14 at 11:32
1
2 3 4 5
…
57