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

Content with tags SQL Server 7, Performance Tuning Rss

   Items 1 to 20 of 139    Older >>
 

Bookmark Lookups

Building high performance applications with SQL Server can be a challenge if you do not understand how the query processor works and how the server uses indexes. SQL Server expert Randy Dyess brings a look at how bookmark lookups are used when satisfying a query and how this can impact the performance of your query.   Read more...
By Randy Dyess 2008/07/18 (first published: 2005/05/30) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 36,936 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,465 reads

The Effect of NOLOCK on Performance

Using hints in a query is something that most DBAs don't ever seem to bother with, but when they do, NOLOCK seems to be their hint of choice. Wayne Fillis brings us a detailed examination of how this particular hint actually affects the performance of your system.   Read more...
By Wayne Fillis 2007/03/23 (first published: 2007/01/24) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 52,323 reads

Bookmark Lookups

Building high performance applications with SQL Server can be a challenge if you do not understand how the query processor works and how the server uses indexes. SQL Server expert Randy Dyess brings a look at how bookmark lookups are used when satisfying a query and how this can impact the performance of your query.   Read more...
By Randy Dyess 2008/07/18 (first published: 2005/05/30) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 36,936 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,399 reads

The Effect of NOLOCK on Performance

Using hints in a query is something that most DBAs don't ever seem to bother with, but when they do, NOLOCK seems to be their hint of choice. Wayne Fillis brings us a detailed examination of how this particular hint actually affects the performance of your system.   Read more...
By Wayne Fillis 2007/03/23 (first published: 2007/01/24) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 52,323 reads

SQL Server XML Performance Tips

A series of tips on optimizing XML in your SQL Server databases.   Read more...
Rating:  Rate this |   Briefcase | 3,213 reads

The Effect of NOLOCK on Performance

Using hints in a query is something that most DBAs don't ever seem to bother with, but when they do, NOLOCK seems to be their hint of choice. Wayne Fillis brings us a detailed examination of how this particular hint actually affects the performance of your system.   Read more...
By Wayne Fillis 2007/03/23 (first published: 2007/01/24) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 52,323 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,314 reads

Analysis of SQL Server Performance Data

Gathering performance data on your servers can be a cumbersome task without paying for an expensive tool. New author Jambu Krishnamurthy brings us a short tutorial on how you can gather this data from Perfmon and import it into SQL Server for reporting.   Read more...
By Jambu Krishnamurthy 2006/10/30 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 11,116 reads

Indexes and Fragmentation in SQL Server 2000 Part 1

How do your indexes perform under different fragmentation levels in SQL 2000? Joe Doherty brings us part 1 of his look at this topic with an examination of how your data is stored and a detailed analysis of DBCC SHOWCONTIG.   Read more...
By Joe Doherty 2006/10/23 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 17,247 reads

A Guide to Application Memory Tuning

Working with memory in SQL Server and tuning your server for optimum performance gets more complex all the time, especially with the availability of 64-bit platforms. New author Paul Mu brings us a short guide to using the /3GB and PAE switches along with their implications for your server.   Read more...
By Paul Mu 2006/10/16 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 8,805 reads

Large Object Data

Dealing with text, image, and other large object data types can be confusing for many people, in all aspects of working with them. However one place that is important is performance. SQL Server MVP Simon Sabin brings us a few thoughts on improving performance with these columns and the Text in Row setting.   Read more...
By Simon Sabin 2006/10/04 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 5,916 reads

A Technique for Determining the I/O Hog in your Database

Performance Tuning can be as much an art as a science when working with SQL Server, but there are many fine techniques that can help you get started. New author Michael Morin brings a great new technique helping you get started on determining where the heavy I/O users are in your database.   Read more...
By Michael Morin 2006/08/30 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 22,632 reads

Performance Tuning Stored Procedures

Stored procedures are a great way to encapsulate code and reuse it in many places in your application. But when you have a performance issue, how do you know which part of the stored procedure is giving you problems? Steve Jones takes a look at a few techniques for diving into stored procedures and identifying problem areas.   Read more...
By Steve Jones 2006/07/20 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 25,824 reads

Analyzing Memory Requirements for SQL Server

The second in a series from Adindam Banerjee on server performance and capacity planning. This time Arindam takes a look at the memory requirements for SQL Server.   Read more...
By Arindam Banerjee 2006/07/17 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 36,699 reads

Beware of Search Argument (SARG) Data Types

Performance tuning often seems like it can be more of an art than a science. However there are a number of fundamentals that can help you tune most of the queries that you will write or have issues with their performance. Don Peterson brings us a look at how he tuned a query in the real world to avoid a conversion that can cause a query to run slower.   Read more...
By Don Peterson 2006/07/13 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 11,111 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,465 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,193 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,954 reads
   Items 1 to 20 of 139    Older >>
 
Tags
t-sql (38)    
administration (20)    
miscellaneous (19)    
configuring (15)    
programming (11)    
indexing (8)    
monitoring (7)    
ado (6)    
sql server 6.5 (6)    
strategies (6)    
sql server 2005 (5)    
stored procedures (5)    
advanced querying (4)    
backup / restore (4)    
database design (4)    
replication (4)    
visual basic 6 (4)    
basics (3)    
dts (3)    
xml (3)    
availability (2)    
distributed queries (2)    
installation (2)    
triggers (2)    
user defined function (udf) (2)    
.net (1)    
analysis services (ssas) (1)    
asp (1)    
data warehousing (1)    
english query (1)    
naming standards (1)    
news (1)    
olap server (1)    
openxml (1)    
other (1)    
security (1)    
sqlservercentral (1)    
updategrams (1)    
xsl (1)