Sets, Surrogates, Normalisation, Referential Integrity - the Theory with example Scaling considerati

Posted by tonyrogerson on SQL Blogcasts See other posts from SQL Blogcasts or by tonyrogerson
Published on Fri, 16 Apr 2010 12:56:00 GMT Indexed on 2010/04/16 13:24 UTC
Read the original article Hit count: 321

Filed under:
The Slides and Demo's for the SQLBits session I did today at SQL Bits in London are attached. The Agenda was... Thinking in Sets Surrogate Keys ú What they are ú Comparison NEWID, NEWSEQUENTIALID, IDENTITY ú Fragmenation Normalisation ú An introduction – what is it? Why use it? ú Joins – Pre-filter problems, index intersection ú Fragmentation again Referential Integrity ú Optimiser -> Query rewrite ú Locking considerations around Foreign Keys and Declarative RI (using Triggers)...(read more)

© SQL Blogcasts or respective owner