I've participated in many projects for Fortune 100 companies (lead role) for development of inventory control transactions used on handheld RF devices. Middleware product interfaced SAP with SQL Server databases (versions varied). I've been a SQL Server consultant for five years and have worked on many different projects such as OLTP SQL Server optimization project - reviewed client's stored procedure library of roughly 300 stored procedures, reviewed and analyzed indexes and performance. I modified procedures using various techniques and increased performance tremendously, taking some procedures from 7 minutes to under 15 seconds. Logical and Physical reads were greatly reduced also as well as overall server performance. cloning procedures (sql server)- project which a parent table and many child tables will be duplicated based on a primary value. New records are created in child tables with new primary keys and foreign key relationships. Also, I've done many projects dealing with in