Topic: Database Administration
Recent Tags
ado.net 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-clusterRecent 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 | |