Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: metadata

Find tables with multiple indexes on same column

By adminPosted on September 29, 2023

Question : I am having an issue with scaffolding PostgreSQL DB because npgsql does not handle tables with two index […]

Check if two databases have same structure

By adminPosted on September 29, 2023

Question : I have a Postgres database that was developed over time, adding tables and keys when needed. Now I’m […]

ObjID in Page Header

By adminPosted on September 22, 2023

Question : I am reading this article: Inside the Storage Engine: Anatomy of a page. I have a database MyDB, […]

How to extract the structure out of DB2 (Back up Structure)?

By adminPosted on September 3, 2023

Question : Is there a way in db2 to take a backup of the database structure (Metadata) without actual data? […]

PostgreSQL equivalent of SQL Server SQL_VARIANT_PROPERTY

By adminPosted on September 1, 2023

Question : Does PostgreSQL have an equivalent function for determining column metadata? Reference: SQL_VARIANT_PROPERTY pg_typeof() appears to be close, but […]

How to get Page Name given Page ID in Oracle Application Express

By adminPosted on August 16, 2023

Question : Prefix: I have looked all over the net for this answer. Let me prefix the question by describing […]

Best way to store units in database

By adminPosted on August 14, 2023

Question : I have inherited a large (SQLServer) database with hundreds of columns that represent amounts of one thing or […]

Track my own custom metadata on Postgres tables and columns

By adminPosted on August 5, 2023

Question : Is there any way to add my own metadata to tables and columns in Postgres, such as key-value […]

MySQL metadata function to get projected column type in query?

By adminPosted on July 17, 2023

Question : Is it possible to get the field type from a MySQL query, in the same way you can […]

Gathering Read Routing information using SMO is inaccurate in SQL Server 2016

By adminPosted on June 30, 2023

Question : I’ve been playing around with SMO to check out some properties recently, and have come across a problem […]

  • 1
  • 2
  • 3
  • …
  • 13

Recent Posts

  • Multiple query to columns indexed in MySql
  • cluster_database TRUE/FALSE what does it mean in Oracle RAC?
  • mysql – How to repair & backup archive table, also stop growing .ARN extension file?
  • How does the transactions interact if you set a different isolation level per connection?
  • Autovacuum in Postgresql database
  • MySQL Server 5.7.33 or upgrade
  • What are the performance implications of using uuid as primary key in Postgres 10.12? (need canonical answer) [duplicate]
  • How do I use subquery on the same table in MySQL?
  • Error on updating a field with binary values
  • Feasibility of a MSSQL Read Only Replicas as ephermal containers?
  • How to represent directed graph with multiple parents?
  • Promoting MySQL slave with unknown replication delay
  • Rules for Decomposition to 2 NF
  • Index with ops for `LIKE` and `=` queries
  • How many cores are used for serial plans in SQL Server?
  • MySQL read-write Master with many read-only Slaves over shared storage?
  • How to reference categories table in products table?
  • Automatically set value on child rows when deleting parent row?
  • In SQL Server, what are the typical symptoms of parameter sniffing?
  • Optimize two sql sentences adding indices

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding