Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tags Strategies, T-SQL, Performance Tuning, SQL Server 7 Rss

   Items 1 to 3 of 3   

Dealing With Changing Data

As Chris points out, in most applications these days you end up having to go with optimistic locking, which presents a few challenges. Chris works through the list of options. If you're building web/disconnected apps and need anything besides last update wins, this one is for you.   Read more...
By Christoffer Hedgate 2003/12/19 | Source: | Category: performance tuning
Rating: |  Discuss |   Briefcase | 9,426 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: | Category: performance tuning
Rating: |  Discuss |   Briefcase | 18,117 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: | Category: administration
Rating: |  Discuss |   Briefcase | 13,814 reads
   Items 1 to 3 of 3   
miscellaneous (2)    
administration (1)    
database design (1)    
indexing (1)    
naming standards (1)    
programming (1)