Database Administrators

Help Center > Badges > Teacher

 Teacher
Answer a question with score of 1 or more.
Awarded 11569 times.
How to get rid of ORA-28002 message the password will expire within 6 days?
Awarded yesterday
Aggregate function to return any (first) encountered value
Awarded yesterday
I'm trying to enable SQL Filestream on Windows Server 2012 and SQL Server 2016 64 bit, Management Studio 2017
Awarded yesterday
Redshift throws Value too long for character type character varying(100) even when values are within the range
Awarded yesterday
How can I find the longest record (in characters) for each column in a table in PostgreSQL
Awarded yesterday
Importing CSV file into a PostgreSQL table
Awarded yesterday
Standalone Backup and Restore Tools
Awarded yesterday
PostgreSQL update column B with values generated from function that uses values from column A
Awarded 2 days ago
Is a “Ranking” query's ORDER BY in FROM subquery is preserved?
Awarded 2 days ago
What is the standard way to make a invoice system database tables?
Awarded 2 days ago
is “create schema” the same way of saying “create database”?
Awarded 2 days ago
Distributed Availability Group Failover Issue
Awarded 2 days ago
What causes SQL error 41106?
Awarded Jul 17 at 19:55
Find queries executed by an user in sql server
Awarded Jul 17 at 18:15
Restore Backup Fails - File 'Db' cannot be restored to '{…}.mdf'. Use WITH MOVE to identify a valid location for the file
Awarded Jul 17 at 15:35
How to send mail from a restricted SQL Server
Awarded Jul 17 at 15:25
MariaDB: disable foreign key checks
Awarded Jul 17 at 13:40
SQL Server Agent Job - Unable to open Step output file. The step succeeded
Awarded Jul 16 at 20:20
Best way to back up databases on a Microsoft SQL Server Availability Group DR Site node
Awarded Jul 16 at 19:20
Does read-only activity on synchronous secondary replica slow down primary replica in Availability Group?
Awarded Jul 16 at 14:20
Getting PL/SQL: ORA-00942: table or view does not exist in plsql function but not from the command view
Awarded Jul 16 at 12:00
Mongodb get Effective Lock
Awarded Jul 16 at 6:40
How to select the set of last non-NULL values per column over a group?
Awarded Jul 16 at 6:25
Database Tuning Advisor error: …% of consumed workload has syntax errors
Awarded Jul 15 at 23:30
Function is accepting varchar when input is set to INT
Awarded Jul 15 at 19:10
UPDATE to linked server (Pervasive Database) is failing using OPENQUERY
Awarded Jul 15 at 17:10
(post deleted or otherwise unavailable)
Awarded Jul 15 at 15:55
(post deleted or otherwise unavailable)
Awarded Jul 15 at 7:00
MariaDB 10.1.38 - Specified key was too long; max key length is 767 bytes
Awarded Jul 14 at 16:20
Deny Delete to An Active Directory Account in Sql Server
Awarded Jul 14 at 4:10
Hashed User concept in db2
Awarded Jul 13 at 18:10
Performance of a View with Hundreds of Left Joins
Awarded Jul 13 at 12:40
Database design for Scavenger Hunt Game
Awarded Jul 13 at 8:55
Possibly tempdb out of space or a system table is inconsistent
Awarded Jul 13 at 3:05
Why cant i get partition elimination when partition column values are in a lookup table?
Awarded Jul 12 at 18:25
How to add days to a date in PostgreSQL?
Awarded Jul 12 at 14:20
Will OPTIMIZE TABLE have any impact on my data?
Awarded Jul 12 at 10:50
ERROR 1031 (HY000) at line X: Table storage engine for 'TBL' doesn't have this option
Awarded Jul 12 at 10:25
(post deleted or otherwise unavailable)
Awarded Jul 11 at 22:00
How critical is it if SYSAUX is full?
Awarded Jul 11 at 16:25
mysqldump vs mysqlpump
Awarded Jul 11 at 14:35
How to use left join with Where clause
Awarded Jul 11 at 11:35
Primary and secondary replicas on same server
Awarded Jul 11 at 6:45
PostgreSQL: Cannot change directory to /root
Awarded Jul 10 at 20:40
There is insufficient system memory in resource pool to run this query
Awarded Jul 10 at 19:55
What's the maximum number of partition per table I can/should have in MySql 8?
Awarded Jul 10 at 6:30
Postgresql: what are the disadvantages of unlogged table
Awarded Jul 10 at 3:05
repmgr 4.4 upgrade
Awarded Jul 9 at 17:00
SQL Server 2016 Cluster - mail works in alerts; sp_send_dbmail dosen't send in jobs
Awarded Jul 9 at 17:00
SQL Server has encountered 1 occurrence(s) of cachestore flush
Awarded Jul 9 at 12:40
mysql 8.0, updates are sometimes stalling
Awarded Jul 9 at 12:35
What is the meaning of “dimension key”?
Awarded Jul 9 at 9:50
join a lookup table with a data table
Awarded Jul 8 at 22:30
What are the real life cases for using Oracle advanced queuing?
Awarded Jul 8 at 14:25
Is there really no way in SQL to update all fields in a table without explicitly typing field names
Awarded Jul 8 at 11:50
creating a new table results in incorrect syntax error
Awarded Jul 8 at 9:45
Is it possible to disable new version checking in pgAdmin 4?
Awarded Jul 8 at 7:50
Remove Dot at end of line of the string in SQLserver
Awarded Jul 7 at 22:30
MySQL: What does event `/io/table/sql/handler` mean?
Awarded Jul 7 at 8:05
PostgreSQL is running locally but I cannot connect. Why?
Awarded Jul 7 at 2:30
1 2 3 4 5 … 193