In data mining, we sometimes need to perform techniques such as Z-score normalization on numeric data type columns to prevent one column from skewing or dominating the models produced by the machine learning algorithms. Dallas Snider explains how to perform this in SQL Server with T-SQL code.
2015-01-29
9,049 reads
The task of Database Normalization doesn't have to be painful, especially if you follow Old Mother Celko's Normalization Heuristics.
2014-04-23
6,652 reads
Not only is the process of normalization valuable for increasing data quality and simplifying the process of modifying data, but it actually makes the database perform much faster. To prove the point, Peter Larsson takes a large unnormalised database and subjects it to successive stages of normalisation.
2012-06-25
4,835 reads
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,616 reads
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,730 reads
Learn the basics of first normal form and what that means to a database designer from Tom Thomson.
2011-06-30
10,501 reads
A cursor-free way of normalizing data from a denormalized data source into a database which uses "surrogate" IDs.
2010-01-25
5,262 reads
Explains how to normalize a table without breaking the application or doing any application code changes.
2013-11-01 (first published: 2008-11-10)
22,609 reads
Will list Table Name, Constraint name and Primary Key Column Name.
2012-06-29 (first published: 2008-03-20)
2,465 reads
By Arun Sirpal
Quick Video showing you have to use a BACPAC to “import” a database into...
By Andy Warren
For the past couple weeks I’ve been trying to capture a lot of ideas...
By Steve Jones
Recently I had a client that wanted to know how they could use SQL...
Hi I'm looking to automate installing SQL 2017 as part of an automated server...
Comments posted to this topic are about the item Ordering with NULL
Ask SSC