http://www.sqlservercentral.com/Content tagged T-SQL, Advanced Querying, Performance Tuning posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)In a previous article I showed how to look at what query plans are in SQL Server's memory. In this article I'll look at how they got there and how and when they get reused. This is commonly called compiling a query plan. More specifically I'll look at how and when SQL Server can parameterize dynamic SQL http://www.sqlservercentral.com/redirect/articles/3155/2007/08/14http://www.sqlservercentral.com/redirect/articles/3155/How many of you use Execution Plans to tune your queries? Do you understand the impact of different indexes? Mr. Vijayakumar looks at his experiments with different types of indexes and their effects on the execution plan use. A great article for those of you that want to learn more about how you can tune your server for better performance. http://www.sqlservercentral.com/articles/Administering/executionplans/1345/2005/10/07http://www.sqlservercentral.com/articles/Administering/executionplans/1345/Your SQL Server has a case insensitive collation, but you need a case sensitive join? Do you know what happens? There are a couple options but do you know the performance implications of using each? Or a way to mitigate the performance degradation that can result? http://www.sqlservercentral.com/articles/Performance+Tuning/casesensitivityinselectspart1/1368/2004/06/03http://www.sqlservercentral.com/articles/Performance+Tuning/casesensitivityinselectspart1/1368/How many of you use Execution Plans to tune your queries? Do you understand the impact of different indexes? Mr. Vijayakumar looks at his experiments with different types of indexes and their effects on the execution plan use. A great article for those of you that want to learn more about how you can tune your server for better performance. http://www.sqlservercentral.com/articles/Administering/executionplans/1345/2005/10/07http://www.sqlservercentral.com/articles/Administering/executionplans/1345/Bitwise operators can be challenging to manage at first. However, with practice and patience, and under the right conditions, these operators can provide remarkable performance improvements in production environments. This article will compare two methods of accomplishing the same output, one with a normalized model and the other with bitwise operators. http://www.sqlservercentral.com/articles/Performance+Tuning/usingbitmaskoperators/790/2002/09/05http://www.sqlservercentral.com/articles/Performance+Tuning/usingbitmaskoperators/790/The purpose of this article is to give you a working knowledge of how to view and understand query execution plans for SQL Server. This is part 1 in a series of articles that will walk you through understanding execution plans to help you improve your queries. http://www.sqlservercentral.com/articles/Performance+Tuning/understandingexecutionplans/739/2002/07/26http://www.sqlservercentral.com/articles/Performance+Tuning/understandingexecutionplans/739/This article shows you how to use the CASE function to design single query solutions that have changing results depending on the values you assign to variables. These techniques are extremely useful as alternatives to dynamic SQL. http://www.sqlservercentral.com/articles/Performance+Tuning/howdynamicsqlcanbestatic2/684/2002/05/14http://www.sqlservercentral.com/articles/Performance+Tuning/howdynamicsqlcanbestatic2/684/