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

Content with tags Performance Tuning, .Net Rss

   Items 1 to 3 of 3   

Don't Throw Something New In At Production Deployment

This post comes from a conversation I had with a developer last week as well as my experiences over the...  Read more...
By 2010/03/26 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 2,828 reads

Gathering Metrics with SMO

Keeping track of the performance of your SQL Servers requires metrics. There are many methods for doing this, but some type of automated process is essential these days with DBAs managing many servers. New author Allen White brings us a technique for doing this using SMO, the replacement for DMO in SQL Server 2005.   Read more...
By Allen White 2006/11/22 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 5,798 reads

Performance Comparison: Data Access Techniques

Architectural choices for data access affect performance, scalability, maintainability, and usability. This article focuses on the performance aspects of these choices by comparing relative performance of various data access techniques, including Microsoft® ADO.NET Command, DataReader, DataSet, and XML Reader in common application scenarios with a Microsoft SQL Server™ 2000 database.  Read more...
By Additional Articles 2002/03/01 | Source: Microsoft SQL Home | Category: performance tuning
Rating:  Rate this |   Briefcase | 2,706 reads
   Items 1 to 3 of 3   
programming (2)    
ado (1)    
architecture (1)    
blogs (1)    
leadership (1)    
off-topic (1)    
sql server 2005 (1)    
sql server 7 (1)    
t-sql (1)    
visual basic 6 (1)