Sonntag, 16. Mai 2010

Excel Cells reading and loading into SS 2005 with SSIS

http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/70024/



CTE common table expressions

Check out CTE and the logic and functionality

Sources:

Author:
Itzik Ben-Gan
Inside Microsoft® SQL Server™ 2005:
T-SQL Querying

Very helpful solution, no more any need for temp tables ? Need to check out.

Montag, 10. Mai 2010

Normalization

Quotes from



The Art of SQL, written by Stephane Faroult



Chapter 1.2. The Importance of Being Normal

http://my.safaribooksonline.com/0596008945/artofsql-CHP-1-SECT-2



1.2.1. Step 1: Ensure Atomicity

1.2.2. Step 2: Check Dependence on the Whole Key



1.2.3. Step 3: Check Attribute Independence

3NF is reached when we cannot infer the value of an attribute from any attribute other than those in the unique key. For example, the question must be asked: "Given the value of attribute A, can the value of attribute B be determined?"