SQL Server Central is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
Search:  
 
Home Articles Editorials Forums Scripts Blogs QotD SQL Jobs Training Authors About us Contact us Newsletters Advertise Write for us
 

Articles with tags T-SQL, Stored Procedures, SQL Server 7, 2000, Performance Tuning Rss

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

Performance Tuning and Scaling (3)     Configuring (1)     Installation (1)     Triggers (1)    
Administering (2)     Distributed Queries (1)     Miscellaneous (1)     UpdateGrams (1)    
Basic Querying (2)     DTS (1)     OpenXML (1)     User-Defined functions (1)    
Monitoring (2)     English Query (1)     Replication (1)     XML (1)    
Backup and Recovery (1)     Indexing (1)     Security (1)     XSL (1)    

Search for any content tagged T-SQL & Stored Procedures & SQL Server 7, 2000 & Performance Tuning

   Items 1 to 4 of 4   
 

Stored Procedures and Caching

One of the biggest performance gains built into SQL Server is the stored procedure. In this article by Brian Kelley, he shows you how to fully utilize, debug and monitor the caching of such objects.   Read more...
By Brian Kelley 2004/11/19 (first posted: 2002/01/28) | Source: SQLServerCentral.com | Category: Administering
Rating: |  Discuss |  Briefcase | 34,297 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 | 17,501 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,275 reads

Stored Procedures and Caching

One of the biggest performance gains built into SQL Server is the stored procedure. In this article by Brian Kelley, he shows you how to fully utilize, debug and monitor the caching of such objects.   Read more...
By Brian Kelley 2004/11/19 (first posted: 2002/01/28) | Source: SQLServerCentral.com | Category: Administering
Rating: |  Discuss |  Briefcase | 34,297 reads
   Items 1 to 4 of 4   
 
 
Copyright © 2002-2008 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use