Database Administrators
Sponsored by
Sponsored logo

Popular Question

 Popular Question
Question with 1,000 views. This badge can be awarded multiple times.
Awarded 36913 times.
Is a relation with two attributes always in Boyce-Codd Normal Form (BCNF)?
Awarded 4 hours ago
Trigger to prevent insertion of duplicate data
Awarded 4 hours ago
Backend Table/Row Locking Structure using CTE Queries
Awarded 5 hours ago
Ola Hallengren with database mirroring
Awarded 5 hours ago
PostgreSQL functions inside where clause
Awarded 7 hours ago
Msg 6355 "Conversion of one or more characters from XML to target collation impossible" when querying sys.dm_exec_query_plan
Awarded 8 hours ago
ANSI Joins in Oracle
Awarded 8 hours ago
Simple "SELECT" query taking too long
Awarded 8 hours ago
Does Oracle randomly switch execution plans to check if there is a better solution?
Awarded 10 hours ago
TokuDB database size unknown in phpmyadmin
Awarded 10 hours ago
Need to move TempDB to another drive. But its files cannot be dropped or shrunk
Awarded 10 hours ago
Cursor never stops
Awarded 11 hours ago
Postgresql Replica is in sync but repmgr says node unattached
Awarded 12 hours ago
Why did the "Bypass Traverse Checking" permission fix my issue?
Awarded 13 hours ago
Recommended way: "SELECT *" vs "SELECT COLUMN_LIST" from same table, multiple times
Awarded 17 hours ago
SQL Server expensive nested loops join and lazy table spool
Awarded 18 hours ago
PostgreSQL-13 The connection pool has been exhausted
Awarded 19 hours ago
Does InnoDB allow adding columns to a table with concurrent READ/WRITE of rows?
Awarded 19 hours ago
Does partitioning a MySQL table also increase index creation performance?
Awarded 23 hours ago
Best way to automate the loading of data daily into google big query from SQL Server
Awarded yesterday
TiDB vs Vitess - How should I base my decision?
Awarded yesterday
Can a MySQL 5.6 master replicate to a 5.7 slave, which in turn replicates to a MySQL 8 slave?
Awarded yesterday
Postgres Query Array Column with Array
Awarded yesterday
Can I GRANT SELECT on all schemas in a database?
Awarded yesterday
Mysql cannot import from text file
Awarded yesterday
Match string pattern to any array element
Awarded yesterday
Postgresql: How to optimize performance of a query which uses CTEs and has a jsonb column?
Awarded yesterday
Why pg_wal dir does not clean up while logical replication
Awarded yesterday
mysqldump all database including user/password and grants
Awarded yesterday
How to add query hint inside a view
Awarded yesterday
foreign key on multiple tables based on multiple columns
Awarded yesterday
What happens in Microsoft SQL Server 2012 .ldf when the database log file if full?
Awarded yesterday
MongoDB : How to Convert a Standalone to a Replica Set
Awarded yesterday
SUM counts from parent and child
Awarded yesterday
Batch update timestamp records to correct timezone
Awarded yesterday
DBForge can't connect with MySQL server, server is running
Awarded yesterday
How did you split strings before string_split()
Awarded yesterday
Using slash in MySQL database
Awarded yesterday
select string that doesn't contain a substring/field
Awarded yesterday
SSL Configuration fails with a warning MySQL 8.0
Awarded 2 days ago
SQL Server Availability Group LeaseTimeout and slow IO
Awarded 2 days ago
What happens when there's no tempdb space for version store operations?
Awarded 2 days ago
Can indexing be a solution to SQL deadlocks that are caused due to lock resources?
Awarded 2 days ago
SQL server Import CSV file - 1'st row is also added as s column name
Awarded 2 days ago
Grant rights to create a table with an identity column on another schema
Awarded 2 days ago
Change left outer join on SAP Universe Design Tools
Awarded 2 days ago
Upgrade Antelope to Barracuda on Slave
Awarded 2 days ago
PostgreSQL 'server closed the connection unexpectedly' when using the hostname (Azure VM)
Awarded 2 days ago
Getting Nested query result from Cosmos DB with property named "Value"
Awarded 2 days ago
Creating same unique constraint with different names
Awarded 2 days ago
jsonb and numeric precision and scale
Awarded May 16 at 22:16
Job Information - When querying [msdb].[dbo].SYSJOBS_VIEW through linked server
Awarded May 16 at 20:07
Upgrade MongoDB Community to Enterprise
Awarded May 16 at 17:51
SQL Developer export/import SSH hosts
Awarded May 16 at 8:12
1 hour query, is there another way to do this?
Awarded May 15 at 19:26
How to insert a row from JSON in Postgres
Awarded May 15 at 15:27
PostgreSQL/PostGIS 9.6 broke my compound index
Awarded May 15 at 8:36
T-SQL - OPTION (FAST x) and trace flag 8722
Awarded May 14 at 16:50
SQL connection error in python webapp: "pandas.io.sql.DatabaseError: Execution failed on sql"
Awarded May 14 at 9:22
Executing 'GRANT SELECT' in a trigger possible?
Awarded May 14 at 4:17
1
2 3 4 5
…
616

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.