Third Normal Form
The third article in our series on normalization from Tom Thomson continues with an explanation on what constitutes third normal form.
2011-07-28
7,900 reads
Normalization
Second Normal Form
In this article Tom Thomson takes a look at what second normal form means, how it is violated, and how you can fix it. This is part of our normalization series.
2011-07-14
7,819 reads
First Normal Form
Learn the basics of first normal form and what that means to a database designer from Tom Thomson.
2011-06-30
10,631 reads
Fast normalization of a denormalized data source, using surrogate IDs
A cursor-free way of normalizing data from a denormalized data source into a database which uses "surrogate" IDs.
2010-01-25
5,374 reads
Facts and Fallacies about First Normal Form
When discussing the normalisation process, it is always the First Normal Form that causes the most grief and confusion. Anith Sen takes up the challenge to explain, in simple terms, exactly what the First Normal Form really is, and why it is so important for Database Design. Along the way, he dispels some of the myths that have grown up around 1NF.
2009-06-09
5,827 reads
2008-12-02
8,700 reads
Normalizing-Denormalized Tables
Explains how to normalize a table without breaking the application or doing any application code changes.
2013-11-01 (first published: 2008-11-10)
23,154 reads
SQL 2005 - List Primary Key Columns
Will list Table Name, Constraint name and Primary Key Column Name.
2012-06-29 (first published: 2008-03-20)
2,471 reads
RE: Loop won''''t terminate
Hi John just a couple of observations, your database allows alternate address fields (2) but only one field for city, state and county. What if the alternate address is in another state? Secondly if you check the first post by Joe Celko he gave you the code for moving the information from one table to […]
2005-04-11
RE: Database Structure Compare Tool
I use AdeptSQL's SQLDiff - it is smokingly fast and very affordable. (http://www.adeptsql.com)I use this tool each time I deploy a new release. I compare my production databases to my QA server where we have all of the final scripts and adjustments made. This way I can find out if we didn't deploy something and get […]
2005-03-17
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers