Skip to main content
Database Administrators

Famous Question

 Famous Question
Question with 10,000 views. This badge can be awarded multiple times.
Awarded 8859 times.
Oracle - Can't login with "/ as sysdba", but can with "sys as sysdba"
Awarded 2 days ago
MS-SQL-Server 2019 is slower than SQL-Server 2008
Awarded 2 days ago
The datediff function resulted in an overflow
Awarded 2 days ago
Necessity of having two instances (Reader and Writer) in Amazon Aurora
Awarded 2 days ago
No connection could be made because the target machine actively refused it
Awarded 2 days ago
SQL Server Backup Database not .bak file format
Awarded Jul 17 at 13:48
How to get complete SQL Text running of the query in a given SPID
Awarded Jul 16 at 8:55
SQL getting IDs from one table with multiple entries in another table
Awarded Jul 15 at 20:27
Getting Index Scan instead of a possible Index Seek?
Awarded Jul 15 at 19:06
Recreating Database from IBD files (no FRM)
Awarded Jul 15 at 18:08
How to list database users, their permissions, and roles they belong to?
Awarded Jul 15 at 17:25
How to generate replication snapshot without locking tables
Awarded Jul 15 at 13:50
How to correctly replace 'default_authentication_plugin' with 'authentication_policy'?
Awarded Jul 15 at 12:56
Connection to localhost dramatically slower than to network server
Awarded Jul 15 at 11:52
Difference between alert log and archive log in oracle databases
Awarded Jul 15 at 4:57
Set column values based on condition statement
Awarded Jul 14 at 19:00
write "ENGINE=INNODB DEFAULT CHARSET=UTF8MB4" once for the whole script
Awarded Jul 14 at 11:47
Is possible to use ORDER BY with IF ELSE condition?
Awarded Jul 13 at 9:09
How to set AUTHORIZATION on CREATE SCHEMA
Awarded Jul 12 at 10:21
Stop SQL Server from ordering results? [duplicate]
Awarded Jul 11 at 23:16
Enable SQL server agent service by T-SQL script or PowerShell
Awarded Jul 10 at 15:35
What is the impact of setting "max text repl size (B)" to -1?
Awarded Jul 10 at 3:10
ORA-00942 when trying to select from gv$session inside of procedure
Awarded Jul 9 at 13:31
MEMORYCLERK SQLBUFFERPOOL
Awarded Jul 9 at 6:41
Most efficient way to call same Table-Valued Function on multiple columns in a Query
Awarded Jul 7 at 22:17
Create user for all databases in MongoDB
Awarded Jul 7 at 21:04
psql: FATAL: the database system is starting up [closed]
Awarded Jul 6 at 15:52
How fast should I expect postgresql to be?
Awarded Jul 5 at 22:16
SQL Server login failed for user and all user accounts seem to be disabled
Awarded Jul 5 at 18:32
mysql 8.0, updates are sometimes stalling
Awarded Jul 5 at 13:09
SSMS error : The certificate chain was issued by an authority that is not trusted
Awarded Jul 3 at 14:16
Use of ANY function for multiple values
Awarded Jul 2 at 15:41
How can I create rows without an underlying table in IBM DB2 SQL?
Awarded Jul 2 at 8:51
Is there any performance difference between UNIQUE INDEX and INDEX with the same cardinality on MySQL?
Awarded Jul 2 at 8:32
Should I call my UUID primary key column ID or not?
Awarded Jun 30 at 23:03
How do I limit a SQL stored procedure to be run by one person at a time?
Awarded Jun 28 at 23:34
How to Determine Chunk Distribution (data and number of docs) in a Sharded MongoDB Cluster?
Awarded Jun 27 at 9:49
Invalid connection error on SQL Server 2008
Awarded Jun 26 at 19:51
How to write a check constraint to disallow empty varchar fields?
Awarded Jun 26 at 18:57
join value in a RETURNING which is not inserted
Awarded Jun 26 at 12:56
Is it possible to allow missing value inserts in mysql instead of requiring "NULL" in the query? [closed]
Awarded Jun 25 at 18:20
How to backup live mysql database?
Awarded Jun 25 at 11:30
Delete multiple rows based on a choice between a combination of two columns
Awarded Jun 24 at 13:28
Understanding sys.dm_exec_query_stats execution_count vs creation_time
Awarded Jun 22 at 17:47
CREATE DATABASE AS COPY does not work with Azure
Awarded Jun 22 at 8:06
How to Skip Existing Data While Restoring mysqldump File?
Awarded Jun 22 at 1:51
SQL Server Replication Agent Permission
Awarded Jun 21 at 21:56
How to register CLR assembly as trusted in SSDT deployment
Awarded Jun 21 at 19:33
Visual Explain Not working in MySQL Workbench
Awarded Jun 21 at 9:20
Command to validate a postgresql configuration file?
Awarded Jun 21 at 8:04
What is a "LOB"
Awarded Jun 20 at 15:01
How to properly configure my.ini for MySQL? [closed]
Awarded Jun 20 at 13:56
Using a Different Windows Account for Invoke-Sqlcmd
Awarded Jun 18 at 19:48
How to backup some selected tables, but not all, in pgAdmin 4?
Awarded Jun 18 at 12:31
Oracle: ORA-00904: "xxxx": invalid identifier when doing "Alter Table xxxx Modify ..." [closed]
Awarded Jun 17 at 21:10
Location of postgres db file for backup
Awarded Jun 17 at 20:01
How to List SYNONYMS that no longer point to a valid object?
Awarded Jun 17 at 18:57
Rename SQL log and master database file
Awarded Jun 17 at 12:03
How to change table and sequence owner to another user with PostgreSQL?
Awarded Jun 17 at 9:50
Are there side effects to Postgres 12's NOT MATERIALIZED directive?
Awarded Jun 15 at 23:17
1
2 3 4 5
…
148