An ounce of design is worth a pound of rework...
Home     Design Book     DMV Book     Links     Non Database Stuff     Contact me     About     Presentations     Calendar of Events     Downloads     Code Snippets     SQL Articles/Blogs      
On this page are some stuff I have created for my use or to demonstrate something for someone else that you might find useful, or not, the fact is they are here!  For downloads that went directly with a presentation I gave, go to the presentation page.  For downloads that go with one of my books, go to the design book page.
 
 
Code to create a time table (not date)
This will create a table that has a row for every minute in the day to join to a datetime type with minutes.  Gives you the ability to do a join to group by the part of the day or hour, like am_pm, half hour of the hour, or day, etc.
timeTableCreateAndLoad.sql 

Procedures to drop all types of objects in a database. 

Used by me to drop objects in a database before changing the collation of a database to remove all constraints/procedures etc that had references to the columns I needed to change.

utility.drop_objects_procs.zip