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

Content with tags T-SQL, SQL Server 7, Performance Tuning Rss

   Items 1 to 20 of 47    Older >>
 

Is a Temporary Table Really Necessary?

In this article Randy Dyness shows you how to avoid temp tables whenever to maximize the performance of your queries.   Read more...
By Randy Dyess 2008/05/30 (first published: 2002/04/09) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 65,492 reads

Tracing Deadlocks

New Author! Deadlocks aren't the most common problem but they happen they can really degrade performance. Shiv works through how to nail down what is causing the deadlock.   Read more...
By Shiv Kumar 2007/04/06 (first published: 2004/04/06) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 43,502 reads

Table Variables

New author Jambu Krishnamurthy brings us a look at table variables and how they differ from temporary tables in SQL Server 2000.   Read more...
By Jambu Krishnamurthy 2006/11/21 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 16,345 reads

Is a Temporary Table Really Necessary?

In this article Randy Dyness shows you how to avoid temp tables whenever to maximize the performance of your queries.   Read more...
By Randy Dyess 2008/05/30 (first published: 2002/04/09) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 65,492 reads

Troubleshooting SQL Server with the Sysperfinfo Table

Joe discusses why he prefers command line tools over GUI, then launches into a how-to about querying sysperfinfo to resolve performance issues. Couple nice sample queries included!   Read more...
By Joseph Sack 2006/04/21 (first published: 2003/05/14) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 32,226 reads

Stored Procedure vs Triggers

Performance tuning is an ongoing battle in SQL Server, but having a little knowledge up front when designing an application can greatly reduce the efforts. Do you know which performs better: stored procedures or triggers? There aren't many places where the two are interchangeable, but knowing the impacts of each might change the way you build an application. Read about this analysis by Vijaya Kumar.   Read more...
By Gulappa Vijaya Kumar 2006/03/31 (first published: 2004/08/30) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 38,985 reads

Measuring SQL Performance

One thing that often amazes me is that many SQL Server developers do not actually measure the performance of their queries. Many of them thought that you needed external tools, more or less complicated, to run against your server, and they did not have the time or inclination to learn and try these. This article will describe a couple of much easier methods of measuring performance of queries.   Read more...
By Christoffer Hedgate 2005/12/23 (first published: 2004/04/02) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 33,366 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,588 reads

SQL Maintenance Plans

Do you use the maintenance plans or hate them? Wish they would do more? Curious about how they work under the hood? Cmon, you gotta read this one! Trust us, it's not another "how-to" article! Well, maybe just a little bit!   Read more...
By Andy Warren 2005/03/04 (first published: 2002/04/11) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 33,815 reads

Stored Procedures and Caching

One of the biggest performance gains built into SQL Server is the stored procedure. In this article by Brian Kelley, he shows you how to fully utilize, debug and monitor the caching of such objects.   Read more...
By Brian Kelley 2004/11/19 (first published: 2002/01/28) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 40,747 reads

Stored Procedure vs Triggers

Performance tuning is an ongoing battle in SQL Server, but having a little knowledge up front when designing an application can greatly reduce the efforts. Do you know which performs better: stored procedures or triggers? There aren't many places where the two are interchangeable, but knowing the impacts of each might change the way you build an application. Read about this analysis by Vijaya Kumar.   Read more...
By Gulappa Vijaya Kumar 2006/03/31 (first published: 2004/08/30) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 38,985 reads

Seven Showplan Red Flags

SQL Server showplan is a great tool for analyzing queries and determining whether or not more performance tuning needs to be done. However working with showplan can be confusing and it takes some practice to learn the ins and outs of what is occurring. Joseph Sack looks at showplan and seven of the main things that he is aware of when looking at the results. If you've rarely or never used showplan, this is a great article to get started in learning how an experienced DBA views the output.   Read more...
By Joseph Sack 2004/07/15 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 20,371 reads

Overview of Performance

How can you tell if your code if performing well? Do you know what you want to look for when starting to analyze code? Here's an article from Leo Peysakhovich that looks at some of the things that you can use at a high level to improve the performance of your code.   Read more...
By Leo Peysakhovich 2004/05/11 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 12,420 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,588 reads

Tracing Deadlocks

New Author! Deadlocks aren't the most common problem but they happen they can really degrade performance. Shiv works through how to nail down what is causing the deadlock.   Read more...
By Shiv Kumar 2007/04/06 (first published: 2004/04/06) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 43,502 reads

Measuring SQL Performance

One thing that often amazes me is that many SQL Server developers do not actually measure the performance of their queries. Many of them thought that you needed external tools, more or less complicated, to run against your server, and they did not have the time or inclination to learn and try these. This article will describe a couple of much easier methods of measuring performance of queries.   Read more...
By Christoffer Hedgate 2005/12/23 (first published: 2004/04/02) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 33,366 reads

Dealing With Changing Data

As Chris points out, in most applications these days you end up having to go with optimistic locking, which presents a few challenges. Chris works through the list of options. If you're building web/disconnected apps and need anything besides last update wins, this one is for you.   Read more...
By Christoffer Hedgate 2003/12/19 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 9,421 reads

Scaling Out

Kumar discusses the differences between scale up and scale out, then does a very good walk through of how to build a scale out solution.   Read more...
By Kumar Part 2003/12/03 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 7,267 reads

A Methodology for Determining Fill Factors

New Author! Jeff had some questions about fill factors - but no answers! He did some work and came up with a set of recommendations for how and when to set your fill factors to something other than the default.   Read more...
By Jeff Weisbecker 2003/11/20 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 8,792 reads

Who Cares about FillFactor?

New Author! The first of two articles this week on fill factors, this article looks at the impact fill factor can have on performance and shows you the key tools and counters you use to assess the impact of changes to fill factor.   Read more...
By Gregory Jackson 2003/11/19 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 24,997 reads
   Items 1 to 20 of 47    Older >>
 
Tags
miscellaneous (10)    
administration (7)    
programming (5)    
stored procedures (5)    
advanced querying (4)    
indexing (4)    
monitoring (4)    
configuring (3)    
strategies (3)    
visual basic 6 (3)    
ado (2)    
database design (2)    
replication (2)    
sql server 6.5 (2)    
triggers (2)    
user defined function (udf) (2)    
xml (2)    
.net (1)    
backup / restore (1)    
basics (1)    
distributed queries (1)    
dts (1)    
english query (1)    
installation (1)    
naming standards (1)    
openxml (1)    
security (1)    
updategrams (1)    
xsl (1)