Home |  Writing |  Consulting |  Schedule |  Scripts |  Links |  About










Paul's Blog...
Top Posts
Why use Stored Procs?
10 lessons from 35K tps
SQL Server:Fresh Vision
SQL Myths
Data Architecture
CodeGen AutoAudit Trail

Interviews...
CS TechCast
TechEd ArCast
PASSCamp 2008 Panel
SQL DownUnder


Locations of visitors to this page

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
  • db_compression procs blog post
    estimate compression or compress every object and index with a single proc
    Sample Databases and Chapter Scripts (740Kb)
    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
    Code-Gen script that automatically creates a (composite) non-clustered index for every Foreign Key without a complete matching (composite) index Explore SQL Server's Catalog views and DMV's