This is first presentation in public.
I choose SQL Saturday in San Diego.
Here is Presentation file. Transaction
You can download it from this url as well.
http://www.sqlsaturday.com/viewsession.aspx?sat=340&sessionid=25091
Please download it. And test and use it as own your risk 🙂
Over all, it’s ok on production environment as well. But, Speaker do not grantee it on your system.
As I explained in there is no Generic best practice Stored Procedure template.
It need to change based on your business logic.
Simon's SQL 