Free Resources from FMS

Additional Resources

 

Thank you! Thank you! I just finished reading this document, which was part of a link in the recent Buzz newsletter. I have printed it for others to read, especially those skeptical on the powers of Access and its capabilities.

Darren D.

 

Free Catalog

 

Optimizing Select...In Clauses in SQL Server Views

Provided by: Molly Pell, Technical Project Manager

When using SELECT...IN clauses in SQL Server views, order the list of values from most to least frequent in the data set. When you place the most frequently-used values at the beginning of the IN clause, matching is made sooner, and performance is greatly increased.

This tip and more found by Total SQL Analyzer PRO.

 

Return to the tips page