Saturday, September 24, 2011

Wednesday, September 21, 2011

Transaction Log

Added a script to determine what is filling up the transaction log.

Monday, September 19, 2011

Change Data Capture Script

Needed to add change data capture to enable all objects for a database.  Created a script to enable all objects.

Sunday, September 18, 2011

Lottery Quick Pick Generation

Created a script to generate lottery numbers.  Works for 5 or 6 numbers total. 

Saturday, September 17, 2011

Asychronous Triggers

While working on some performance tuning for a client, implemented asychronous triggers in order to speed up front end access from a web page.  Users had to wait 10 minutes in order for various triggers to execute.  I changed that and now users only wait a second.  All from the magic of asyc triggers.  Added the code into the code repository with example runs.

http://www.freewebstore.org/tsqlcoderepository