Database Administrators

Scholar

 Scholar
Ask a question and accept an answer.
Awarded 25337 times.
Find out what encryptor name my database is using
Awarded Jul 7, 2019 at 5:50
Find exact and partial matches in the tables
Awarded Jul 6, 2019 at 10:20
Update all values in a column with individual values
Awarded Jul 6, 2019 at 0:55
Separate values into multiple columns
Awarded Jul 5, 2019 at 17:15
Query to collect the recent unique TimeSampled rows using inner joins for multiple servers in MS SQL [duplicate]
Awarded Jul 5, 2019 at 11:00
List of databases which a user can access in SQL 2008 R2 [duplicate]
Awarded Jul 5, 2019 at 7:35
How to create two additional columns in a results set to act as axis for a heatmap
Awarded Jul 5, 2019 at 7:25
Long Relational Algebraic expression provided than actually required
Awarded Jul 5, 2019 at 0:20
Should I use the LIKE predicate or fetch all rows and process them on the client?
Awarded Jul 4, 2019 at 18:05
Oracle Custom Sequence of a partitioned group (Insert trigger)
Awarded Jul 4, 2019 at 15:50
What's the smartest way to find the scale of an unrestricted numeric type?
Awarded Jul 4, 2019 at 12:30
PostgreSQL. Unstable execution time hugely exceeding planning time
Awarded Jul 4, 2019 at 9:45
SQL Compare data from two joined tables
Awarded Jul 4, 2019 at 8:25
AWS DMS - How to select different databases for source and target points for a task
Awarded Jul 4, 2019 at 6:05
Load data from a temporal table to another temporal table in Azure
Awarded Jul 4, 2019 at 5:10
`cube` query performance issues with ordering
Awarded Jul 3, 2019 at 18:00
Mysql 8 ST_GeomFromText giving error Latitude out of range in function st_geomfromtext. It must be within [-90.000000, 90.000000]
Awarded Jul 3, 2019 at 17:10
Combining array_agg and unnest
Awarded Jul 3, 2019 at 15:20
How to avoid DROP TABLE for a specific MySQL table
Awarded Jul 3, 2019 at 12:45
Named point in the transaction log? Does it exist?
Awarded Jul 3, 2019 at 9:45
syntax error at or near "AS" [closed]
Awarded Jul 3, 2019 at 6:25
Left join including nulls
Awarded Jul 3, 2019 at 4:40
Is it possible to change the color of relationship lines in MySQL Workbench diagrams?
Awarded Jul 3, 2019 at 1:35
In what order MySQL permissions are applied on database?
Awarded Jul 2, 2019 at 22:20
How to query in such a way that values becomes columns? [duplicate]
Awarded Jul 2, 2019 at 20:10
How can I make this execution plan more efficient?
Awarded Jul 2, 2019 at 20:05
Improve time for Select first 10 Rows of a Table with 10 Million Rows Postresql
Awarded Jul 2, 2019 at 14:20
PostgreSQL: relation would be inherited from more than once
Awarded Jul 2, 2019 at 13:35
How can i replicate many database into one, by avoid primary key collision?
Awarded Jul 2, 2019 at 10:50
Postgres select using lateral
Awarded Jul 2, 2019 at 8:55
Getting 2 columns from sets of 2 rows in Postgresql
Awarded Jul 2, 2019 at 7:35
Updating values in table based on ranges defined in another table
Awarded Jul 2, 2019 at 3:40
Varchar storage and performance
Awarded Jul 1, 2019 at 13:15
how to get content from a TEXT column in mysql? [closed]
Awarded Jul 1, 2019 at 12:30
In Postgres txid_current() should return biginteger but instead an integer is returned
Awarded Jul 1, 2019 at 0:55
In Oracle 12c, how can we implement pagination on large table using rowid?
Awarded Jun 30, 2019 at 12:50
missing initSID.ora
Awarded Jun 29, 2019 at 3:35
Dynamic SQL query - how do I add an int to the code?
Awarded Jun 28, 2019 at 12:05
Connecting to SQL Server with SQL Server Management Studio
Awarded Jun 28, 2019 at 7:10
What is the best way to design one-to-many relationship with null value?
Awarded Jun 28, 2019 at 7:05
Postgres choosing a filter instead of index cond when OR is involved
Awarded Jun 28, 2019 at 6:05
Finding the total sum of salary for person who worked at least two years
Awarded Jun 28, 2019 at 4:45
postgres - c <parameter> = <value> not working for postgres 11 in docker
Awarded Jun 27, 2019 at 19:00
Should I normalize a relational database design if I know the data will never be updated?
Awarded Jun 27, 2019 at 18:05
MySQL using more memory than expected
Awarded Jun 27, 2019 at 17:00
How to get count 0 using group by if record not exist?
Awarded Jun 27, 2019 at 16:05
The publication 'My_publication' doesn't exist?
Awarded Jun 27, 2019 at 16:00
Multiple mariadb instances - how to access to the not default instances via command line?
Awarded Jun 27, 2019 at 8:35
How to Natively Return Output when using Invoke-Sqlcmd?
Awarded Jun 26, 2019 at 19:25
Moving a hard disk with PostgreSQL data folder to another server
Awarded Jun 26, 2019 at 15:25
it’s safe to run mysqltuner on production server
Awarded Jun 26, 2019 at 13:25
How can SQL Server 2016 deadlock with a pagelock on two different tables?
Awarded Jun 26, 2019 at 13:05
Three WHERE slow query down
Awarded Jun 26, 2019 at 12:30
Postgresql Vacuum and replication
Awarded Jun 26, 2019 at 6:45
giving users select-only permissions of database objects
Awarded Jun 25, 2019 at 23:00
Need help in picking solution and understanding when to add columns vs EAV
Awarded Jun 25, 2019 at 18:50
why the processing is sometimes terminated , sometimes not
Awarded Jun 25, 2019 at 13:40
Query to filter a table based on a comparison applied to the same table?
Awarded Jun 25, 2019 at 13:00
Transaction log is full (due to NOTHING)... but this database is in simple recovery mode
Awarded Jun 24, 2019 at 21:15
How to Import an Oracle dump version 5.1 into 12c?
Awarded Jun 24, 2019 at 19:40
1
…
109 110
111
112 113
…
423