SQL Server Magazine October 2001
[Focus]
By using XSLT to customize XML output, you can provide a flexible Web service to fill a variety of needs.
By Ken Spencer
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
[Features]
Tired of manually creating virtual directories for your users? Automate the process by using the SQLVDir object.
By Ken Getz
Count on SQL Server's bulk copy program (bcp) for importing and exporting large datasets.
By Curt A. Gilman
[SQL Server Savvy]
How many rows can an identity column hold?
By Brian Moran
What are the minimum requirements for a SQL Server 7.0 license?
By Brian Moran
Here's a query that returns information about when an instance of SQL Server started.
By Brian Moran
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
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
[Editorial]
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
[SQL Seven]
Make your SQL Server 2000 SP1 installation go as smoothly as possible with these essential steps.
By Michael Otey
[Inside SQL Server]
How does the optimizer know when to use an index, and which index to choose? Index statistics hold the secret.
By Kalen Delaney
[Solutions by Design]
Now you can build a metamodel that’s perfect for scheduling and reservations-system databases.
By Michelle A. Poolet
[T-SQL Black Belt]
Using computed columns in your tables can shorten your queries and minimize required code maintenance.
By Itzik Ben-Gan
[Answers from Microsoft]
Richard Waymire answers a reader’s question about replicating added and dropped columns in SQL Server 2000.
By Richard Waymire
Richard Waymire answers a reader’s question about coding an owner prefix to improve query performance.
By Richard Waymire
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
Richard Waymire answers a reader’s question about changing IDs to run a DTS job on a second node.
By Richard Waymire
Richard Waymire answers a reader’s question about eliminating a recurring error message that says file operations are pending.
By Richard Waymire
Richard Waymire answers a reader’s question about replacing the data in a Microsoft Excel spreadsheet.
By Richard Waymire
[Exploring XML]
Rich Rollman helps a reader move XDR schemas to the new XSD.
By Rich Rollman
Rich Rollman describes how to use JDBC to retrieve XML results from SQL Server 2000.
By Rich Rollman
[Letters]
Readers commiserate about abnormal tables and poor database design.
By Various Authors
|
