Browse by Tags

All Tags » functions (RSS)

SQL Performance Tips - Avoid putting indexed columns inside functions in your WHERE clause by jnelson

THE PROBLEM When designing a query, it is incredibly important for performance reasons that you keep in mind what columns are indexed. The SQL engine will...
Copyright - www.myITforum.com, Inc. - 2010 All Rights reserved.
Powered by Community Server (Commercial Edition), by Telligent Systems