Martin Guidry has performed database optimization for over ten years. Projects were typically done on an hourly basis; but he now offers packaged deals to make buying easier.

• Available for Microsoft SQL Server 2000, 2005 and 2008
• Optimization of up to 10 tables, 10 views, 10 stored procedures and 10 ad-hoc SQL queries.

Check for duplicated data

Check for unused data

Define foreign key relationships

Define primary keys

Recommend indexes

Recommend statistics

• Available for Microsoft SQL Server 2000, 2005 and 2008
• Optimization of up to 20 tables, 20 views, 20 stored procedures and 20 ad-hoc SQL queries.

Analyze execution plans

Analyze hardware, recommend upgrades

Check for duplicated data

Check for unused data

Choose appropriate data types

Define foreign key relationships

Define primary keys

Partition tables horizontally

Partition tables vertically

Recommend indexes

Recommend statistics

• Available for Microsoft SQL Server 2000, 2005 and 2008
• Optimization of up to 50 tables, 50 views, 50 stored procedures and 50 ad-hoc SQL queries.

Analyze execution plans

Analyze hardware, recommend upgrades

Analyze operating system, recommend upgrades

Analyze spatial indexes

Analyze XML indexes

Check for duplicated data

Check for unused data

Choose appropriate data types

Define foreign key relationships

Define primary keys

Define unique constraints

Identify and reduce execution plan recompiles

Normalization and de-normalization

Partition tables horizontally

Partition tables vertically

Recommend indexes

Recommend statistics