Skip to main content
Database Administrators

Famous Question

 Famous Question
Question with 10,000 views. This badge can be awarded multiple times.
Awarded 9221 times.
pg_restore hangs in terminal indefinitely with zero output in verbose mode
Awarded 18 hours ago
Understanding thread pool and max connection in mariadb
Awarded 18 hours ago
Multiple service_name and hosts with same alias
Awarded 19 hours ago
How can I grant permissions on tables created in the future to members of a particular role?
Awarded yesterday
SQL Server Setup failure - Cached MSI files are missing
Awarded yesterday
SET LOCK_TIMEOUT, is it session or statement based?
Awarded 2 days ago
Failed to deploy the project. Try again later. (Microsoft SQL Server, Error: 27118)
Awarded May 6 at 23:47
PostgreSQL - how to list all UNIQUE indexes for specific database?
Awarded May 6 at 14:26
Not equal to operator is not returning NULL values in SQL Server
Awarded May 5 at 14:35
What is controlling SQL Server's page file usage? SQL Server or Windows?
Awarded Apr 27 at 2:23
SQL Error: OA-12991 - Unable to Drop a Column after removing all referenced Multi-Column constraints
Awarded Apr 25 at 22:10
How to transfer PSQL users and roles to another database
Awarded Apr 25 at 17:06
MariaDB - "ERROR 1205 ... Lock wait timeout exceeded; ..." when doing multiple parallel UPDATEs affecting different rows
Awarded Apr 25 at 11:02
Import large .sql file to pgAdmin4
Awarded Apr 24 at 21:12
Traversing tree-like data in a relational database using SQL
Awarded Apr 24 at 14:10
How to sum (aggregate) all the values in a key/value JSONB?
Awarded Apr 23 at 14:50
PostgreSQL NOT IN array slow query
Awarded Apr 21 at 14:56
How to determine whether a PostgreSQL Hot Standby is fully mirrored?
Awarded Apr 18 at 5:52
Multi-row insert vs transactional single row inserts
Awarded Apr 17 at 12:05
How to set the timeoffset in a Datetimeoffset column without changing the date part
Awarded Apr 17 at 10:33
How does like query work with indexed table
Awarded Apr 17 at 9:02
how to change the file directory of your log and data files and what are the effects
Awarded Apr 15 at 15:06
No Implicit Conversion Between UNIQUEIDENTIFIER and VARCHAR After Removing a Persisted Computed Column
Awarded Apr 15 at 13:38
MySQL Replication Lag Check
Awarded Apr 9 at 10:16
Can converting MyISAM to InnoDB cause problems?
Awarded Apr 8 at 19:10
How can I tell what recovery model my SQL database has?
Awarded Apr 8 at 16:16
How to optimize this Select MAX() SQL query?
Awarded Apr 7 at 11:42
Why might a parallel pg_restore command take hours longer to complete its non-parallel equivalent?
Awarded Apr 7 at 7:36
mysql ERROR 1205: 1205: Lock wait timeout exceeded; try restarting transaction
Awarded Apr 4 at 8:03
How to estimate the size of a PostgreSQL DB to be dumped through pg_dump
Awarded Apr 2 at 20:14
SQL Server Error, "Invalid usage of the option FIRST in the FETCH statement."
Awarded Mar 31 at 8:40
sys.sp_reset_connection. Why theres a lot of them ?
Awarded Mar 31 at 2:12
Storing bus routes in a database
Awarded Mar 29 at 8:52
Identify the type of a SQL Server backup
Awarded Mar 28 at 17:06
How can I remove a channel from replication slave?
Awarded Mar 28 at 9:40
Can partitioning help speed up inserts on a very large table?
Awarded Mar 27 at 17:53
MySQL's maximum memory usage is dangerously high
Awarded Mar 27 at 9:47
Lookup table naming convention? [closed]
Awarded Mar 27 at 9:47
Grant users privilege to use QUERYTRACEON 9481
Awarded Mar 25 at 15:21
Selecting distinct rows from two tables, using multiple conditions
Awarded Mar 25 at 13:50
What is DBCC SHRINKFILE actually doing?
Awarded Mar 25 at 9:40
Oprhaned entries in msdb..sysjobactivity
Awarded Mar 24 at 20:56
Grant CREATE SCHEMA (only) to users
Awarded Mar 24 at 16:04
PostgreSQL: How does COPY FROM behave inside a transaction?
Awarded Mar 24 at 7:57
How to unpack a DACPAC?
Awarded Mar 23 at 13:52
How can I set a column to NOT NULL without locking the table during a table scan?
Awarded Mar 21 at 15:22
Restore database according to editions
Awarded Mar 20 at 16:05
Find tables with modified data after a specified datetime [duplicate]
Awarded Mar 19 at 18:37
Efficient query for an advanced EAV model
Awarded Mar 18 at 20:07
Calculating average with AVG for a list of numbers
Awarded Mar 18 at 14:34
Remove the log shipping configuration on the secondary server, when the primary is no longer available
Awarded Mar 18 at 12:50
PostgreSQL - How to list all foreign key link to Primary key of a table
Awarded Mar 18 at 10:48
How to make middle and suffix matching using full text search?
Awarded Mar 14 at 17:51
Split CLOB into multiple VARCHAR2
Awarded Mar 13 at 16:56
Where is the SQLS database backup virtual device string stored in the system tables?
Awarded Mar 13 at 8:37
How to select from a table without including repeated column values?
Awarded Mar 13 at 8:37
Why does SQL Server fail to create a procedure referencing a linked server?
Awarded Mar 12 at 11:28
SQL Server - Adding non-nullable column to existing table - SSDT Publishing
Awarded Mar 11 at 17:17
Capturing queries run by user on SQL Server using extended events
Awarded Mar 11 at 14:05
Query Multiple SQL Server Instances using Powershell referencing the list of instances in a text file
Awarded Mar 11 at 12:35
1
2 3 4 5
…
154