Skip to content
Rodgers Notes
Rodger Lepinsky, Database Expert, Data Analyst, Data Scientist.
  • Data Modeling
    • testpage_4
  • Database Tuning
  • Database Administration
  • Blog
  • Contact
    • About Rodger Lepinsky

Tag: Database Design Mistakes to Avoid

System Performance: Cobol Versus Database

October 7, 2010 Rodgers Notes Writer Leave a comment

If you want to make a Cobol system, write your system with flat files and use Cobol. Or C. The system will run much faster than using a database.

Continue Reading →

Posted in: Architecture Filed under: Architecture Mistakes To Avoid, Database Design Mistakes to Avoid, Oracle DBA Subjects, Tuning

Script to List Tables With No Foreign Keys

September 19, 2010 Rodgers Notes Writer Leave a comment

Here is an Oracle script to find the tables that don’t have any foreign keys.
Tables that are neither a parent table, or a child table.

Continue Reading →

Posted in: Oracle DBA Subjects Filed under: Database Design Mistakes to Avoid, Oracle DBA, Scripts

Oracle Script To Find Tables With No Primary Key

September 18, 2010 Rodgers Notes Writer 2 Comments

After discovering so many tables that no primary key, at so many shops, I finally wrote an Oracle script to list all the tables that did not have a PK.

Continue Reading →

Posted in: Power Scripts Filed under: Database Design Mistakes to Avoid, Oracle DBA, Scripts
  • Architecture
  • Cartesian Products
  • Data Science
  • Database Design Mistakes to Avoid
  • Design
  • Graph Database
  • Humour
  • Oracle Applications
  • Oracle DBA Subjects
  • Power Scripts
  • Quality
  • R
  • Reviews
  • Science
  • Security
  • SQL
  • SQL Server
  • Tuning
  • Uncategorized
  • Uniface
  • Unix and Linux
  • Windows
Copyright © 2025 Rodgers Notes — Velux WordPress theme by GoDaddy