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.
What's the difference between EXECUTE AS USER and EXECUTE AS LOGIN that makes the second one behave unexpectedly?
Awarded Aug 21, 2023 at 14:31
Script to estimate row sizes for any table
Awarded Aug 18, 2023 at 11:26
Unable to start Oracle (11g1) due to bad memory configuration (ORA-00837)
Awarded Aug 14, 2023 at 11:03
Why is optimistic locking faster than pessimistic locking?
Awarded Aug 8, 2023 at 6:02
DISTINCT not reducing two equal values to one
Awarded Aug 7, 2023 at 14:57
SQL Server: index creation date
Awarded Aug 6, 2023 at 12:56
How to create xml string for each row of table?
Awarded Aug 1, 2023 at 10:41
SQL Server Management Studio cannot connect because of common algorithm
Awarded Jul 31, 2023 at 8:31
Why are some high severity error message in SQL Server not logged to the Windows Event Log?
Awarded Jul 26, 2023 at 12:58
A function to check if a column allows NULL
Awarded Jul 21, 2023 at 7:03
Disable foreign key checks during import
Awarded Jul 16, 2023 at 12:16
how to solve Invalid usage of the option NEXT in the FETCH statement
Awarded Jul 13, 2023 at 12:55
Best practices for finding and updating a handful of records?
Awarded Jul 10, 2023 at 13:17
Is there a performance benefit to use tinyint instead of int for Primary Key?
Awarded Jul 7, 2023 at 1:34
Is high Extent Fragmentation a problem?
Awarded Jul 4, 2023 at 6:34
Which table should a foreign key live on
Awarded Jun 30, 2023 at 16:48
How to clear PostgreSQL temp files after crash
Awarded Jun 27, 2023 at 8:45
Shall I use enum when are too many "categories" with PostgreSQL?
Awarded Jun 21, 2023 at 14:50
This backup cannot be restored using WITH STANDBY because a database upgrade is needed. Reissue the RESTORE without WITH STANDBY
Awarded Jun 19, 2023 at 16:21
Linked Server with Windows Authentication Permissions
Awarded Jun 16, 2023 at 4:40
The ALTER TABLE statement conflicted with the CHECK constraint
Awarded Jun 12, 2023 at 21:51
Is there a reliable way to check if a trigger being fired was the result of a DML action from another *specific* trigger?
Awarded Jun 3, 2023 at 8:32
Find which SESSION_CONTEXT key-value pairs was set
Awarded Jun 2, 2023 at 18:33
Unable to drop non-PK index because it is referenced in a foreign key constraint
Awarded May 31, 2023 at 5:07
How to get exception context for a manually raised exception in PL/pgSQL?
Awarded May 24, 2023 at 14:46
How do you drop a temporal table in SQL Server?
Awarded May 24, 2023 at 6:50
Sort table rows and save the row numbers using UPDATE
Awarded May 24, 2023 at 6:02
Benefit of having time dimension in a star schema?
Awarded May 21, 2023 at 12:25
Why have both a postmaster and postgres executable?
Awarded May 19, 2023 at 17:57
pg_restore ERROR: "Relation does not exist" and creating new database
Awarded May 16, 2023 at 3:06
AWS DMS creates tables with no auto_increment
Awarded May 15, 2023 at 18:07
Rows with a variable number of columns?
Awarded May 12, 2023 at 1:50
Return ResultSet with column names from functions
Awarded May 10, 2023 at 20:50
MySQL Replication Duplicate Entry for Primary Key
Awarded May 10, 2023 at 11:10
Query performance on static, large PostgreSQL table
Awarded May 10, 2023 at 9:18
SQL Server Error 8632 due to over 100,000 entries in WHERE clause
Awarded May 10, 2023 at 8:43
How does unnest() treat NULL values and empty arrays?
Awarded May 10, 2023 at 6:47
Unable to execute query and not even able to generate Estimated execution plan
Awarded May 9, 2023 at 20:52
What is the performance impact of pg_stat_statements?
Awarded May 8, 2023 at 16:33
How to backup/restore SQL Server database from command line similar to mysql
Awarded Apr 30, 2023 at 17:41
Is this a bug or I did something wrong when I created the table?
Awarded Apr 27, 2023 at 10:31
Alias using "AS" and without using "AS"
Awarded Apr 25, 2023 at 16:20
In SQL server is a check constraint applied before or after a default constraint on insert?
Awarded Apr 24, 2023 at 15:27
T-SQL query for date of last full backup, size and location
Awarded Apr 24, 2023 at 15:27
Join with comma separated values in SQL Server
Awarded Apr 18, 2023 at 10:05
MySQL event scheduler waiting on empty queue since server restarted 12 days ago
Awarded Apr 17, 2023 at 16:26
SQL Server: Grant access to all views in schema, but not tables
Awarded Apr 12, 2023 at 11:34
MySQL Workbench, how to refresh EER diagram?
Awarded Apr 10, 2023 at 13:33
BIGINT UNSIGNED value is out of range
Awarded Apr 7, 2023 at 1:41
How to undo DROP TABLE statement?
Awarded Apr 6, 2023 at 17:52
How to get all distinct words in a column
Awarded Apr 5, 2023 at 23:26
How long will an index take to create?
Awarded Apr 5, 2023 at 13:25
ERROR: could not find array type for datatype information_schema.sql_identifier
Awarded Apr 4, 2023 at 18:31
I can't access any database diagram
Awarded Apr 1, 2023 at 14:42
Enabling trace flag 8048
Awarded Mar 28, 2023 at 19:10
MySQL binary logs - skip a table
Awarded Mar 27, 2023 at 13:56
How does PostgreSQL physically order new records on disk (after a cluster on primary key)?
Awarded Mar 25, 2023 at 13:46
Storing more than 8000 bytes in a column
Awarded Mar 23, 2023 at 12:26
SSIS export to CSV Flat File Destination task, error The code page on input column is ... and is required to be
Awarded Mar 21, 2023 at 17:20
How can you output UPDATE / INSERT query results when using MySQL -e,--execute?
Awarded Mar 15, 2023 at 12:50
1
…
3 4
5
6 7
…
57