Additional Articles

A New Way to View and Analyze Your Data

by Additional Articles

Microsoft SQL Home

With Data Analyzer—the brand-new Office data analysis solution—you can quickly and easily view, analyze, and share business data, giving you the power to make better business decisions.

2001-11-30

4,798 reads

Discuss

HOWTO: Run Singleton SELECT Queries in a Visual Basic Client

by Additional Articles

Microsoft MSDN

T-SQL

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.

2001-11-26

1,684 reads

Discuss

SQL Server 2000 Replication Chat Hosted by PASS Today

by Additional Articles

PASS

Service Packs

SQL Server 2000 has better replication capabilities than ever before! Do you have questions about using Replication on SQL Server? Whether it be transactional or merge replication, you can not find a better group of guys to answer your questions. Right from the development team, Matt Hollingsworth and Dean Kalanquin, replication program manager and test lead respectively are setting aside this time to take on your most challenging replication questions!

2001-11-15

3,885 reads

Discuss

Programming with SQL Server in .NET

by Additional Articles

ASPToday

Learn the in's and out's of programming with SQL Server in .NET

2001-11-09

987 reads

Discuss

PASS Chat on SQL Server 2000 SP2 BETA Today!

by Additional Articles

PASS

PASS Chat on SQL Server 2000 SP2 BETA Post Mortem this week! Your peers will be there - Don't miss the chance to get involved! PASS Chats are exclusively co-hosted with Microsoft TechNet.

2001-11-08

3,251 reads

Discuss

Cursor Performance

by Additional Articles

SQLTeam.com

Performance Tuning

An anaysis of performance using cursors in T-SQL.

2001-11-02

1,265 reads

Discuss

XML for SQL Server 2000: Optimizing Your Performance

by Additional Articles

Microsoft SQL Home

Basics

The XML features of Microsoft® SQL Server® 2000 and the subsequent XML for SQL Server 2000 Web releases enable a whole new class of XML-aware applications. This article shows you how to improve the performance of this new feature.

2001-11-01

2,241 reads

Discuss

SQLXML 2.0 (XML for SQL Server 2000)

by Additional Articles

Microsoft MSDN

Microsoft® SQL Server 2000 introduced several new features for querying database tables and receiving the results as an XML document. Web release 1 of SQLXML (XML for SQL Server) added Updategrams and XML Bulk Load functionality, as well as a host of other features to the SQL Server 2000 base.

2001-10-29

6,623 reads

Discuss

Query to Display Trigger Status

by Additional Articles

SQLServerCentral

Maintenance and Management

Ever wanted to know whether your triggers are enabled or not? The ObjectProperty command allows you to select information about the status of objects in your database, returning 1 for True and 0 for False. The example below determines whether a single trigger is disabled. SELECT ObjectProperty(object_id('Trigger_Name'), 'ExecIsTriggerDisabled') There are a number of other useful […]