Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

  7. current community

    your communities

    more stack exchange communities

    company blog
Database Administrators

Help Center > Badges > Scholar

 Scholar
Ask a question and accept an answer.
Awarded 18727 times.
How can I restore a master database from its bak file?
Awarded 8 hours ago
How do I select the count of a specific value without grouping in postgresql?
Awarded 20 hours ago
In PostgresQL, how do I make a query match exactly one row or fail?
Awarded 21 hours ago
MySQL - Can we use the same temporary table name in different stored procedure?
Awarded yesterday
SQL join multiple “id” columns from a single row to another table
Awarded yesterday
Using MySQL Workbench 8 on RHEL7 gui - When I highlight text in the SQL editor it turns black
Awarded 2 days ago
How to Return Zero Values In Group Query
Awarded 2 days ago
What is using all my space?
Awarded 2 days ago
How can i select columns from two tables using REF
Awarded Jun 13 at 23:20
PostgreSQL 9.6: Update on a single row table takes an unreasonable amount of time
Awarded Jun 13 at 14:55
Extracting data from extremely large csv files [on hold]
Awarded Jun 13 at 14:45
Sync Server Objects when having two or more Availability Groups
Awarded Jun 13 at 14:05
I need to run a procedure that goes through all schemas tables in MySQL server [on hold]
Awarded Jun 13 at 12:15
Show backups at server level
Awarded Jun 13 at 9:05
Installed Oracle XE 11.2. How do I create a database?
Awarded Jun 12 at 17:15
pg_stat_statements empty with administrator user and unusable for other users
Awarded Jun 12 at 16:45
Hierarchical data: get all nodes from a hierarchy, including parents that don't match the where
Awarded Jun 12 at 16:00
How to select id of father from the child id recursively
Awarded Jun 12 at 14:05
Run Querys on List of Databases (For Each loop?)
Awarded Jun 12 at 13:10
UPDATE table using CTE
Awarded Jun 12 at 13:00
MySQL replication slave using percona and docker
Awarded Jun 12 at 12:00
PostgreSQL : cannot connect with a created role
Awarded Jun 12 at 10:00
SQL Server Import/Export: cannot copy geo columns
Awarded Jun 12 at 7:45
I need to create query connect 3 tables with Many to Many relationship in MariaDb
Awarded Jun 12 at 7:20
In a MySQL cursor, will it be possible to skip an iteration or row of the cursor?
Awarded Jun 11 at 18:15
Is it good practice to create tables dynamically?
Awarded Jun 11 at 16:50
select top 5 accounts in each region in an month per sales
Awarded Jun 11 at 16:40
PostgreSQL multiple column foreign key [closed]
Awarded Jun 11 at 16:05
Set default scheme in Redshift
Awarded Jun 11 at 16:00
Slow performance on partitioned PostgreSQL table when using now() to filter
Awarded Jun 11 at 13:40
SqlPackage.exe unnecessarily drops and recreates indexed view with schemabinding
Awarded Jun 11 at 8:30
found xmin X from before relfrozenxid Y during vacuum
Awarded Jun 11 at 7:55
SSIS Create New Folders On The Fly When Writing To A Flat File Connection
Awarded Jun 10 at 13:35
MongoDB replica set quorum config (network partitioning behaviour)
Awarded Jun 10 at 12:55
SQL SERVER 2014 FCI Cluster taking too long to failover
Awarded Jun 10 at 12:50
How to shutdown mongodb sharded cluster temporary
Awarded Jun 10 at 6:20
Optimize MySQL query and index for multiple column range query
Awarded Jun 9 at 23:55
Postgres: why did this trigram index slow down regexp queries?
Awarded Jun 9 at 9:10
What is the correct way to select rows from either side of a bridge table?
Awarded Jun 8 at 21:45
Sql Server delete syntax
Awarded Jun 8 at 18:00
MySQL 5.7 statistics - Change db
Awarded Jun 8 at 14:50
How to store time values (without date parts) in Oracle? [closed]
Awarded Jun 8 at 11:55
mysql slave restore database ERROR 3079
Awarded Jun 8 at 6:30
SQL Server 2016 SP1 + strategy for long term version retention (snapshots, temporal tables, other?)
Awarded Jun 8 at 0:50
configure new linked server from SQL Server 2016 to Oracle 12c
Awarded Jun 7 at 20:00
Why does this query, missing a FROM clause, not error out?
Awarded Jun 7 at 18:00
Split the results of a query into parts
Awarded Jun 7 at 17:15
LOG backup Always ON using Ola Hallengren database backup script does not carry out a backup
Awarded Jun 7 at 14:25
Slow performance on postgres query with count/sort
Awarded Jun 7 at 9:30
Change default collation for character set utf8mb4 to utf8mb4_unicode_ci
Awarded Jun 7 at 8:35
SQL Server default collation vs database with different collation - potential problems?
Awarded Jun 7 at 7:45
Reviewing the design of a database about animals of two distinct species
Awarded Jun 7 at 2:05
SQL Server Schema and login name
Awarded Jun 7 at 1:45
How can I get the page size of a Postgres database?
Awarded Jun 6 at 15:20
Does SELECT remove dead rows like VACUUM does?
Awarded Jun 6 at 14:55
Limit left join for multiple rows
Awarded Jun 6 at 12:40
Get the Largest Count of Consecutive Value
Awarded Jun 6 at 8:40
Cassandra multi-DC:write on LOCAL and read from any DC
Awarded Jun 6 at 8:05
How to find the count of words (all and unique) in a column row-wise?
Awarded Jun 6 at 7:00
Horizontal and Vertical Fragmentation on Distributed Database
Awarded Jun 6 at 3:40
1 2 3 4 5 … 313