SQL Server Magazine December 2001
[Focus]
See how SQL Server 2000 Enterprise Manager provides built-in functionality that makes log shipping easy to set up, reconfigure, and monitor.
By Ron Talmage
If you require maximum database availability and can't afford the downtime of restoring very large databases, split-mirror technology offers an easy-to-use, hardware-based solution.
By Ron Talmage
[Features]
Find out how the Microsoft data-mining algorithms stack up against some tough training test conditions.
By Jim Yang , et al.
SQL Server's query optimizer effectively executes queries that access skewed data, but you can help improve the response time of such queries. Here's how.
By Dusan Petkovic , et al.
Use this backstage tour of Access 2002's SQL Server-related features to help determine whether the new Access release is what your organization needs.
By Rick Dobson
[SQL Server Savvy]
How can I find the syntax to execute a DTS package from within a stored procedure?
By Brian Moran
Prefixing your procedure names with sp_ causes a performance penalty.
By Brian Moran
If you create a global temporary table in SQL Server 2000, will it exist for as long as the SQL Server 2000 instance runs?
By Brian Moran
Qualifying the owner of an object when you reference it is always a good idea, even when SQL Server's default name resolution rules don't require the qualification.
By Brian Moran
What happens when a scheduled job runs longer than the scheduled interval time period?
By Brian Moran
Why don't I see data for some of the events that I've requested traces for in SQL Server 2000 Profiler?
By Brian Moran
[Editorial]
To compete as a world-class enterprise database, SQL Server must support other languages besides T-SQL. And to make sure that database applications written in these languages work as efficiently as possible, DBAs must be conversant in these languages.
By Michael Otey
[Reader to Reader]
A reader offers a tip for modifying a stored procedure so that it returns a description of all user-defined tables in a database.
By Readers
A reader describes shortcuts to two online Help files: Transact-SQL Help and Object Help.
By Readers
A reader shares a tip for using the UNION statement to produce a derived table.
By Readers
A reader offers a tip for using the stored procedure sp_dbcmptlevel to enable the TOP and ORDER BY statements for SQL Server 7.0 views.
By Readers
[SQL Seven]
Here are seven undocumented extended stored procedures that you can use to manipulate the registry.
By Michael Otey
[Inside SQL Server]
Consider your needs for sorted data carefully when building indexes on your tables.
By Kalen Delaney
[Mastering Analysis]
Responding to his most popular reader request, Russ provides 15 sample MDX queries that you can try out in Analysis Services' FoodMart Sales cube.
By Russ Whitney
[T-SQL Black Belt]
If cursors seem to be the only solution to your SQL Server problems, it's time to switch your thinking to set-based.
By Itzik Ben-Gan
[Answers from Microsoft]
Richard Waymire explains why you should avoid Autoclose and Autoshrink when you choose your database options.
By Richard Waymire
Richard Waymire provides a VB code example for a reader’s question about inserting an image into a column.
By Richard Waymire
Richard Waymire helps a reader fetch 5 million records.
By Richard Waymire
Richard Waymire tells a reader how to shrink a ballooning database and log file.
By Richard Waymire
Richard Waymire answers a reader’s question about transferring passwords during a backup and restore.
By Richard Waymire
Richard Waymire tells a reader how to avoid passing old server and database names to a new server.
By Richard Waymire
[Exploring XML]
Rich Rollman has a solution for a reader who wants to use an XML template to pass parameters to a stored procedure.
By Rich Rollman
Rich Rollman explains why a reader can’t insert data into an image-type column by using default mapping and a parameterized updategram.
By Rich Rollman
Rich Rollman shows a reader an XML Bulk Load work-around for calling a stored procedure.
By Rich Rollman
|
