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

Tag: ddl

Use composite type to create new table

By adminPosted on September 24, 2023

Question : In ORDBMS databases I have seen that complex types can be used: create type name as( …) And […]

Replication and table locks during alter table

By adminPosted on September 23, 2023

Question : Recently we have noticed that a number of our Rails migrations end up deadlocking / freezing our app+DB […]

Drop primary key without dropping an index

By adminPosted on September 19, 2023

Question : Is it possible to drop primary key constraint on a table without dropping the index? I have a […]

Rollback group of DDL statements

By adminPosted on September 4, 2023

Question : Working in SQL Server 2008 R2, I am trying to rollback a set of DDL statements as a […]

lock-ddl-per-table option not working as expected in Xtrabackup

By adminPosted on August 22, 2023

Question : I’ve recently been getting the following errors on some of my Percona XtraBackup backups: InnoDB: An optimized (without […]

Migrate foreign key type from char to binary – ways to deal with the fallout?

By adminPosted on August 10, 2023

Question : I am in the process of slimming down a database that has been using char/varchar fields where binary/varbinary […]

Is there anything a table-level constraint declaration can do that a column-level one can not do?

By adminPosted on August 8, 2023

Question : Had an exam today. One question disturbed me: What can a table-level constraint do that a column-level constraint […]

Making a domain conditional on other values in the table

By adminPosted on August 6, 2023

Question : How can I define or change a domain based on another attribute value? F.e. domain for salary is […]

Advantages to column constraints over table constraints

By adminPosted on July 31, 2023

Question : Is there any advantages whatsoever, other than style to writing this, CREATE TABLE foo ( a int PRIMARY […]

Online schema changes for cloudsql DB

By adminPosted on July 27, 2023

Question : I’m new to cloudsql for mysql. I have a table with trigger. I need to do some ddl […]

  • 1
  • 2
  • 3
  • …
  • 20

Recent Posts

  • Row level restore with Oracle Recovery Manager (RMAN)
  • Macroeconomic Time-Series Database
  • OUTER JOIN with join condition causes unexpected results
  • Need help with my.cnf: 32GB RAM and 3GB of InnoDB tables
  • How to model an activity feed
  • trigram matching on a jsonb array
  • Trigger to prevent update when Flag value is 1
  • SQL, SQLCLR objects & effective memory utilization
  • Queries on Mongo Secondary are not equally distributed
  • Timezone offset displayed though it shouldn’t be stored
  • Use composite type to create new table
  • what is ‘#’ in create table statement?
  • how to avoid duplicated column in two different tables?
  • RMAN – Archivelog deletion policy ignored
  • Query runs quicker when column calculation is done after initial query
  • Generating Error when data size is larger then max text repl size
  • mysql: Is mysqladmin -p create equivalent to create database?
  • Recovering from removal of ibdata1 [duplicate]
  • Reviewing all code on a SQL Server Instance
  • Select query on 8 million records with greater and less than columns (Slow)

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