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

Content with tags Performance Tuning, SQL Server 6.5 Rss

   Items 1 to 12 of 12   
 

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,295 reads

Reducing Round Trips

One of the best ways to reduce the load on your server and increase application responsiveness is to reduce the number of "round trips" your application makes. This article by Andy Warren shows you a few ways to increase your performance by reducing round trips.   Read more...
By Andy Warren 2005/07/15 (first published: 2002/01/24) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 19,853 reads

Not All SQL Server Indexes Are Created Equal

Just because a column has an index doesn't mean the SQL Server Query Analyzer will use it. Learn how to create indexes SQL Server will use.   Read more...
By Additional Articles 2004/09/24 (first published: 2001/04/22) | Source: SQL Server Performance | Category: performance tuning
Rating:  Rate this |   Briefcase | 4,433 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,295 reads

Saving Space To Increase Performance

Disk space is getting cheaper everyday. Why should you worry about the amount of space your data is consuming? This article by Neil Boyle presents some great reasons why you should be concerned.   Read more...
By Neil Boyle 2003/02/21 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 9,872 reads

SQL Server 6.5: Index Statistic Details

This article examines how index statistics are used in SQL Server 6.5   Read more...
By Alexander Chigrik 2002/02/08 | Source: SQLServerCentral.com | Category: performance tuning
Rating: (not yet rated) |  Discuss |   Briefcase | 150 reads

Reducing Round Trips

One of the best ways to reduce the load on your server and increase application responsiveness is to reduce the number of "round trips" your application makes. This article by Andy Warren shows you a few ways to increase your performance by reducing round trips.   Read more...
By Andy Warren 2005/07/15 (first published: 2002/01/24) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 19,853 reads

Lock View: sp_lock2

An alternative procedure for viewing locks based on sp_lock.   Read more...
By Alexander Chigrik 2001/07/24 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 7,372 reads

Locking in SQL Server 6.5

This article examines how locking occurs in SQL Server 6.5   Read more...
By Alexander Chigrik 2001/07/13 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,861 reads

Locking in SQL Server 6.5

This article examines how locking occurs in SQL Server 6.5   Read more...
By Alexander Chigrik 2001/06/26 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 2,683 reads

Analyze Databases Using Coefficient

In this product review by Brad McGehee, he shows you how Coefficient helps you performance tune your database.  Read more...
Rating:  Rate this |   Briefcase | 1,183 reads

Not All SQL Server Indexes Are Created Equal

Just because a column has an index doesn't mean the SQL Server Query Analyzer will use it. Learn how to create indexes SQL Server will use.   Read more...
By Additional Articles 2004/09/24 (first published: 2001/04/22) | Source: SQL Server Performance | Category: performance tuning
Rating:  Rate this |   Briefcase | 4,433 reads
   Items 1 to 12 of 12   
 
Tags
sql server 7 (6)    
t-sql (2)    
administration (1)    
ado (1)    
basics (1)    
database design (1)    
programming (1)