There is a query that uses SUM, AVG and MAX. To improve performance:

Your company requires a standard code snippet to be inserted at the beginning of all stored procedures meeting the following requirements:
+ Stored procedures should be able to call other stored procedures
+ All stored procedures must incorporate transactions
Here is the core part of the snippet

char(36) @TransName = newID()
If <insert answer here>
Save Transaction @TranName
Begin Transaction

Database used in three different timezones. What to do so that value can be read everywhere?

You need to design a solution to guarantee that a stored procedure is part of every transaction.

There are 20 tables in a database. Each one has a primary key but there is no referential integrity. More than 5 Million Rows per table with 10 percent being outdated. A strategy is needed to delete outdate records meeting the following requirements:
+ min execution time
+ min locking an application execution accessing data
+ min development effort