Topic: Database Administration

Recent Tags

active-directory aggregate alias alter-table amazon-ec2 amazon-rds architecture archive-log array audit authentication auto-increment automation availability-groups aws azure azure-data-factory azure-sql-database backup batch-mode best-practices binlog blocking bulk-insert c# cache case cassandra catalogs certificate clustered-index clustering collation columnstore concat concurrency configuration connection-pooling connectivity count cross-apply ctas cte data-versioning data-warehouse database-design database-internals database-recommendation database-theory database-tuning date date-format datetime db2 dbcc dbcc-checkdb ddl ddl-trigger deadlock debugging delete deployment dimension disaster-recovery disk-space distributed-databases dmv dump dynamic-sql encoding erd etl exadata except execution-plan expdp explain export express-edition filegroups foreign-key full-text-search functions galera gin-index google-bigquery greatest-n-per-group group-by group-concatenation group-replication gtid high-availability import index index-tuning informatica informix innodb installation isolation-level java join json jsonb kerberos keyboard-shortcuts like linked-server linux listener locking log-shipping logins logs maintenance maintenance-plans many-to-many mariadb mariadb-10.3 master-master-replication master-slave-replication materialized-view max maxdop memory merge metadata mongodb mongodb-3.2 mongodb-3.4 mongodb-atlas monitoring ms-access ms-access-2010 multi-master multi-tenant my.cnf myisam mysql mysql-5 mysql-5.1 mysql-5.5 mysql-5.6 mysql-5.7 mysql-8.0 mysql-event mysql-innodb-cluster mysqlbinlog mysqldump naming-convention native-client natural-key ndbcluster netbackup network non-deterministic nonclustered-index normalization nosql null openrowset optimization oracle oracle-10g oracle-11g oracle-11g-r2 oracle-12c oracle-19c order-by owner parallelism parameter-sniffing partitioning password password-recovery percona performance performance-tuning permissions pg-dump pgadmin php physical-design plan-cache plpgsql plsql postgis postgres-xl postgresql postgresql-10 postgresql-11 postgresql-12 postgresql-9.1 postgresql-9.3 postgresql-9.4 postgresql-performance powershell primary-key profiler python query query-performance rails random read-only-database recovery recursive redshift referential-integrity relational-theory relations replication reporting restore rman san scan scheduled-tasks schema scripting security select service-accounts service-broker set-returning-functions sharepoint shrink slow-log sort-operator 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-server-agent sql-standard sqlalchemy sqlcmd sqlite sqlmap sqlplus ssas ssdt ssh ssis ssis-2012 ssis-2016 ssl ssms ssrs ssrs-2012 star-schema startup statistics storage storage-engine stored-procedures string-manipulation string-searching subquery sum system-databases system-tables t-sql table table-valued-parameters tablespaces tempdb teradata terminology time timestamp timezone toad trace transaction-log transparent-data-encryption tree trigger type-conversion ubuntu unicode unique-constraint uniqueidentifier update upgrade upsert users utf-8 view visual-studio-2015 where window-functions wiredtiger wordpress write-ahead-logging xml xquery xtradb-cluster

Recent Articles

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

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

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?

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

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

Anonymous Access to SSRS Report

Is an SSL Certificate Authority Chain "Secret"

How to recover from a SQL server log file drive crash?

Minimise duration of table lock

Importing CSV with a json array of strings in one of the column