SQL Server Central is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
Search:  
 
 

Articles with tag Performance Tuning Rss

Refine your search with one of the following additional tags (with number of items):

T-SQL (58)     ADO (4)     OpenXML (2)     Installation (1)    
SQL Server 7, 2000 (39)     Database Design (4)     Replication (2)     Isolation Levels (1)    
Performance Tuning and Scaling (35)     Basics (3)     User-Defined functions (2)     Linked Servers (1)    
SQL Server 2005 (30)     DMVs (3)     Visual Basic 6 (2)     Naming Standards (1)    
Basic Querying (10)     Monitoring (3)     addition (1)     SQL Puzzles (1)    
Indexing (9)     Security (3)     Analysis Services (1)     SQL Server 2008 (1)    
SQL Server 6.5 (9)     Strategies (3)     Auditing (1)     SS2K5 - XML (1)    
Administering (8)     XML (3)     Best Practices (1)     Table Hints (1)    
Programming (8)     .Net (2)     Case Studies (1)     Test Data (1)    
Advanced Querying (7)     Backup and Recovery (2)     Compression (1)     Triggers (1)    
Miscellaneous (7)     Configuring (2)     Distributed Queries (1)     UDF (1)    
Stored Procedures (7)     Data Types (2)     DTS (1)     UpdateGrams (1)    
Administration (4)     Hardware (2)     English Query (1)     XSL (1)    

Search for any content tagged Performance Tuning

   Items 1 to 20 of 140    Next 20 >>
 

Using NOLOCK and READPAST table hints in SQL Server

Table locking hints provide developers much tighter control of their transactions. Look at the benefits and disadvantages of using the NOLOCK and READPAST table hints in SQL Server  Read more...
By Additional Articles 2008/07/15 | Source: Builder.com | Category: Isolation Levels
Rating:  Rate this |  Briefcase | 4,252 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 posted: 2002/04/09) | Source: SQLServerCentral.com | Category: Performance Tuning
Rating: |  Discuss |  Briefcase | 59,073 reads

Lengthy SQL Server Queries Will Consume Your CPU

The SQL (Structured Query Language) language is a declarative language that became the "Data Language" used for describing "what I need" and "where to fetch it from" in most organizations. OOP (Object Oriented Programming) languages became the most common practice among developers widely adopted by R&D organizations around the world. So how do we bridge the gap?  Read more...
By Additional Articles 2008/05/23 | Source: MSSQLTips.com | Category: Performance Tuning
Rating:  Rate this |  Briefcase | 2,692 reads

Execution Plan Basics

Every day, out in the various discussion boards devoted to Microsoft SQL Server, the same types of questions come up again and again: Why is this query running slow? Is my index getting used? Why isn't my index getting used? In order to arrive at the answer you have to ask the same return question in each case: have you looked at the execution plan? We are very pleased to be allowed to publish the first chapter of Grant Fritchey's excellent new book on execution plans.  Read more...
By Additional Articles 2008/05/22 | Source: SimpleTalk | Category: Performance Tuning
Rating:  Rate this |  Briefcase | 4,344 reads

Making the Most Out of the SQL Server 2005 Performance Dashboard

The SQL Server 2005 Performance Dashboard is a new add-on to SQL Server 2005 that became available shortly after the release of Service Pack 2 for SQL Server 2005.  Read more...
Rating:  Rate this |  Briefcase | 6,526 reads

Best Practices for Troubleshooting Slow Running Queries

In this article we will share some of the common reasons for slow-running queries and what your approach should be for identifying and fixing them.   Read more...
By Additional Articles 2008/05/08 | Source: SQL Community | Category: Performance Tuning
Rating:  Rate this |  Briefcase | 7,097 reads

SQL 2005 vs. SQL 2008 Part 1 - (Backup File Sizes & Times)

SQL 2008 has some key improvements over SQL 2005. This article deals with backup compression and faster backups in SQL 2008  Read more...
By Kevin van der Merwe 2008/05/05 | Source: SQLServerCentral.com | Category: Compression
Rating: |  Discuss |  Briefcase | 9,301 reads

Top Queries in SQL Server 2005

This article illustrates how to query dynamic management views to find the TOP queries based on average CPU and average I/O.  Read more...
By Additional Articles 2008/04/09 | Source: Database Journal | Category: SQL Server 2005
Rating:  Rate this |  Briefcase | 4,848 reads

SQL Server Index Checklist

Indexing a SQL Server database in some respects is considered both an art and a science. Since this is the case, what are some considerations when designing indexes for a new database or an existing one in production? Are these the same types of steps or not? Do any best practices really exist when it comes to indexing? Where does indexing fall in the priority list from an application or production support perspective?  Read more...
By Additional Articles 2008/04/03 | Source: MSSQLTips.com | Category: Indexing
Rating:  Rate this |  Briefcase | 3,454 reads

Writing Faster T-SQL

