Database Administrators

Popular Question

 Popular Question
Question with 1,000 views. This badge can be awarded multiple times.
Awarded 33179 times.
When are COLUMN aliases in FROM clauses needed?
Awarded 4 hours ago
Oracle program “lsnrctl” is missing after the installation of Oracle SQL Developer [closed]
Awarded 8 hours ago
Oracle 12c and Jobs running one hour apart after changing time for hourly use
Awarded 11 hours ago
how to regexp positive lookaheads in MySQL
Awarded yesterday
Estimate query speed for +1.5 billion rows mysql table
Awarded yesterday
How do I query for system views in a SQL Server database?
Awarded yesterday
Debug why MySQL/mariadb table is crashing
Awarded yesterday
mysql upgrading from 5.1 --> 5.6 do I have to do mysqldump before upgrade?
Awarded yesterday
MongoDB Performance of Overwriting an Array Field vs Individually Updating the items
Awarded yesterday
Postgresql.conf not found
Awarded yesterday
Migrate complete postgres database cluster to another machine using pg_dump
Awarded yesterday
MSSQL Right / Left Trim by Character
Awarded yesterday
MySQL query for 3 consecutive integers between records
Awarded yesterday
How to fail over availability groups on multiple remote servers
Awarded yesterday
UPDATE STATEMENT GETTING STUCK
Awarded 2 days ago
Checking column stats in Oracle 12
Awarded 2 days ago
Table structure for entity versioning
Awarded 2 days ago
Avoid foreign keys on an 800-GB database?
Awarded 2 days ago
Check partition function if list of value exists, if not iterate through list and add new partition value to the partition function?
Awarded 2 days ago
Error “RMAN-04006: error from auxiliary database” in the middle of duplicate executiion
Awarded 2 days ago
How can I eliminate this scalar function or make it faster?
Awarded 2 days ago
Raise NOTICE, Raise INFO not saved to logs in POSTGRES
Awarded 2 days ago
Why is Microsoft SQL Server creating a ton of dump files?
Awarded 2 days ago
Always On Availability Group ApplicationIntent=ReadOnly Not routing to Secondary
Awarded 2 days ago
T-SQLRevoke permissions to all tables in the sql server in one go
Awarded 2 days ago
MySQL InnoDB cluster pricing
Awarded 2 days ago
dbcc cleantable batch size explanation
Awarded 2 days ago
How do I identify the source of the 17886 errors (“server will drop the connection”) in my SQL errorlog?
Awarded 2 days ago
Error 1236 'Found old binary log without GTIDs' after master restart
Awarded 2 days ago
Should I create an index for non key columns?
Awarded 2 days ago
Concurrent UPDATEs on INNODB tables in MySQL
Awarded Apr 8 at 2:31
How do I force windows to use a specific version of SQLCMD?
Awarded Apr 7 at 21:12
DB2: Cannot use RUNSTATS/REORG in trigger definitions?
Awarded Apr 7 at 15:40
Sum of decimal values that come in a string
Awarded Apr 7 at 14:42
Getting error “String or binary data would be truncated” even for 'text' data type
Awarded Apr 7 at 13:33
Debugging a hanging session/lock
Awarded Apr 7 at 12:56
Change ID(int) to UUID
Awarded Apr 7 at 10:42
DB2 Trigger Error : An unexpected token “OR INSERT” was found following SQLCODE=-104, SQLSTATE=42601, DRIVER=3.68.61
Awarded Apr 7 at 9:05
What is the purpose of WITH options in Sql Constraints? [closed]
Awarded Apr 7 at 8:57
MySQL LIKE IN with Input Parameter of stored procedure Comma Separated Values
Awarded Apr 7 at 7:36
JOIN to obtain all the rows from the first table along with NULLs from the second table
Awarded Apr 7 at 3:51
Viewing Temp Tables
Awarded Apr 7 at 2:18
MySQL UUID() behavior
Awarded Apr 6 at 23:43
how to define trigger scope variable [closed]
Awarded Apr 6 at 21:07
When installing Oracle, what's the quickest way to check rpm packages and install what is missing?
Awarded Apr 6 at 19:35
Isolation level serializable not working as expected?
Awarded Apr 6 at 19:17
unnest all columns from a given table
Awarded Apr 6 at 19:17
Unable to connect to Mysql at peak time
Awarded Apr 6 at 18:17
How can I insert a record into a table that depends on a foreign key linking to a previous table?
Awarded Apr 6 at 18:10
Win-Loss Record in SQL Server
Awarded Apr 6 at 17:27
Streaming replication archive folder taking all space- Postgresql- 9.4
Awarded Apr 6 at 15:55
SQL Server consuming all my CPU
Awarded Apr 6 at 15:41
different db stats in MongoDB replica set
Awarded Apr 6 at 13:48
Are there any problems with deploying an SQL Server database to a production server by taking a backup?
Awarded Apr 6 at 13:25
generate array of unique uuid in postgreSQL
Awarded Apr 6 at 12:08
Replication Configuration
Awarded Apr 6 at 11:51
mongodb keyfile permission denied
Awarded Apr 6 at 10:12
Merge multiple rows into fewest number of rows of distinct values
Awarded Apr 6 at 9:19
(macOS/Docker) “Cannot bulk load. The file path does not exist or you don't have file access rights.”
Awarded Apr 6 at 7:31
Contacts table with multiple entries?
Awarded Apr 6 at 6:42
1
2 3 4 5
…
553

Your privacy

By clicking “Accept all cookies”, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy.