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 > Editor

 Editor
First edit.
Awarded 19795 times
Count rows in a table based on a DATE field
Awarded 8 hours ago
Which DB design is better and why?
Awarded 11 hours ago
Adding Substring in a join query in MSSQL
Awarded 13 hours ago
WHERE IN query to very large table is slow
Awarded 21 hours ago
Need advice for my first design of database in MYSQL
Awarded 21 hours ago
Identify proper index for group and order by date and hour (2 columns)
Awarded yesterday
postgresql - trouble to order a list obtained by string_agg
Awarded yesterday
mysql large number of opened tables — what does this mean and how can I reduce?
Awarded yesterday
MongoDB: Approach for storing frequently modified references
Awarded 2 days ago
Use mysqldump to backup table with a new table name
Awarded 2 days ago
Incorrect GrantedQueryMemory(KB) Value in SSMS Dashboard report
Awarded 2 days ago
Database design for ~ 2.7B records per year / 26.000 data points every five minutes
Awarded 2 days ago
List of databases which a user can access in SQL 2008 R2
Awarded 2 days ago
one to many relation how to create a new row with mysql trigger
Awarded 2 days ago
5M+ rows on a view
Awarded 2 days ago
Is PRIMARY(ColumnA, ColumnB) + INDEX(ColumnB) + PARTITIONING(ColumnB) redundant?
Awarded 2 days ago
error while trying to retrieve text for error ORA-12154
Awarded 2 days ago
How to get all dates belonging to a timestamp range
Awarded 2 days ago
Trying to SUM two separate columns but not together as part of a search result - Updated
Awarded 2 days ago
how to stop OracleRemExecServiceV2 from cmd?
Awarded 2 days ago
Is there a good database that I can use for Web/Android/iOS development?
Awarded 2 days ago
Cannot configure nor start MySQL
Awarded Mar 21 at 4:45
mysql trigger before insert
Awarded Mar 21 at 3:35
Select rows with the same value in multiple columns
Awarded Mar 21 at 0:30
Stop long running scheduled job
Awarded Mar 20 at 21:45
How to workaround Postgres foreign data wrapper not supporting INSERT with an ON CONFLICT
Awarded Mar 20 at 21:30
How do I force windows to use a specific version of SQLCMD?
Awarded Mar 20 at 19:00
SQL Server Instance Root Directory & Shared Feature Directory on Partition with 64k Allocation Unit Size?
Awarded Mar 20 at 18:35
MySQL replication with no connection
Awarded Mar 20 at 16:05
Unable to call PASSWORD() with VARCHAR() parameter inside a procedure
Awarded Mar 20 at 16:05
SQL dump loads with Error 1064
Awarded Mar 20 at 14:30
Optimize queries that need to be 100% ACID compliant but can tolerate latency in persistence
Awarded Mar 20 at 12:10
Flatten multiple tables into a single large table [on hold]
Awarded Mar 20 at 10:25
Mysql Alter table add column with ALGORITHM=INPLACE, LOCK=NONE
Awarded Mar 20 at 8:10
MongoDB - Mongorestore is not working as expected
Awarded Mar 20 at 7:30
delay advice - Huge resultset
Awarded Mar 20 at 1:00
Innodb cluster setup error
Awarded Mar 19 at 16:40
Query State hangs on sending data
Awarded Mar 19 at 14:40
SQL Server Logical IO Block Sizes and Physical Reads
Awarded Mar 19 at 13:10
Add Constraint to check value exists in a non-unique composite key column
Awarded Mar 19 at 12:25
Added .Net assembly to SQL CLR without turning TRUSTWORTHY ON
Awarded Mar 19 at 10:30
Can't cancel query in Redshift
Awarded Mar 19 at 10:10
Differences of MySQL locking for update with WHERE and IN
Awarded Mar 19 at 9:35
MySQL query for free Date time slot availability
Awarded Mar 19 at 8:45
Parameterized Plan Flushed
Awarded Mar 18 at 17:25
PRODUCTION DATABASE RUNNING OUT OF SPACE [closed]
Awarded Mar 18 at 17:05
MariaDB: *.mad file causes full disc space [on hold]
Awarded Mar 18 at 15:45
Proper way to map IDs: By adding additonal columns for each external column or by inserting new rows
Awarded Mar 18 at 14:25
How do I add a directory, or bulk, of users to Microsoft SQL Server permissions
Awarded Mar 18 at 12:45
How to create stored procedure involving wildcards? [on hold]
Awarded Mar 18 at 9:15
MySQL reporting version mismatch due to picking up previous installation
Awarded Mar 18 at 8:10
Generic TVP tradeoffs?
Awarded Mar 17 at 17:20
Optimizing read query in PostgreSQL
Awarded Mar 17 at 14:40
T-SQL LIKE Predicate failed to match with whitespace in XML converted varchar
Awarded Mar 17 at 11:40
Default phpMyAdmin Login Credentials
Awarded Mar 17 at 8:50
Loading Data from CSV file or Staging Table to Multiple tables - SQL Server 2014
Awarded Mar 17 at 7:15
How do I set up a query for Google sheets? [closed]
Awarded Mar 16 at 7:20
Deleting duplicates with group by and count
Awarded Mar 16 at 3:40
Unknown column “X” in field list on delete, but the column exists
Awarded Mar 15 at 20:10
For states (col) receiving exactly X number of items (row), sort the items by weight (col)
Awarded Mar 15 at 19:00
1 2 3 4 5 … 330