Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags SQL Server 7, ADO Rss

   Items 1 to 14 of 14   
 

Copying DTS Packages To a Different Server

How do you easily copy DTS packages from one server to another? DTS, BCP, T-SQL? Are there advantages to using one method over another? Andy did some research - read the article and see what works and what doesn't!   Read more...
By Andy Warren 2006/05/05 (first published: 2002/03/19) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 37,485 reads

Reducing Round Trips

One of the best ways to reduce the load on your server and increase application responsiveness is to reduce the number of "round trips" your application makes. This article by Andy Warren shows you a few ways to increase your performance by reducing round trips.   Read more...
By Andy Warren 2005/07/15 (first published: 2002/01/24) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 19,853 reads

Introduction to ADO Part 2 - Recordsets

Part two in the Introduction to ADO series, this beginner level article shows how to open a recordset, how to add and edit records, and touches lightly on how to select the best cursor type and locking mode. Good code samples help you get started fast!   Read more...
By Andy Warren 2003/11/28 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 16,198 reads

Worst Practice - Bad Connection Strings and Bad Info in Sysprocesses

Andy returns to the Worst Practice series this week with a short article looking at how connection strings in applications affect what you see in sysprocesses. Perhaps less controversial (in our opinion) that some of the other worst practices, this is something easy to fix and definitely worth fixing! Read the article and post a comment - explore other points of view! Readers posting a comment will be entered in a drawing for a copy of the SQL Server 2000 Resource Kit.   Read more...
By Andy Warren 2003/08/01 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 15,031 reads

Review of Real-World SQL-DMO

Andy takes a look at the new book on DMO and likes what he sees - "great book for beginner and intermediate DMO users!". We've been supporters of DMO for a while and we're glad to see a new book on the subject. Read the review, add your comments, buy the book!   Read more...
By Andy Warren 2002/11/19 | Source: SQLServerCentral.com | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 5,245 reads

Copying DTS Packages To a Different Server

How do you easily copy DTS packages from one server to another? DTS, BCP, T-SQL? Are there advantages to using one method over another? Andy did some research - read the article and see what works and what doesn't!   Read more...
By Andy Warren 2006/05/05 (first published: 2002/03/19) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 37,485 reads

Reducing Round Trips - Part 3

This week Andy continues his series on how to reduce the number of round trips to the server by looking at some things you can easily add to your applications without a lot of rearchitecting.   Read more...
By Andy Warren 2002/03/11 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 7,851 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,393 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 | 9,234 reads

Reducing Round Trips

One of the best ways to reduce the load on your server and increase application responsiveness is to reduce the number of "round trips" your application makes. This article by Andy Warren shows you a few ways to increase your performance by reducing round trips.   Read more...
By Andy Warren 2005/07/15 (first published: 2002/01/24) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 19,853 reads

Review of SQL Comparison and Synchronization Toolkit

This week Andy takes a look at a new product from Red-Gate that gives you even more options than you get with their SQL Compare and SQL Data Compare tools - now you can build your own. Add the features you always wanted. Build automated processes instead of using the GUI. It's an interesting product - read the review and then maybe even enter the contest to win a free copy.   Read more...
By Andy Warren 2002/01/16 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 5,361 reads

Improve System Performance in Your Indexing Scheme Using Asynchronous

The Web Data Administrator is a utility program implemented in ASP.NET that enables you to easily manage your SQL data, wherever you are.  Read more...
By Additional Articles 2001/10/10 | Source: Microsoft MSDN | Category: administration
Rating:  Rate this |   Briefcase | 1,476 reads

Work Around Errors in Database Web Apps

ne of the issues you face when building Web applications is handling the errors you encounter when interacting with a back-end database. I was recently working with someone to create a new Web site with SQL Server™, ActiveX® Data Objects (ADO), and ASP. Lots of little things came up that I thought were worth sharing with MIND readers, so I'll focus this column on what I learned from this experience and the solutions to many of the problems I faced.   Read more...
By Additional Articles 2001/07/13 | Source: Microsoft MSDN | Category: miscellaneous
Rating:  Rate this |   Briefcase | 1,243 reads

Taming the Stateless Beast: Managing Session State

Running a Web farm means managing session state across servers. Since session state can't be shared across a Web farm with Internet Information Services 5.0, a custom solution is required. One such solution using a tool called the session manager is described here.   Read more...
By Additional Articles 2001/07/06 | Source: Microsoft MSDN | Category: performance tuning
Rating:  Rate this |   Briefcase | 1,263 reads
   Items 1 to 14 of 14   
 
Tags
programming (12)    
visual basic 6 (7)    
miscellaneous (6)    
performance tuning (6)    
administration (5)    
configuring (4)    
.net (2)    
asp (2)    
replication (2)    
sql-dmo (2)    
t-sql (2)    
backup / restore (1)    
basics (1)    
best and worst practices (1)    
database design (1)    
dts (1)    
security (1)    
sql server 6.5 (1)    
worst practices (1)    
xml (1)