By Richard Waymire, 08/22/2001
Richard Waymire answers a reader’s question about using system tables to retrieve login names.
By Rich Rollman, 08/22/2001
Learn how to create an XML document that contains columns from different XML hierarchy levels in the same table.
By Richard Waymire, 08/22/2001
Richard Waymire answers a reader's question about using log shipping or replication to keep a backup server ready.
By Russ Whitney, 08/22/2001
If you write queries that use embedded calculations, you need to understand solve order and pass numbers. Here's a crash course.
By Kalen Delaney, 08/22/2001
Using nonclustered indexes to cover queries can vastly improve their efficiency. Let's look at how to make the most of these indexes.
By Richard Waymire, 08/22/2001
Richard Waymire answers a reader’s question about MDAC's adjusting its TDS stream to the server's level.
By Richard Waymire, 08/22/2001
Richard Waymire answers a reader’s question about passing parameters between VB 6.0 and DTS.
By Richard Waymire, 08/22/2001
Richard Waymire answers a reader’s question about problems using Query Analyzer to log in to SQL Server.
By Richard Waymire, 08/22/2001
Richard Waymire answers a reader's question about an error message saying the database is in use.
By Ed Roth, 08/22/2001
Because so much of your data is available online, the ability to perform highly reliable online backups is more vital than ever. Here are seven enterprise backup solutions worthy ...
By Brian Moran, 08/22/2001
How can I create the Description property in SQL Server 2000 Enterprise Manager?
By Michael D. Reilly, 08/22/2001
Here's the scoop on SQL Server 2000's recovery models and how to use them effectively.
By Kalen Delaney, 08/22/2001
Have you ever wondered how to recover just one table instead of restoring the entire database? You have plenty of options, from SQL Server 6.5's LOAD TABLE command to SQL Server ...
By Kathy Blomstrom, 08/22/2001
In an exclusive interview with SQL Server Magazine, Gordon Mangione, Microsoft's new vice president for SQL Server, talks about SQL Server's central role in the .NET strategy.
By Richard Waymire, 08/22/2001
Richard Waymire answers a reader’s question about triggering an uninterrupted series of numbers.
By Richard Waymire, 08/22/2001
Richard Waymire answers a reader’s question about archiving outdated database records automatically.
By Michael Otey, 08/22/2001
Here are seven useful things that you can do with the SELECT statement besides just returning rowsets to your application.
By Brian Moran, 08/22/2001
How do I delete duplicate records from a table?
By Michael D. Reilly, 08/22/2001
SQL Server's native backup and restore utility is powerful and reliable. Here are 11 best practices to help you make the most effective use of this capability.
By Richard Waymire, 08/22/2001
Richard Waymire answers a reader's question about problems accessing Virtual Server.
By Michael Otey, 08/22/2001
Today's Itanium systems might not be a great choice for most database implementations, but the 64-bit landscape is evolving quickly.
By Richard Waymire, 08/22/2001
Richard Waymire answers a reader’s question about controlling tempdb database growth.