Skip to main content
Database Administrators

Popular Question

 Popular Question
Question with 1,000 views. This badge can be awarded multiple times.
Awarded 47608 times.
What's the best way performance-wise to SELECT from a PARTITIONed table in MySQL: explicit partition selection, pruning with a WHERE clause, or both?
Awarded Nov 14 at 8:35
Merging data from identical tables from multiple databases into one larger table. N-1 table replication
Awarded Nov 14 at 1:40
MySQL 8.0.15 starts normally but any connection hangs
Awarded Nov 13 at 20:53
Should I re-use a database connection or create new collections while closing old ones? social media
Awarded Nov 13 at 18:56
BULK INSERT from DFS shared folder using Kerberos
Awarded Nov 13 at 17:57
Why is SQL server dropping the seconds of values passed to a SMALLDATETIME field?
Awarded Nov 13 at 17:36
SQL Server 2019 CU22 error Using 'dbghelp.dll' version '4.0.5' & non-yielding on Scheduler
Awarded Nov 13 at 15:40
can be NULL same as 0000-00-00 in a nullable DATETIME column while selecting rows?
Awarded Nov 13 at 12:42
Many MYSQL processes on Linux
Awarded Nov 13 at 10:21
pglogical: list Schema/table part of the replication sets?
Awarded Nov 13 at 4:35
FATAL: the database system is in recovery mode
Awarded Nov 13 at 2:37
MySQL - Key Column Doesn't Exist in Table
Awarded Nov 12 at 17:42
View to insert records into history table and then find changes with Except query
Awarded Nov 12 at 12:41
Group by every N records but remove incomplete group that has records less than N
Awarded Nov 12 at 12:17
Does a SQL Server update nvarchar statement overwrite the same address on disk if the new value is the same size?
Awarded Nov 12 at 11:56
Move Oracle to new drive
Awarded Nov 12 at 11:10
Error 9002 - State 4, Class 17: SQL Server reports full transaction log
Awarded Nov 12 at 10:11
wrong value when storing big float value
Awarded Nov 12 at 9:57
Updating column having index causing Deadlock
Awarded Nov 12 at 8:56
Can't rely on INFORMATION_SCHEMA.view_definition?
Awarded Nov 12 at 2:47
Question about set log_slow_verbosity='query_plan' in MariaDB ans MySQL
Awarded Nov 11 at 21:33
Unable to connect to cluster with cqlsh on localhost
Awarded Nov 11 at 20:56
MySQL - Get maximum Tuple without Grouping everything
Awarded Nov 11 at 19:47
How to store file paths, which collation to use?
Awarded Nov 11 at 18:21
.NET executes a SQL query and Active Monitor shows multiple rows blocking each other
Awarded Nov 11 at 12:55
Cassandra nodes removal, most appropriate strategy?
Awarded Nov 11 at 11:40
Why tsquery containing a hyphen isn't found in full text search?
Awarded Nov 11 at 11:07
PostgreSQL cluster has two primary databases after network glitch
Awarded Nov 11 at 1:21
Free some space on a full Express Edition instance
Awarded Nov 10 at 20:41
What is the correct and performant pattern for loading (and querying) a large clustered columnstore table?
Awarded Nov 10 at 20:41
A column value depends on the values of two other columns, of which exactly one is nullable
Awarded Nov 10 at 20:26
Query returns duplicate records
Awarded Nov 10 at 13:18
Will AlwaysOn work with hundreds of databases in 1 group/multiple groups?
Awarded Nov 10 at 5:04
Limiting PostgreSQL logging
Awarded Nov 9 at 23:26
How do I get the clients connected to a Cassandra instance?
Awarded Nov 9 at 11:40
SELECT all the children of a row and concat
Awarded Nov 8 at 19:57
How to ensure backups are successfully persisted to S3 when using Ola Hallengren solution on AWS EC2 Instances
Awarded Nov 8 at 19:26
The SELECT permission was denied on the object '__EFMigrationsHistory', database 'master', schema 'dbo'
Awarded Nov 8 at 19:03
MySQL, would like to get both a field and a count inside GROUP_CONCAT
Awarded Nov 8 at 17:36
What Other Information Is Stored in The Page Header
Awarded Nov 8 at 14:27
Need listing of all relationships of tables SQL Server 2017
Awarded Nov 8 at 12:25
InnoDB index concurrent inserts
Awarded Nov 8 at 11:26
Postgresql Logical replication initial slot snapshot too large
Awarded Nov 8 at 9:50
SQL Server Always-On adding database fails with insufficient free space
Awarded Nov 8 at 8:40
Selecting top 10 from indexed field of a big table takes too long
Awarded Nov 8 at 8:33
MySQL: check max chracter length (ERROR 1118 (42000): Row size too large)
Awarded Nov 8 at 7:13
Problem installing Oracle 19c to symlinked directory from RPM
Awarded Nov 8 at 5:34
How to change PostgreSQL IP address for streaming replication [closed]
Awarded Nov 7 at 22:53
Galera cluster node fails with error. Brand new cluster + master / node. Access denied or can't connect
Awarded Nov 7 at 19:00
Why is Postgres so slow to order those 200 rows that are already ordered?
Awarded Nov 7 at 19:00
Should the Query Store be enabled on all databases?
Awarded Nov 7 at 18:19
Procedures using TVPs are slower when the TVP numeric value gets larger?
Awarded Nov 7 at 16:51
How do you partition an events table by a time based off the datediff(Lag,time)?
Awarded Nov 7 at 16:20
How to update each value in an array with a function?
Awarded Nov 7 at 15:42
Counting duplicate instances within column in SQL when grouping by another column
Awarded Nov 7 at 15:26
I want to find the max number of characters of all varchar and nvarchar columns in DB
Awarded Nov 7 at 13:10
How to prevent Dropping of tables but allow Creating of them, within a Schema
Awarded Nov 7 at 10:15
The term Database Migration
Awarded Nov 7 at 10:02
How to count multiple occurences on the same date
Awarded Nov 7 at 9:12
Can't start asm filter driver
Awarded Nov 6 at 18:19
1 2 3
4
5
…
794