PASS Community Summit 2008: Program Sessions (Application Development)

In this session I will give an overview of the common normal forms and show why they should matter to you if you are creating or modifying SQL Server databases. Data should be easy to work with in SQL Server if the database has been organized as close as possible to the standards of normalization that have proven for many years. Many common T-SQL programming "difficulties" are the result of struggling against the way data should be structured and can be avoided by applying the basic normalization techniques and are obvious things that you find yourself struggling with time and again (i.e. using the SUBSTRING function in a WHERE clause meaning you can't use an index efficiently). Properly structured data structures make it easier to work with data in simple SQL statements rather than having to resort to functional programming and cursors.

Register Now for PASS Community Summit 2008!