SQL Server Magazine

		Options
.NET Technologies In this issue's focus on .NET technologies, we explore ASP.NET and how you can provide a flexible Web service by using XSLT to customize XML output.		• Subscribe • Renew • Master CD • Change Mailing Address • Customer Service • Back Issues • Article Reprints • Group Discounts
Browse Archived Articles By: Issue | Author | Subject | Department |

Flexible Data Exchange

By using XSLT to customize XML output, you can provide a flexible Web service to fill a variety of needs.
By Ken Spencer 

Not Your Father's ASP

ASP.NET runs circles around ASP. Learn the ins and outs of the new technology, and really put ASP.NET through its paces.
By G. Andrew Duthie 

Creating SQL Server 2000 Virtual Directories

Tired of manually creating virtual directories for your users? Automate the process by using the SQLVDir object.
By Ken Getz 

The ABCs of Bcp

Count on SQL Server's bulk copy program (bcp) for importing and exporting large datasets.
By Curt A. Gilman 

Determining Identity Value Capacity

How many rows can an identity column hold?
By Brian Moran 

Obtaining a SQL Server 7.0 License

What are the minimum requirements for a SQL Server 7.0 license?
By Brian Moran 

Retrieving SQL Server's Last Start Date and Time

Here's a query that returns information about when an instance of SQL Server started.
By Brian Moran 

Tip: Bulk-Load Support for XML Files

Microsoft provides up-to-date support for XML through Web releases. XML for SQL Server 2000 Web Release 1 is now available.
By Brian Moran 

Using SQL Server Agent to Manage a Batch Process

T-SQL doesn't provide support for asynchronous branching and execution, but here's a way around a time-consuming trigger and batch process.
By Brian Moran 

ADO.NET Loopholes

ADO.NET is the new kid on the data-access block, and like all new technologies, it offers some great new benefits and some potential liabilities.
By Michael Otey 

Service Pack 1 Installation Steps

Make your SQL Server 2000 SP1 installation go as smoothly as possible with these essential steps.
By Michael Otey 

Statistically Speaking

How does the optimizer know when to use an index, and which index to choose? Index statistics hold the secret.
By Kalen Delaney 

Metamodel for Reservations System

Now you can build a metamodel that’s perfect for scheduling and reservations-system databases.
By Michelle A. Poolet 

Storing Computations

Using computed columns in your tables can shorten your queries and minimize required code maintenance.
By Itzik Ben-Gan 

Adding Fields to a Replicated Database

Richard Waymire answers a reader’s question about replicating added and dropped columns in SQL Server 2000.
By Richard Waymire 

Coding an Owner Prefix to Avoid Recompilation

Richard Waymire answers a reader’s question about coding an owner prefix to improve query performance.
By Richard Waymire 

Placing a Clustered Index on an Integer Column

Richard Waymire answers a reader’s four-part question about the advantages and disadvantages of placing a clustered index on a table’s primary key.
By Richard Waymire 

Running a DTS Job on a Second Machine

Richard Waymire answers a reader’s question about changing IDs to run a DTS job on a second node.
By Richard Waymire 

Troubleshooting a SQL Server 2000 Installation Error Message

Richard Waymire answers a reader’s question about eliminating a recurring error message that says file operations are pending.
By Richard Waymire 

Truncating Data

Richard Waymire answers a reader’s question about replacing the data in a Microsoft Excel spreadsheet.
By Richard Waymire 

Converting XDR Schemas to XSD

Rich Rollman helps a reader move XDR schemas to the new XSD.
By Rich Rollman 

Using Java to Retrieve XML from SQL Server

Rich Rollman describes how to use JDBC to retrieve XML results from SQL Server 2000.
By Rich Rollman 

The Pain of Poor Database Design

Readers commiserate about abnormal tables and poor database design.
By Various Authors