SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

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

   Items 1 to 6 of 6   

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: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 9,426 reads

Economies of Speed Whitepaper

Seagate has a white paper out that discusses how faster (15k rpm) drives can lead to lower cost of ownership. Interesting, and worth looking into.   Read more...
By Additional Articles 2003/05/08 | Source: Other | Category: administration
Rating:  Rate this |   Briefcase | 1,473 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,118 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,821 reads

Microsoft SQL Server 2000 Reliability

Lots of people are designing and building Microsoft Windows-based apps with previously unimagined reliability. Starbucks, GMAC, and FreeMarkets.com all have case studies demonstrating five nines. So, how are these companies able to achieve these levels of reliability?This month I am going to show you how to use standard Microsoft Windows technologies to make your Microsoft SQL Server™ app just like Denny's—“always open” and ready for business.   Read more...
By Additional Articles 2001/06/05 | Source: Microsoft MSDN | Category: performance tuning
Rating:  Rate this |   Briefcase | 1,542 reads

SQL Server 7.0 and 2000 Clustering Resources

A good place to start before clustering. Written by Brad McGhee, the founder of sql-server-performance.com.  Read more...
Rating:  Rate this |   Briefcase | 1,723 reads
   Items 1 to 6 of 6   
miscellaneous (3)    
t-sql (3)    
administration (2)    
availability (2)    
configuring (1)    
database design (1)    
indexing (1)    
naming standards (1)    
programming (1)