By Ken Spencer, 09/19/2001
By using XSLT to customize XML output, you can provide a flexible Web service to fill a variety of needs.
By Michael Otey, 09/19/2001
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 Michelle A. Poolet, 09/19/2001
Now you can build a metamodel that’s perfect for scheduling and reservations-system databases.
By Curt A. Gilman, 09/19/2001
Count on SQL Server's bulk copy program (bcp) for importing and exporting large datasets.
By Richard Waymire, 09/19/2001
Richard Waymire answers a reader’s question about replicating added and dropped columns in SQL Server 2000.
By Brian Moran, 09/19/2001
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 Rich Rollman, 09/19/2001
Rich Rollman describes how to use JDBC to retrieve XML results from SQL Server 2000.
By Kalen Delaney, 09/19/2001
How does the optimizer know when to use an index, and which index to choose? Index statistics hold the secret.
By Various Authors, 09/19/2001
Readers commiserate about abnormal tables and poor database design.
By Richard Waymire, 09/19/2001
Richard Waymire answers a reader’s question about eliminating a recurring error message that says file operations are pending.
By Richard Waymire, 09/19/2001
Richard Waymire answers a reader’s question about changing IDs to run a DTS job on a second node.
By Michelle A. Poolet, 09/19/2001
Look for these features when you select a primary key.
By Brian Moran, 09/19/2001
Here's a query that returns information about when an instance of SQL Server started.
By Brian Moran, 09/19/2001
Microsoft provides up-to-date support for XML through Web releases. XML for SQL Server 2000 Web Release 1 is now available.
By Michael Otey, 09/19/2001
Make your SQL Server 2000 SP1 installation go as smoothly as possible with these essential steps.
By G. Andrew Duthie, 09/19/2001
ASP.NET runs circles around ASP. Learn the ins and outs of the new technology, and really put ASP.NET through its paces.
By Itzik Ben-Gan, 09/19/2001
Using computed columns in your tables can shorten your queries and minimize required code maintenance.
By Richard Waymire, 09/19/2001
Richard Waymire answers a reader’s question about replacing the data in a Microsoft Excel spreadsheet.
By Brian Moran, 09/19/2001
What are the minimum requirements for a SQL Server 7.0 license?
By Richard Waymire, 09/19/2001
Richard Waymire answers a reader’s question about coding an owner prefix to improve query performance.
By Ken Getz, 09/19/2001
Tired of manually creating virtual directories for your users? Automate the process by using the SQLVDir object.
By Rich Rollman, 09/19/2001
Rich Rollman helps a reader move XDR schemas to the new XSD.
By Richard Waymire, 09/19/2001
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 Brian Moran, 09/19/2001
How many rows can an identity column hold?
By G. Andrew Duthie, 09/19/2001
ASP.NET uses a couple of new terms that are important in understanding the technology: namespaces and assemblies.