Richard To

Test Running a Tuned SQL is Not An Easy Job

In SQL Optimizer for SQL Server, we have built a very sophisticated test run facility for users to find the best SQL alternative from all generated SQL alternatives to solve the user’s specific problem. But I have found that many users are just...
1834 0 /
Richard To

How to locate problem SQL from Plan Cache in SQL Server

A new module "Find SQL" in version 9 of SQL Optimizer for SQL Server is created to help user to locate problematic SQL statements from Plan Cache. As there may be up to thousands of executed SQL statements in Plan Cache, how can we filter out...
2000 0 /
Richard To

Plan Guide in Quest® SQL Optimizer for SQL Server 8.0 - Part III

The new Quest SQL Optimizer for SQL Server 8.0 has two major enhancements: an improved SQL rewrite engine and the new Plan Control SQL tuning module. Today, I continue my discussion of these enhancements. Be sure to see Plan Guide in Quest® SQL Optimizer...
1895 0 /
Richard To

Plan Guide in Quest® SQL Optimizer for SQL Server 8.0 - Part II

The new Quest SQL Optimizer for SQL Server 8.0 has two major enhancements: an improved SQL rewrite engine and the new Plan Control SQL tuning module. Today, I continue my discussion of these enhancements. Be sure to see Plan Guide in Quest® SQL Optimizer...
1694 0 /
Richard To

Plan Guide in Quest® SQL Optimizer for SQL Server 8.0 - Part I

The new Quest SQL Optimizer for SQL Server 8.0 has two major enhancements: an improved SQL rewrite engine and the new Plan Control SQL tuning module. Today, I want to discuss the new Plan Control module, which elevates the SQL Server 2005 Plan Guide feature...
1787 1 /