Question : Closed. This question is off-topic. It is not currently accepting answers. Shopping list question – questions about which […]
Tag: ddl
Create A Pivot With No SUM() in MySQL
Question : I’ve seen a lot of examples using MySQL to create a PIVOT but they all use SUM() – […]
Upgrade production database during software development lifecycle
Question : Background Using Oracle, there are a number of tools that help with migrating and applying development changes into […]
Ensuring that 1 row has 5 specific records referencing it
Question : Context: a TEST has many CASEs. Typical. However, the catch is that a TEST instance must have exactly […]
Change column without interrupting service
Question : We need to change the data type of a column in a large table (~1.7 GiB) from VARCHAR(1024) […]
How to determine if a column already exists in a MySQL table before altering the table to add it?
Question : I am trying to determine if a column already exists in a MySQL table before altering the table […]
What happens when you create the primary key of a table on a different filegroup?
Question : Creating a table on a different filegroup is absolutely no problem when using Sql Server. create table common.test […]
How to model a limited history of a table
Question : Context I have 3 entities (user, shop and car), a car can only have one regNum, one shopId […]
Modifying a part (one procedure) in oracle database package
Question : Is it possible to modify an individual procedure inside an Oracle DB Package? instead of recreating (modification is […]
How to drop all indexes not used for primary keys or constraints
Question : I have an old dataset with a lot of unused indexes. I would like to clean it up […]