Topic: Database Administration

Recent Tags aggregate aggregate-filter alter-table amazon-rds application-design array authentication auto-increment autovacuum availability-groups aws aws-aurora azure azure-sql-database backup blocking bulk-insert bulkcopy business-intelligence c# cache candidate-key cardinality-estimates case-sensitive cassandra clickhouse clob clustered-index clustering collation columnstore command-line composite-types compression connection-pooling connectivity constraint copy count csv cte cursors data-versioning data-warehouse database-design database-internals database-recommendation database-theory datafile dataguard datatypes date date-format datetime db2 dbcc-checkdb ddl deadlock delete dependencies deployment design-pattern disaster-recovery disk-space distributed-databases distributed-transactions dml dmv docker dump dynamic-sql encoding encryption erd etl execution-plan expdp failover fields filtered-index foreign-key full-text-search functions galera google-cloud-sql graph greatest-n-per-group group-by group-replication gtid hierarchy high-availability identity impersonation import index index-tuning information-schema informix inheritance innodb insert installation isolation-level java jobs join json keyboard-shortcuts like limits linked-server linux localization locking log log-shipping logging logins logs mac-os-x mariadb mariadb-10.3 master-master-replication materialized-view max max-connections memory metadata migration mirroring mlagent mongodb monitoring ms-access ms-access-2010 my.cnf mysql mysql-5 mysql-5.0 mysql-5.1 mysql-5.5 mysql-5.6 mysql-5.7 mysql-8.0 mysql-workbench mysqlbinlog mysqldump naming-convention neo4j network normalization nosql offset-fetch openrowset operator optimization oracle oracle-10g oracle-11g oracle-11g-r2 oracle-12c oracle-19c order-by pagination partitioning password percona performance performance-tuning permissions pg-catalog pg-dump pg-hba.conf pg-restore pgadmin physical-design pivot plpgsql plsql polymorphic-associations postgis postgresql postgresql-10 postgresql-11 postgresql-8.4 postgresql-9.3 postgresql-9.4 postgresql-9.5 postgresql-9.6 postgresql-performance primary-key profiler psql python query query-performance query-store rails rdbms read-only-database recovery redshift regular-expression relational-theory replication reporting role rollback row-modification-time san scalability scan schema scripting security select sequence service-accounts service-broker set-returning-functions sharepoint sleep slow-log snapshot-isolation sort-operator sp-whoisactive spatial sql-clr sql-server sql-server-2005 sql-server-2008 sql-server-2008-r2 sql-server-2012 sql-server-2014 sql-server-2016 sql-server-2017 sql-server-2019 sql-standard sqlcmd sqlite sqlmap ssas ssd ssdt ssis ssis-2014 ssis-2016 ssl ssms ssrs ssrs-2016 standby star-schema startup storage storage-engine stored-procedures string-manipulation string-searching string-splitting subquery subtypes sum sybase sybase-ase-15.7 system-databases system-tables t-sql tablespaces temporary-tables teradata terminology testing timestamp timezone toad top transaction transaction-log transactional-replication transparent-data-encryption tree trigger type-conversion ubuntu unicode unique-constraint update upgrade users utf-8 vacuum varchar view vldb vmware wait-types waits where window-functions windows wordpress write-ahead-logging xml xtradb-cluster

Recent Articles

Use square brackets on extended events filter

What ports to open for sql server behind secure domain firewall

Poorly performing stored procedure using cached data while testing

Logical reads and LOB logical reads

Restore over dns alias fails with Operating system error 1326(The user name or password is incorrect.)

SQL: finding unique multi-column value triplet matching multiple rows?

Which versions of DataStax Enterprise have the fix for CVE-2020-13946?

Optimizing geolocation query in Postgres with earth_box and earth_distance

Incorrect Result When Doing String Concatenation With ORDER BY

Boolean flag in fact table

What affects log_send_rate in Normal or Distributed AG other than OS resources?

How to get the "best of both worlds" with natural and surrogate keys? And could DBMSs be better?

Oracle 19 - RMAN can't connect to database

Distinguish between "take-away orders" and "orders for a table"

Temporarily disable SELECT for one table (during an update)

How do I SELECT elements using WHERE with another table's record values in WHERE statement?

Can I use SQL AG to create readable secondary when primary is enterprise and secondary is standard edition?

How to create a table with an index that allows me to order by the time from now?

When exactly are IMMEDIATE constraints checked and what exactly is a "statement" in Postgres?

PostgreSQL ESCAPE Quoting on TAB-delimited files: MySQL works, Pg doesn't, and I'm confused

Product alternatives query performance slow - Many to many tables and ROW_NUM(OVER PARTITION...) optimisation needed?

