The Smart Guide to Building World-Class Applications
Browse By: Author | Issue
In this issue, we explore SQL Server 2000 Enterprise Manager's built-in log shipping functionality and investigate how new split-mirror backup technology can provide maximum availability for very large databases.
By Itzik Ben-Gan
If cursors seem to be the only solution to your SQL Server problems, it's time to switch your thinking to set-based.
By Wayne Kurtz
Find out how the Microsoft data-mining algorithms stack up against some tough training test conditions.
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.
Rich Rollman shows a reader an XML Bulk Load work-around for calling a stored procedure.
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 Richard Waymire
Richard Waymire answers a reader’s question about transferring passwords during a backup and restore.
Richard Waymire tells a reader how to avoid passing old server and database names to a new server.
Richard Waymire helps a reader fetch 5 million records.
By Michael Otey
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 Russ Whitney
The November 2001 MDX Puzzle challenged you to use the FoodMart 2000 Sales cube to analyze the effects of a promotion on overall sales. Here's the solution.
Richard Waymire explains why you should avoid Autoclose and Autoshrink when you choose your database options.
Richard Waymire tells a reader how to shrink a ballooning database and log file.
Richard Waymire provides a VB code example for a reader’s question about inserting an image into a column.
By
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 Rick Dobson
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.
A reader shares a tip for using the UNION statement to produce a derived table.
A reader offers a tip for modifying a stored procedure so that it returns a description of all user-defined tables in a database.
How can I find the syntax to execute a DTS package from within a stored procedure?
A reader describes shortcuts to two online Help files: Transact-SQL Help and Object Help.
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 Ron Talmage
Learn more about Storage Area Networks.
What happens when a scheduled job runs longer than the scheduled interval time period?
Why don't I see data for some of the events that I've requested traces for in SQL Server 2000 Profiler?
By Christian Unterreitmeier
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.
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.
See how SQL Server 2000 Enterprise Manager provides built-in functionality that makes log shipping easy to set up, reconfigure, and monitor.
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.
Here are seven undocumented extended stored procedures that you can use to manipulate the registry.
Prefixing your procedure names with sp_ causes a performance penalty.
Learn where to find more information about the model-training performance of the clustering algorithm.
By Kalen Delaney
Consider your needs for sorted data carefully when building indexes on your tables.
Rich Rollman has a solution for a reader who wants to use an XML template to pass parameters to a stored procedure.
Here's a fun puzzle to test your MDX skills.
advertisement