dba

dba

📝Sub queries or joins?

📝Getting Skewed Results from LEFT OUTER JOIN with 3 TABLES

📝Indexing or changing one-to-many relationship

📝11gR2 didn't ask me to set username or any password

📝How to disable HTML output in mysql console?

📝How to find the current value for 'log_history' of PURGE_LOG job in Oracle

📝What could possibly cause a numeric overflow when enqueuing an Oracle AQ message?

📝How to install HANA DB on Oracle Linux 7?

📝MongoDB Migrating away from RocksDB to WiredTiger

📝PostgresSQL default statement for join

📝Mongodump: Unrecognized field 'snapshot'

📝Can I grant privileges to a Postgres user on all schemas belonging to a database with one command or script?

📝command or query to ping SQL server

📝Import a Oracle DMP file into a Fresh install of oracle

📝Is there a type of database that can directly recall an element given a pointer in O(1) time?

📝Quick look at how much RAM is allocated to SQL Server?

📝Nested one to many relationships?

📝sqlite 3.4 updating table with data from different table - changed with 3.3 - newbie question

📝How do I use window functions ("over") together with crosstab in Postgres?

📝PostgreSQL concurrency control and Serializable transactions

📝Find out when your index was last rebuilt / reorganized

📝SQL Server driver installed with OS

📝Making a message system

📝Why the value changes when I assign it to a variable?

📝How to avoid constantly querying a server

📝"Connecting to Integration Service failed..." SQL Server 2016

📝SQL Server - Uniqueness Of The Transaction ID

📝postgresql, duplicate database which is a replication of another

📝Compare two columns for difference mark the difference in mysql

📝View permission to SQL Server logs on SSMS GUI

📝How to Solve ERROR 1064 (42000)?

📝SQL Server 2008 R2 Remote Connection issue

📝Index Reorganize/ Rebuild Time

📝SQL Server Service Broker Compatability across versions?

📝How to replicate between On-Premises and Azure in Mongodb

📝Designing an Accumulating Snapshot with Repeated Groups, need advise

📝Problem JOINing three tables

📝mysql trigger update after insert

📝Slow update query in mysql (mariadb)

📝Resource Governor not limiting CPU / RAM

📝Re-order columns values based on values in a table

📝Create View using table and column names from data in a table, then build SQL

📝Deadlock troubleshooting in SQLServer

📝pgsql - Delete data from huge table where not in

📝How to change all similar rows in PSQL if one value is changed?

📝Enforcing database integrity

📝Why can't I obtain OBJECT_NAME() for a temporary table?

📝Convert Varchar Duration time to time

📝Filter rows using a probabilistic filter (bloom filter or cuckoo filter) in Postgres

📝Unexpected behaviour with InnoDB Transaction retry

📝MySQL: how to insert only if update fails

📝Consolidate to multiple or single instance SQL Server on a VM with many third party vendor databases?

📝Removing last two digits

📝How to make ON CONFLICT work for compound foreign key columns?

📝VBA - Hide a Form tab depending on the value of a field

📝What is the best relationship model for high performance?

📝Slow MySQL Database Import with mysqldump and USE .. SOURCE

📝Java application unable to connect to MariaDB Galera cluster

📝How to LOCK/BLOCK selected row in table to be ReadOnly?

📝Stuffing a datetime value into a datetime2 column

📝SQL query for number of users

📝How to handle user dbs after migrating system databases?

📝Create new Read Only user on DB2 on the whole database

📝Is there a way to customize SQL Server Performance Dashboard?

📝Unable to get any type of connection using MySQL on LAN

📝Mysql search matching multiple values in multiple columns

📝Row level security returning no error when blocking all effects of a query

📝How to prevent double booking of a room in this hotel booking database design?

📝Why does this cursor produce results in the incorrect order?

📝Select all rows of all user logins, where user had logged in from more than 3 ip address within the past month

📝Optimize Percona MySQL InnoDB 3.2TB database

📝PostgreSQL Enum : Search on ENUM type

📝Why when I JOIN to a casted field in an index view, the execution plan warns about "type conversion in expression"?

📝Get Row Value by Column Name of Name at runtime

📝Query plan for a dynamically built `query_int` using `format()`

📝Fast query for 'between' with overlapping ranges

