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

Tag: visio

Converted ERD into Dependency Diagram 1NF, 3NF

By adminPosted on September 17, 2022

Question : Thats the ERD. I’m studying for an upcoming test and having trouble getting my head around converting this […]

How do I resolve having a M:N relationship in my Crow’s Foot Model? Am I on the right track?

By adminPosted on May 28, 2022

Question : I am very much a beginner and taking a class on databases. My assignment involves using Crow’s Foot […]

Visio 2010 and SQL 2012 – Reverse Enginnering

By adminPosted on October 27, 2021

Question : We have upgraded to SQL 2012 and Am trying to reverse engineer our Dbs into Visio 2010. I […]

How can I import Create Table Statement from SQL Developer into Visio to create an Entity Relationship Diagram?

By adminPosted on June 7, 2021

Question : I have the following Create table statement from SQL Developer and I am trying to generate an ERD […]

Recent Posts

  • Is there a way to show a string instead if numeric column has specific value?
  • Optimize query with a subquery (index is not used)
  • Return a column per date in a range
  • Can an AlwaysOn Availability Group be used to mitigate downtime when there’s replication syncing issues on the primary server?
  • Inner join on array column in Postgres
  • Connection pooling – NodeJS or Database products?
  • Why is there a separate describe and explain statement in MySQL
  • How should deletions be handled in the database?
  • Securely remove columns (and traces thereof) from a SQL database
  • Postgresql join removal
  • SSMS Oracle import using OpenQuery over LinkedServer (Oracle Provider for OLEDB) – XML Parsing: unable to switch encoding
  • Problem using multiple JOINs
  • Oracle – Extract user DDL for migration
  • Restore Oracle Database excluding some tablespaces
  • How do I maintain high INSERT-performance on PostgreSQL
  • INTERSECT query rewrite as JOIN?
  • Using the result set of a select query as the input of another select
  • Is it wise to drop fixed-length columns to free up space?
  • How to Fetch A Record If Shipping And billing Address are Different
  • Concurrency Issues when multiple users uses Portal (MySQL and PHP)

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