http://www.sqlservercentral.com/Articles tagged Basic Querying, Performance Tuning posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)In this article Randy Dyness shows you how to avoid temp tables whenever to maximize the performance of your queries. http://www.sqlservercentral.com/articles/Performance+Tuning/temptabl/662/2008/05/30http://www.sqlservercentral.com/articles/Performance+Tuning/temptabl/662/In this article Randy Dyness shows you how to avoid temp tables whenever to maximize the performance of your queries. http://www.sqlservercentral.com/articles/Performance+Tuning/temptabl/662/2008/05/30http://www.sqlservercentral.com/articles/Performance+Tuning/temptabl/662/We've had a lot of coverage of dynamic sql (including another great one from Robert Marda later this week) but this one is a little different. Done in a question/answer format, Andy tries to explain to junior developers why dynamic sql is to be avoided, how to do so, what to do when you can't. http://www.sqlservercentral.com/articles/Performance+Tuning/dynamicsqlorstoredprocedure/969/2005/08/26http://www.sqlservercentral.com/articles/Performance+Tuning/dynamicsqlorstoredprocedure/969/In this article by Robert Marda, he shows you how to use derived tables to solve some of SQL's problems. http://www.sqlservercentral.com/articles/Performance+Tuning/derivedtablebasics/597/2004/02/06http://www.sqlservercentral.com/articles/Performance+Tuning/derivedtablebasics/597/We've had a lot of coverage of dynamic sql (including another great one from Robert Marda later this week) but this one is a little different. Done in a question/answer format, Andy tries to explain to junior developers why dynamic sql is to be avoided, how to do so, what to do when you can't. http://www.sqlservercentral.com/articles/Performance+Tuning/dynamicsqlorstoredprocedure/969/2005/08/26http://www.sqlservercentral.com/articles/Performance+Tuning/dynamicsqlorstoredprocedure/969/A monster book at 980 pages, it's written in 'how-to' format and has a ton of good material. Andy gave it the once over for us and reports back - see what he thinks! http://www.sqlservercentral.com/articles/Installation/reviewofsql2000fastanswers/959/2003/04/18http://www.sqlservercentral.com/articles/Installation/reviewofsql2000fastanswers/959/In this article, James Travis covers a common performance topic of prefixing stored procedures sp_. Does it really slow down performance? http://www.sqlservercentral.com/articles/Performance+Tuning/sp_performance/850/2002/11/14http://www.sqlservercentral.com/articles/Performance+Tuning/sp_performance/850/In this article new columnist Christoffer Hedgate offers his advice on what performs better, COUNT(*) or COUNT(column). http://www.sqlservercentral.com/articles/Performance+Tuning/adviceoncount/808/2002/09/23http://www.sqlservercentral.com/articles/Performance+Tuning/adviceoncount/808/In this article Randy Dyness shows you how to avoid temp tables whenever to maximize the performance of your queries. http://www.sqlservercentral.com/articles/Performance+Tuning/temptabl/662/2008/05/30http://www.sqlservercentral.com/articles/Performance+Tuning/temptabl/662/This article demonstrates the flexibility of static SQL when using the CASE function in a WHERE clause, SELECT clause, ORDER BY clause, GROUP BY clause, HAVING clause, and JOIN. This is done with five examples and includes sample code you can execute on your SQL Server. http://www.sqlservercentral.com/articles/Performance+Tuning/howdynamiccanstaticbe/631/2002/03/14http://www.sqlservercentral.com/articles/Performance+Tuning/howdynamiccanstaticbe/631/Robert Marda continues his series on dynamic SQL and shows you how to rewrite some queries that you may think need dynamic SQL. http://www.sqlservercentral.com/articles/Performance+Tuning/dynamicvsstatic2/623/2002/03/07http://www.sqlservercentral.com/articles/Performance+Tuning/dynamicvsstatic2/623/Most DBAs and developers prefer not to use dynamic SQL for a number of reasons. There are some reasons to use this query type though. This article covers a few of those. http://www.sqlservercentral.com/articles/Performance+Tuning/whendynamicsqlisuseful/610/2002/02/12http://www.sqlservercentral.com/articles/Performance+Tuning/whendynamicsqlisuseful/610/There are times when we need to know that rows of data that meet specific criteria exist in a table. There are 2 basic ways to find this information: COUNT() and EXISTS(). Here are some examples. http://www.sqlservercentral.com/articles/Performance+Tuning/exists/551/2001/12/20http://www.sqlservercentral.com/articles/Performance+Tuning/exists/551/