📝Utilizing a single core to 100% doesn't show in perf mon as single cpu being fully utilized

📝MySQL is not releasing memory after memory tables are dropped

📝SQLite how to store translations

📝Error convert data type varchar to numeric when using a case statement order by

📝MySQL: What is the maximum number of cores used by a single MySQL server?

📝SERIALIZABLE transaction information leak via serial

📝Oracle 19c create table result_cache clause syntax

📝Converting colums as row

📝Logic of Assigning values to variables in Scalar-valued Functions

📝What are the pros and cons of adding secondary columns to a table's primary key?

📝Can Cassandra nodes running in 2 different DCs on K8s behind NAT on private subnet form a cluster?

📝Migration from SQL Server 2008 R2 to SQL Server 2012 SP2

📝Reducing column size and data type in mysql

📝What is the advantage of partition Date field into individual Year(int), Month(int), Day(int), Time(time) columns?

📝Compare timestamp type columns in SQL Server

📝Update statement is giving an invalid column name error, even though the column exists

📝Anyone want to try a script bash or python?

📝Remote database connection problem?

📝Postgres Combine Summed Values from 2 Queries / Tables into Single Row

📝You do not have privileges to manipulate with the users!

📝How did you split strings before string_split()

📝Weed out certain rows where timestamp is within interval

📝Why do the MySQL bin log files still exist after a purge or flush?

📝Try_Convert Datetime showing '1/1/1900', want to show space

📝One or several tables for attributes

📝Storing STRING and BOOL in a STRING Column?

📝Risks regarding simple recovery model and importance of log file backup

📝Retrieve multiple rows from table2 based on single row from table1 in SQL Server

📝Unique, Non-Clustered Index and Unique Clustered Index on Same Column

📝Mysql performance for a nullable unique id column in a large table that references a record in another table

📝Can this where in subquery be optimized?

📝Query to fine "Order_num" that has no two equal "product_name"

📝Database design for articles with localized prices

📝SQL Server - Error 8623 Severity 16 State 1

📝Postgres Backup queries on AWS after reading Postgres docs

📝mysqlbinlog - Binlog has bad magic number error when reading dumped file

📝Call to sysmail_delete_mailitems_sp keeps deadlocking

📝server trigger for Always On failover

📝Backing up & restoring 10-20 SQL Server databases to a ~synchronous state?

📝Is it worth indexing a varchar(32) column of UUIDS where half the UUIDS are v1 and half are v4?

📝Sql Server fails to use index on simple bijection

📝Get-MSSQLLinkPasswords Powershell script doesn't seem to work under SQL Server 2016

📝Is there a way to enumerate all locks that are currently being held via get_lock()?

📝Recovery attempt for database corruption of catalog, corruption of internal tables

📝Update MySQL user table of active/inactive members based on array

📝SQL Server Primary Login Restrictions

📝Why is my select statement so slow?

📝How to trigger a function with DDL query?

📝Workspace Memory Internals

📝drop database command is cancelled ^C

📝Database design to record occurences in tv show

📝Multi-command SQLCMD mode script

📝MongoDB: queue vs. realtime write/update

📝MySQL Local Variable Scope and Triggers

📝Insert Data in seconds between 30 minutes time interval

📝How do I host and separate multiple projects on one Oracle Database?

📝MS SQL :Export data from query output to excel which has a column with huge data

📝best mysql field type for temperatures

📝where on multiple join postgresql

📝Figure out what IP address MySQL resolves a host name to

📝Best way to replicate MySQL database tables

📝SQL Server 2008 R2 recognizes a domain account as a SQL Server account

📝How to model when you could have many (thousands of) attributes to a table (product)?

📝View with fallback (performance/optimization question)

📝How is it possible for mysql storage engine to be NULL?

📝Slow Performance Inserting Few Rows Into Huge Table

📝Is there a more helpful way to detect lock acquire/release stats in SQL Profiler?

📝How to reduce table duplication, while ensuring integrity of the database?

📝How SQL Server determines the data transfer rate

📝Recovering InnoDB database from a full physical backup?

📝Is it possible to backup with dump or rman from Oracle to MS Sql Server?

📝Checkpoint during Backup

📝Postgresql indexes: enums and booleans first?

📝SQL Server: Order of Rows