Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags Performance Tuning, Advanced Querying Rss

   Items 1 to 9 of 9   
 

Performance Tuning: Concatenation Functions and Some Tuning Myths

Rumor has it that Concatenation functions have gotten the nasty reputation of being "performance hogs". Here's why that's not true.  Read more...
By Jeff Moden 2008/01/01 | Source: SQLServerCentral.com | Category: test data
Rating: |  Discuss |   Briefcase | 15,425 reads

Introduction to Parameterization in SQL Server

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   Read more...
By Additional Articles 2007/08/14 | Source: SQLTeam.com | Category: performance tuning
Rating:  Rate this |   Briefcase | 4,055 reads

Execution Plans

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.   Read more...
By Gulappa Vijaya Kumar 2005/10/07 (first published: 2004/05/06) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 51,579 reads

Case Sensitivity in Selects - Part 1

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?   Read more...
By Andy Warren 2004/06/03 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 10,037 reads

Execution Plans

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.   Read more...
By Gulappa Vijaya Kumar 2005/10/07 (first published: 2004/05/06) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 51,579 reads

Using Bitwise Operators to Boost Performance

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.   Read more...
By Herve Roggero 2002/09/05 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 8,558 reads

Understanding Execution Plans Part 1

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.   Read more...
By Robert Marda 2002/07/26 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 22,680 reads

How Dynamic SQL Can Be Static SQL Part 2

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.   Read more...
By Robert Marda 2002/05/14 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 10,770 reads

Making Dynamic Queries Static

Building and executing dynamic sql in a stored procedure - is it the only way to solve problems like supporting a simple search function? Leon offers a couple alternatives that let you continue to provide the functionality in a stored procedure without using dynamic sql. Interesting ideas worth exploring!   Read more...
By Leon Platt 2002/05/02 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 12,865 reads
   Items 1 to 9 of 9   
 
Tags
t-sql (7)    
sql server 7 (4)    
administration (1)    
sql server 2005 (1)    
stored procedures (1)    
test data (1)    
user defined function (udf) (1)