Database Administrators

Scholar

 Scholar
Ask a question and accept an answer.
Awarded 22255 times.
Match closest date from a table to a table with just dates
Awarded 7 hours ago
Use previous state of data
Awarded 8 hours ago
Using same table in a UNION multiple times
Awarded 8 hours ago
MySQL: How to set the default string using another field by string-interpolation?
Awarded 8 hours ago
Use CTE to fetch most recent row for each ID
Awarded 16 hours ago
How to select sub-object with given keys from JSONB?
Awarded 21 hours ago
Postgres view role permissions
Awarded 23 hours ago
Installing Oracle 19c server on Windows 7
Awarded yesterday
“Percona-XtraDB-Cluster prohibits use of ALTER command on a table (<example>) that resides in non-transactional storage engine”
Awarded yesterday
Check if contract conflict with another contract query
Awarded yesterday
Does using PK and FK effect performance in negative way?
Awarded yesterday
Different (much worse) query plan when using one view
Awarded yesterday
How Restore backup as overwrite on a database in use in SQL Server?
Awarded 2 days ago
Subqueries in SQL Server
Awarded 2 days ago
mysql: ERROR 1040 (HY000): Too many connections and can't restart because of Error: 28 (No space left on device) [closed]
Awarded 2 days ago
Is using strings as keys for reference to other tables bad in terms of memory usage?
Awarded Apr 18 at 11:53
Interval values for aggregate function AVG greater than 24 hours
Awarded Apr 17 at 23:46
How to Cast today data as bigint to Data - 202104171830
Awarded Apr 17 at 13:48
Joining three tables with null values in SQL
Awarded Apr 17 at 11:57
Upgrade to 10.3 resulted in deleting configuration from old version
Awarded Apr 17 at 8:47
Update new column with previous column value
Awarded Apr 17 at 6:58
How to make large “in” queries in C# for an indexed field in MSSQL?
Awarded Apr 16 at 23:46
Invalid Column Name on CONCAT_WS
Awarded Apr 16 at 21:45
How to test user permissions
Awarded Apr 16 at 11:48
How to break down MySQL big table into multiple to solve operational issue
Awarded Apr 16 at 5:34
table organization with data that will never change
Awarded Apr 16 at 2:49
VM'd a SQL server, having trouble with external HDDs
Awarded Apr 15 at 17:59
How do I debug Postgres' join strategy?
Awarded Apr 15 at 1:46
How do I CAST a date in a subquery? Currently getting an error: Conversion failed when converting date and/or time from character string
Awarded Apr 14 at 19:48
Why does RDS PostgreSQL always recover on restart?
Awarded Apr 14 at 18:57
How to get a count of how often a name/string appears
Awarded Apr 14 at 9:48
How to find the counts of word occurrences in a column?
Awarded Apr 13 at 20:50
PostgreSQL: Insert into JSONB key failing with syntax error at or near “->>”
Awarded Apr 13 at 17:46
How do I identify functional dependencies and normalize a table based on the attributes?
Awarded Apr 13 at 13:36
INSERT-ing to a table if the the data does not already exits - how do indexes peform in this scenario?
Awarded Apr 13 at 13:36
Can CTE simplify repeated and possibly recursive joins?
Awarded Apr 13 at 10:05
MySQL - how to dynamically add columns with subquery in Select clause based on date range
Awarded Apr 13 at 9:36
MySql ORDER BY slow with join, fast as 2 queries
Awarded Apr 13 at 8:57
Checking if entities match an id in on relation where it could show up in either of two columns
Awarded Apr 13 at 7:42
I am wanting to use UDTT in my database, but we have CLR turned off, and according to the docs for create type, all types require a CLR assembly
Awarded Apr 12 at 22:32
text unique to the grain should be stored in fact table or dimension table?
Awarded Apr 12 at 21:51
Row Level Trigger for insert/update to a table
Awarded Apr 12 at 20:18
Oracle SQL - How to group by a column and count other column for each different value?
Awarded Apr 12 at 14:05
3 Simple Queries SQL Student Question, Query Errors in Microsoft Access
Awarded Apr 12 at 10:04
How to write a query for exact pairs of groups
Awarded Apr 11 at 16:27
Postgresql script doesn't work as I expect
Awarded Apr 11 at 15:33
mysqld_pre_systemd fails when starting MySQL on Fedora
Awarded Apr 10 at 10:16
Add constraint to table creation in SQL
Awarded Apr 9 at 23:21
Filtering Escape Characters in PostgreSQL
Awarded Apr 9 at 13:18
Selecting data from a mapping table using a foreign key
Awarded Apr 9 at 8:49
Recursively find the path to all leaves descending from a given parent in a tree
Awarded Apr 9 at 7:10
Need help designing database, Create a table with additional columns/fields in the table, or create a new table for each different type?
Awarded Apr 8 at 23:31
What are the performance implications of using uuid as primary key in Postgres 10.12? (need canonical answer) [duplicate]
Awarded Apr 8 at 21:57
What is the fastest way to make a copy of a 5TB SQL Server DB on the same server without having to fully reinitialize the DB to add it to the AG
Awarded Apr 8 at 17:56
DB2 for i equivalent of MSSQL's Show Query Execution Plan
Awarded Apr 8 at 15:55
Postgresql: How to pass an array to trigger function in TG_ARGV?
Awarded Apr 8 at 13:40
Count between dates and operate between rows - SQL [closed]
Awarded Apr 8 at 12:48
Clone a database from SQL Server 2019 to 2017 [duplicate]
Awarded Apr 8 at 12:25
alter compatibility level
Awarded Apr 7 at 16:10
Consolidate / sort / combine / merge data for dummies
Awarded Apr 7 at 15:18
1
2 3 4 5
…
371

Your privacy

By clicking “Accept all cookies”, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy.