Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]
Tag: schema
How recording of every change of a row in a database is generaly stored?
Question : In a project I’m working on, every change to the rows in some tables of the database must […]
Organizing and assigning privileges to multiple objects in MySQL
Question : I’m new to MySQL, moving from MS SQL Server, and I’m wondering if there’s a way to logically […]
What are the consequences of not specifying NOT NULL in PostgreSQL for fields which can’t be null?
Question : I have an application (data is stored in PostgreSQL), where majority of the fields in the tables are […]
Where to find the OID of a newly created Schema
Question : I have created a new Schema in my Postgres db. I want to replace an OID in the […]
Optimizing Slow Changing Dimension (SCD2) joins
Question : Right now I’m working on developing a DB schema for an application which requires versioning several different sets […]
Deny DDL_ADMIN permissions to a role on [dbo] schema
Question : I have several database schemas like, [ext],[stag],etc and of course the built in [dbo] schema, and also have […]
How to design database for monitoring the time trends of article tags?
Question : My purpose is to monitor which tags increase/decrease rapidly last week on different bulletin boards. Or which tag […]
How to create a table with a field 99% INT; 1% STR values?
Question : I am creating a table in PostgreSQL and looking for a best approach that I should follow. One […]
When do I need more than one Oracle Instance on the same server?
Question : I have one application server separate from an Oracle server (one physical server). I have three instances on […]