I am going to present “Multi-threading TSQL” in Portland Oct 8th, 2011, http://www.sqlsaturday.com/92/eventhome.aspx. This session will tell you how to use pure T-SQL to implement parallel SQL processing with complex ordering, such as how to start 2 threads at beginning, synchrinoze them then start another n threads for the next bunch of SQL processes without having any physically created tables to record the state of each threads. During the session, complex process control will be demonstrated, such as binary semaphore, counting semaphore etc.
This is an advance level session which I assume you’ve already had experience with Service broker and SQL Server Application locks. If not, no worries, you will know how powerful T-SQL is at least.
Ok, See you there.