T-SQL Scripts

AutoAudit
	Code-Gen complete insert, update, & delete audit trail triggers. Update modified date and rowversion Reconstruct deleted rows using the generated vTable_deleted views original AutoAudit blog post / thread (now on CodePlex)

db_compression procs (requires Katmai CPT6) blog post New estimate compression or compress every object and index with a single proc

Sample Databases and Chapter Scripts (740Kb)
Nordic O/R dbms for SQL Server
	Nordic (New Object/Relational Database Design) is an O/R dbms design and facade for SQL Server that merges the query, integrity, and vendor strengths of the relational engine with the design power of the object orientation to create an alternative database development environment. Microsoft Architecture Journal article SQL-Down-Under podcast interview about Nordic
Using T-SQL code-generation, Nordic transforms SQL Server into an O/R dbms: Seemless Classes / Sub Classes and Attribute Inheritance Polymorphism (Select * from superclass and retrieve all subclass objects) Collections & Aggregations Inheritable Class Workflows with Object Workflow State Complex Associations including Workflow State Constraints & Triggers Indirect multi-level Association spidering Still Easy to Query using SQL e-mail pauln@SQLServerBible.com, if you're instersted in testing Nordic.

FK Indexing (v 1.00) Code-Gen script that automatically creates a (composite) non-clustered index for every Foreign Key without a complete matching (composite) index

sys.queries (v 1.00) Explore SQL Server 2005's Catalog views and DMV's