Tricks to increase SQL Server query performance

December 4, 2007

[From SearchSQLServer]

Thanks to the natural language roots of the SQL language, writing queries has become extremely easy for just about anyone to pick up. But its simplicity also makes it easy to write poorly performing queries. Here are some simple changes you can make to improve not only query performance, but, in some cases, overall SQL Server system performance as well.

The article continues at http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1284087,00.html