How many times have you wished that your queries performed better? Performance Tuning is a bit of an art, but learning about new techniques and which things work help grow your knowledge. Jacob Sebastian brings us the first part of a series on writing better performing queries.   Read more...
By Jacob Sebastian 2007/05/22 | Source: SQLServerCentral.com | Category: Performance Tuning
Rating: |  Discuss |  Briefcase | 26,041 reads

More RBAR and "Tuning" UPDATEs

SQL Server expert Jeff Moden discusses a common problem seen in many update statements.  Read more...
By Jeff Moden 2008/03/14 | Source: SQLServerCentral.com | Category: Performance Tuning
Rating: |  Discuss |  Briefcase | 6,593 reads

Monitoring Stored Procedure Performance with sys.dm_exec_cached_plans

This article will show you how to use the sys.dm_exec_cached_plans DMV to monitor the performance of stored procedures  Read more...
Rating: (not yet rated)  Rate this |  Briefcase | 2,767 reads

Not In v Not Equal

Is it better to use NOT IN() or <> in a T-SQL query? Ken Johnson had the question put to him and decided to investigate them both. Read about how these two functions perform.   Read more...
By Ken Johnson 2007/05/29 | Source: SQLServerCentral.com | Category: Performance Tuning
Rating: |  Discuss |  Briefcase | 18,534 reads

Why Object Qualification is important.

You have all read about why object qualification is important. You also must have heard of why stored Proc should not have sp_ as prefix to the name. Now let us proove if this is all true.  Read more...
By Roy Ernest DBA 2008/03/10 | Source: SQLServerCentral.com | Category: T-SQL
Rating: |  Discuss |  Briefcase | 7,219 reads

Linked Server Optimization

This article demonstrates the negative affect that linked servers can cause in queries and offers alternatives to speed up performance.  Read more...
By Bill Richards 2008/03/07 | Source: SQLServerCentral.com | Category: Linked Servers
Rating: |  Discuss |  Briefcase | 7,816 reads

SQL Server non-clustered indexes for query optimization

Optimize SQL Server non-clustered indexes and queries by considering index fields, compound indexes and SQL Server statistics' impact on non-clustered indexes.  Read more...
By Additional Articles 2008/03/05 | Source: SearchSQLServer | Category: Indexing
Rating: (not yet rated)  Rate this |  Briefcase | 2,581 reads

Check List for Performance Optimisation in SQL Server Analysis Service 2005

This article is a step-by-step checklist to help ensure that you are obtaining the maximum performance possible from SQL Server Analysis Services.  Read more...
Rating: (not yet rated)  Rate this |  Briefcase | 1,492 reads

How SQL Server Chooses the Type of Join

How many times have you had a stored procedure run quicker in Query Analyzer than it does in the application? Mike Dillon tracked down one possible cause in this article.   Read more...
By Mike Dillon 2007/05/07 | Source: SQLServerCentral.com | Category: Performance Tuning
Rating: |  Discuss |  Briefcase | 15,163 reads

Designing High Performance Stored Procedures

Stored procedures can be an effective way to handle conflicting needs, but it's not always so obvious how to write them so they both perform well and scale.  Read more...
By Additional Articles 2007/02/05 | Source: DevX | Category: Performance Tuning
Rating:  Rate this |  Briefcase | 8,878 reads

Importance of UPSERT

A simple UPSERT can reduce reads on tables. This in turn will increase the performance of a DB.  Read more...
By Roy Ernest DBA 2008/01/29 | Source: SQLServerCentral.com | Category: T-SQL
Rating: |  Discuss |  Briefcase | 6,480 reads
   Items 1 to 20 of 140    Next 20 >>
 
Most popular

SQL 2005 vs. SQL 2008 Part 1 - (Backup File Sizes & Times)

SQL 2008 has some key improvements over SQL 2005. This article deals with backup compression and faster backups in SQL 2008  Read more...
By Kevin van der Merwe 2008/05/05 | Source: SQLServerCentral.com | Category: Compression
Rating: |  Discuss |  Briefcase | 9,301 reads

More RBAR and "Tuning" UPDATEs

SQL Server expert Jeff Moden discusses a common problem seen in many update statements.  Read more...
By Jeff Moden 2008/03/14 | Source: SQLServerCentral.com | Category: Performance Tuning
Rating: |  Discuss |  Briefcase | 6,593 reads

Execution Plan Basics

Every day, out in the various discussion boards devoted to Microsoft SQL Server, the same types of questions come up again and again: Why is this query running slow? Is my index getting used? Why isn't my index getting used? In order to arrive at the answer you have to ask the same return question in each case: have you looked at the execution plan? We are very pleased to be allowed to publish the first chapter of Grant Fritchey's excellent new book on execution plans.  Read more...
By Additional Articles 2008/05/22 | Source: SimpleTalk | Category: Performance Tuning
Rating:  Rate this |  Briefcase | 4,344 reads