SQL Server Magazine September 2001
[Focus]
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 2000's recovery models. Choose the method that works best for you.
By Kalen Delaney
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 Michael D. Reilly
[Features]
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 Michael Otey , et al.
[Lab Reports]
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 of your attention.
By Ed Roth
[SQL Server Savvy]
How can I create the Description property in SQL Server 2000 Enterprise Manager?
By Brian Moran
How do I delete duplicate records from a table?
By Brian Moran
[Editorial]
Today's Itanium systems might not be a great choice for most database implementations, but the 64-bit landscape is evolving quickly.
By Michael Otey
[SQL Seven]
Here are seven useful things that you can do with the SELECT statement besides just returning rowsets to your application.
By Michael Otey
[Inside SQL Server]
Using nonclustered indexes to cover queries can vastly improve their efficiency. Let's look at how to make the most of these indexes.
By Kalen Delaney
[Mastering Analysis]
If you write queries that use embedded calculations, you need to understand solve order and pass numbers. Here's a crash course.
By Russ Whitney
[XML Q&A]
Learn how to create an XML document that contains columns from different XML hierarchy levels in the same table.
By Rich Rollman
[Answers from Microsoft]
Richard Waymire answers a reader’s question about archiving outdated database records automatically.
By Richard Waymire
Richard Waymire answers a reader's question about using log shipping or replication to keep a backup server ready.
By Richard Waymire
Richard Waymire answers a reader’s question about problems using Query Analyzer to log in to SQL Server.
By Richard Waymire
Richard Waymire answers a reader’s question about controlling tempdb database growth.
By Richard Waymire
Richard Waymire answers a reader's question about an error message saying the database is in use.
By Richard Waymire
Richard Waymire answers a reader’s question about MDAC's adjusting its TDS stream to the server's level.
By Richard Waymire
Richard Waymire answers a reader's question about problems accessing Virtual Server.
By Richard Waymire
Richard Waymire answers a reader’s question about passing parameters between VB 6.0 and DTS.
By Richard Waymire
Richard Waymire answers a reader’s question about triggering an uninterrupted series of numbers.
By Richard Waymire
Richard Waymire answers a reader’s question about using system tables to retrieve login names.
By Richard Waymire
|