Is there a way to use time series databases effectively without absolute timestamps?

Filter rows of one table with conditions coming from another table

When did this SQL request yield results?

how to split multiple rows in the same column into different columns depending on the data provided postgres

Trigger on partitioned table and performance

SingleStore exception no_data_found

parse JSON keys preserving ordinality

Resource Governor and Resource Pool CPU Utilization Configuration

EXCLUDE CURRENT ROW cripples performance of window functions

How does Wikipedia store article diffs (or any site which contains lots of text diffs per record)?

Postgres order by with multiple columns

Generating an ID from primary key sequence without adding a row

SQL Return Table with where clause and occurrences of value of total table

Nest a SQL file into another in SQL Server

In a SQL database, how can I add a unique constraint that depends on a value in a foreign key linked table?

Why this trigger is raising "record "old" is not assigned yet" exception?

I can't understand a syntax error issue in SQL / TimeScaleDB

Return NULL when distinct values else return value

SQL Server PATINDEX issue/bug when using different case-sensitive collations

Is a clustered index of 3 columns too big?

Records greater than epoch timestamp using only LIKE operator

Can PostgreSQL use indexes to expedite count(distinct) queries?

Can I delete these SQL Server files to clear up disk space?

Pivoting 4 by 44 result set

Postgres allow admin role to grant permissions for users on any database

How to Restore to AWS RDS SQL Server from TDE Enabled SQL DB(on-premises) backup file stored in S3

Why does my application have over 20,000 idle (sleeping) connections in SQL Server?

Select only rows where all values in a column match a value for an id

Dates - start and end vs only start

MySQL InnoDB migrations custom implementation: How to deal with DML statements which trigger a commit in the background?

Postgres Recursively resolve tree relation with left joins

Recommended way to index a timestamp column in postgres?

How to replicate between On-Premises and Azure in Mongodb

extracting ordered list of spatial points from JSON into PostgreSQL array

Is it safe to use user defined variables inside stored procedures in MySQL?

single insert ignore on a table with no auto-increment

How to upgrade Postgres minor version from 14.x to 14.4 in Ubuntu 20.04 LTS

Optimal Indexing Strategy for Datawarehouse and Data Lake Updates

Update statement runs for longtime and throws ORA-01654 table space error

What kind of database to store Quotes

Is there a performance penalty on using databases instead of schemas in a single PostgreSQL cluster?

Advantage of using INCLUDE as against adding the column in INDEX for covering index

Sqlmap - Continuing a large query

#1064 - SQL syntax Error while trying to import

Memory Requirements for SQL Server

How does SQL estimate the number of rows in a less than < Predicate

How to pivot multiple columns in PostgreSQL 9.5?

Helm Install MySQL InnoDB Cluster: tls.routerCertAndPKsecretName: secret 'my-mysql-innodbcluster-router-tls' not found in namespace 'default'

Consistent backup of multiple MS SQL databases

In Postgresql how do I get localtime as the TimeZone to work on FreeBSD?

Why does CURSOR_STATUS return unexpected results for an output cursor inside the stored procedure that created it?

How to compute the average score for each user, by time interval?

Trigger execution order after delete

Dropping PostgreSQL partition is blocked as long as a client is reading data from any partition

Why Does SQL Server not have 200 buckets in the statistics histogram when there are >100k distinct values in the table

Diff backup fails with error 3035 but log backup succeeds

MariaDb - How to ensure a (LEFT) JOIN only if a single right side record exists

How is intra node latency handled during updates?

Storing column for data that doesn't exist for majority of rows

PostgreSQL triggered update function lock mechanism

stored procedure runs fine in all sessions but one

Why is my auto-restore procedure not dropping the databases when I expect it to?

Reading from table being created in transaction

ALTER TABLE … ADD COLUMN on a small table takes forever, pg_stat_activity doesn't show any queries on this table

Autocomplete using Postgres Optimization

Intended use case for virtual columns with function-based index?

EXISTS() vs EXISTS() = TRUE in Postgres

Finding the maximum values of a group count

How to get the highest (max) cost, lowest (min) cost, and the date that each occurred?

Storage space used for NULL values

The best approach for optimizing query in large database table

Check auto-numa is enabled

insertion in a table of objects with nested table in oracle

How to query dates in different timezones?

Help Understanding huge discrepancy in LDF file growth on AAG between primary and secondary

Does selecting data from heap (table without clustered index) with nolock block writers?

Temporarily turn on Cascade Delete

MySQL 8.0 Migrating Roles from one server to Another

A query containing multiple joins becomes too slow when adding one more condition after the joins