Support for your product in a single location.
New releases, updates and patches.
Maximize your investmentFind out how we can help
Our leaders' commentary on news inthe software industry. Read now
Where do you want to be?Search jobs
This white paper, authored by SQL Server expert Kevin Kline, discusses a number of Query Optimizer strategies to improve performance in your SQL Server queries. This white paper will focus on topics such as: sub-query optimization, UNION vs. UNION ALL, SELECT INTO vs. INSERT...SELECT, parameters vs. variables in stored procedures, and much more.
Material adapted from `Transact-SQL Programming` (O`Reilly & Associates, ISBN: 1565924010) by Kevin Kline, Lee Gould, and Andrew Zanevsky, <http://www.oreilly.com/catalog/wintrnssql/>.
©2013 Dell Inc. ALL RIGHTS RESERVED. Acquisitions - Enstratius, PacketTrap, RemoteScan