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

Content with tags Database Design, Performance Tuning and Scaling, Performance Tuning Rss

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

SQL Server 7, 2000 (3)     Administering (1)     Naming Standards (1)     Strategies (1)    
Basics (2)     ADO (1)     Programming (1)     Visual Basic 6 (1)    
T-SQL (2)     Miscellaneous (1)     SQL Server 6.5 (1)     XML (1)    
   Items 1 to 3 of 3   
 

Saving Space To Increase Performance

Disk space is getting cheaper everyday. Why should you worry about the amount of space your data is consuming? This article by Neil Boyle presents some great reasons why you should be concerned.   Read more...
By Neil Boyle 2003/02/21 | Source: SQLServerCentral.com | Category: Performance Tuning
Rating: |  Discuss |  Briefcase | 9,254 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: Administering
Rating: |  Discuss |  Briefcase | 10,404 reads

Reducing Round Trips - Part 2

Last week Andy started a discussion of the various ways you can reduce the number of round trips to the server. This week he continues by looking at a method he used recently to do client side caching of data to eliminate the round trip altogether. Gotta read it!   Read more...
By Andy Warren 2002/02/06 | Source: SQLServerCentral.com | Category: Performance Tuning
Rating: |  Discuss |  Briefcase | 8,688 reads
   Items 1 to 3 of 3