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.