http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/70024/
Sonntag, 16. Mai 2010
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.
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?"
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?"
Abonnieren
Posts (Atom)