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

<< Newer    Items 21 to 40 of 47    Older >>
 

Displaying Execution Plans

Randy starts a multiple part series on tuning queries. We've asked Randy to really start from scratch and walk through the process. This week he takes a look at viewing query plans in Query Analyzer.   Read more...
By Randy Dyess 2003/08/19 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 20,582 reads

Monitoring Performance

Vicktor has a bunch of scripts he uses to monitor performance, he explains why he built them and how to use them. Good coverage of the different reasons for slow performance.   Read more...
Rating: |  Discuss |   Briefcase | 16,162 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,209 reads

Auto Close and Auto Shrink - Just Don't

New author! Mike Pearson discusses how auto close was at the root of a performance problem he was troubleshooting, how you can check your servers easily, and discusses why both auto close and auto shrink are bad ideas in a production environment.   Read more...
By Mike Pearson 2003/05/05 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 19,920 reads

Review of SQL 2000 Fast Answers

A monster book at 980 pages, it's written in 'how-to' format and has a ton of good material. Andy gave it the once over for us and reports back - see what he thinks!   Read more...
By Andy Warren 2003/04/18 | Source: SQLServerCentral.com | Category: installation
Rating: |  Discuss |   Briefcase | 18,205 reads

Identifying performance issues using Profiler

It is always better to be proactive than reactive, when it comes to identifying and eliminating SQL Server performance issues. This article shows you how to analyze the data gathered by Profiler, to identify the performance issues. This article also provides four generic stored procedures for analyzing Profiler output.   Read more...
By Additional Articles 2003/04/01 | Source: Other | Category: administration
Rating:  Rate this |   Briefcase | 2,458 reads

Cluster That Index!

Quite a while back Andy wrote an article about why not using primary keys and clustered indexes was a worst practice. Chris weighs in this week with a great article that gives some more in depth info on clustered indexes and why he thinks they should be used on every table.   Read more...
By Christoffer Hedgate 2003/03/30 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 18,061 reads

Analyzing and Optimizing T-SQL Query Performance on SQL Server

This white paper discusses the basics of indexes, such as density and selectivity, effects of many versus few indexes, long versus short keys, covering indexes, and how the SQL Server optimizer chooses indexes  Read more...
By Additional Articles 2003/03/14 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 2,170 reads

What is the search order for Procedures prefixed sp_?

In this article, James Travis covers a common performance topic of prefixing stored procedures sp_. Does it really slow down performance?   Read more...
By James Travis 2002/11/14 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 6,727 reads

Performance Adding Hints

During the process of performance tuning queries and stored procedures there comes a time when you will notice that the execution plan selected by SQL Server is not the best plan. On occasion, everything you try doesnt cause SQL Server to choose the best way to execute your code. These are the times when hints can improve performance.   Read more...
By Robert Marda 2002/09/10 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 8,922 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,537 reads

Interact with SQL Server's Data and Procedure Cache

This article briefly discusses SQL Server's data and procedure cache and shows you the common Transact-SQL statements/command and system tables that you can use to interact with the cache through Transact-SQL.   Read more...
By Randy Dyess 2002/08/15 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 13,793 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,558 reads

Using Interface-Based Programming Techniques in SQL Server

Programmers can most commonly relate to interface-based programming in their programming language. This is harder to accomplish in SQL Server though. In this article by Chris Cubley, he shows you how to build interfaced-based SQL.   Read more...
By Chris Cubley 2002/07/19 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 6,815 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,864 reads

SQL Server 2000 Table Hints

As you advance in your skills as a Transact-SQL developer or SQL Server database administrator there will come a time when you need to override SQL Server's locking scheme and force a particular range of locks on a table. This article by Randy Dyess shows you how to optimize your queries using table hints.   Read more...
By Randy Dyess 2002/04/15 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 21,225 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,812 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,478 reads

Performance Comparison: Data Access Techniques

Architectural choices for data access affect performance, scalability, maintainability, and usability. This article focuses on the performance aspects of these choices by comparing relative performance of various data access techniques, including Microsoft® ADO.NET Command, DataReader, DataSet, and XML Reader in common application scenarios with a Microsoft SQL Server™ 2000 database.  Read more...
By Additional Articles 2002/03/01 | Source: Microsoft SQL Home | Category: performance tuning
Rating:  Rate this |   Briefcase | 2,390 reads

Optimizing Stored Procedures To Avoid Recompiles

One of the most overlooked areas in optimizing SQL Server and Transact-SQL is the recompilations of stored procedures. A database getting thousands of recompiles an hour will suffer in performance and show short term blocking that will affect the database users. This article by Randy Dyess shows you some of the ways you can avoid stored procedure recompiles.   Read more...
By Randy Dyess 2002/02/26 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 20,876 reads
<< Newer    Items 21 to 40 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)