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

Content with tags T-SQL, Visual Basic 6, Programming Rss

   Items 1 to 16 of 16   
 

Introduction to ADO - The Command Object

The third article in a four part series, this week Andy shows how to use the command object to work with stored procedure parameters.   Read more...
By Andy Warren 2007/02/09 (first published: 2001/12/18) | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 39,457 reads

Data Dictionary from within SQL Server 2000

Mindy explores the metadata stored in SQL 2000 to show you how to produce a simple and useful data dictionary!   Read more...
By Mindy Curnutt 2005/02/04 (first published: 2002/02/11) | Source: SQLServerCentral.com | Category: installation
Rating: |  Discuss |   Briefcase | 35,783 reads

Managing Jobs Part 3

This week Andy looks at where, when, and how jobs should be run and why you need to think about those items before you build the job. Part of this is deciding what runs on production servers and what doesn't.   Read more...
By Andy Warren 2003/03/11 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 7,109 reads

Default Values and Named Parameters for Stored Procs

Are you using default values for your parameters? Using named parameters when you call the proc or passing the values by ordinal? Should you be? Andy thinks 6 out of 10 of our readers will agree with his point of view, we'll be a little more conservative and guess that 5 of out 10 will be closer.   Read more...
By Andy Warren 2003/01/08 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 8,151 reads

Restoring Using DMO - Getting File List and No Recovery

Following up on a question posted in our discussion area, Andy demonstrates how to backup/restore a database using DMO, how to get the list of files to be restored, and how to do a restore with no recovery. Lots of sample code!   Read more...
By Andy Warren 2002/10/15 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 8,480 reads

Generating HTML Tables

In this article Andy looks at one way you can separate your presentation code from your data when you generate HTML tables for simple reports. Lots of code examples so you can see how it works.   Read more...
By Andy Warren 2002/08/05 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 5,787 reads

Using Interface-Based Programming Techniques in SQL Server

Programmers can most commonly relate to interface-based programming in their programming language. This is harder to accomplish in SQL Server though. In this article by Chris Cubley, he shows you how to build interfaced-based SQL.   Read more...
By Chris Cubley 2002/07/19 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 6,815 reads

Version Control for Stored Procedures

Version control for stored procedures isn't always popular and certainly isn't easy. Or can it be? Andy discusses a technique he used on a recent project that you might find interesting.   Read more...
By Andy Warren 2002/05/10 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 13,367 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,390 reads

Data Dictionary from within SQL Server 2000

Mindy explores the metadata stored in SQL 2000 to show you how to produce a simple and useful data dictionary!   Read more...
By Mindy Curnutt 2005/02/04 (first published: 2002/02/11) | Source: SQLServerCentral.com | Category: installation
Rating: |  Discuss |   Briefcase | 35,783 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,233 reads

XML Data Solutions

This sample is provided in conjunction with the MSDN Magazine article, "SQL Server 2000 and XML: Developing XML-Enabled Data Solutions for the Web." This article presents and compares five data access approaches, using a variety of technologies including ASP and ADO, XSLT, and DirectXML. Once built, the solutions are compared on the basis of their speed and efficiency.   Read more...
By Additional Articles 2002/01/18 | Source: Microsoft MSDN | Category: updategrams
Rating:  Rate this |   Briefcase | 2,407 reads

Introduction to ADO - The Command Object

The third article in a four part series, this week Andy shows how to use the command object to work with stored procedure parameters.   Read more...
By Andy Warren 2007/02/09 (first published: 2001/12/18) | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 39,457 reads

HOWTO: Run Singleton SELECT Queries in a Visual Basic Client

This article demonstrates how to retrieve a single record from SQL Server by using the IRow interface with a singleton SELECT. The main purpose for this technique is to avoid the overhead of creating a recordset when you are fetching a single record. Because no recordset is actually created, only one read-only ADODB.Record is returned. This is true even if the specified SELECT results in multiple records being returned if a normal ADODB.Recordset is used.   Read more...
By Additional Articles 2001/11/26 | Source: Microsoft MSDN | Category: t-sql
Rating:  Rate this |   Briefcase | 1,489 reads

Using COM to Output Queries to a Text File

This article presents a method of outputting the results of a query as a tab delimited text file using COM.   Read more...
By Les Smith 2001/07/20 | Source: SQLServerCentral.com | Category: advanced querying
Rating: |  Discuss |   Briefcase | 6,553 reads

Executing Multiple Scripts in a Folder using the ScriptRunner Utility

Ever have a large batch of scripts you need to run? It takes a while if you have to open each one in Query Analyzer and execute it. One of our readers proposed an alternative - take a look the small app Andy Warren wrote to make doing this task a breeze.   Read more...
By Andy Warren 2001/06/14 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 9,579 reads
   Items 1 to 16 of 16   
 
Tags
miscellaneous (9)    
sql server 7 (8)    
ado (6)    
administration (4)    
stored procedures (4)    
basics (3)    
database design (3)    
performance tuning (3)    
strategies (3)    
.net (2)    
advanced querying (2)    
configuring (2)    
sql-dmo (2)    
xml (2)    
backup / restore (1)    
installation (1)    
updategrams (1)