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

Content with tags T-SQL, Performance Tuning and Scaling, Basic Querying, Performance Tuning Rss

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

SQL Server 7, 2000 (3)     Distributed Queries (1)     Miscellaneous (1)     Triggers (1)    
Stored Procedures (2)     DTS (1)     Monitoring (1)     UpdateGrams (1)    
Administering (1)     English Query (1)     OpenXML (1)     User-Defined functions (1)    
Backup and Recovery (1)     Indexing (1)     Replication (1)     XML (1)    
Configuring (1)     Installation (1)     Security (1)     XSL (1)    
   Items 1 to 5 of 5   
 

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,603 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,603 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: (not yet rated) |  Discuss |  Briefcase | 17,269 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,187 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,603 reads
   Items 1 to 5 of 5