SQL Server Magazine August 2002

    Options
Demystifying DTS
Learn how to use DTS's powerful Data Driven Query task to manage slowly changing dimensions in your data warehouse. Then read how to boost snapshot replication performance, tame bulky inserts, overcome OpenXML hangups, and more! 		  • Subscribe
• Renew
• Master CD
• Change Mailing Address
• Customer Service
• Back Issues
• Article Reprints
• Group Discounts

Browse Archived Articles By: Issue | Author | Subject | Department |


[Focus]

DTS and the Data Warehouse

Learn the secrets behind DTS's powerful Data Driven Query task, which can help you track information as it slowly changes in your data warehouse.
By Itzik Ben-Gan 



[Features]

Manual Transmission

Trying to copy large databases from one server to multiple remote servers can throw your snapshot replication into low gear. But you can rev up the process by manually customizing the replication's steps.
By Herts Chen 



[SQL Server Savvy]

Tip: Beware of Using the QUERYOUT Option with Command-Line Bcp

A bug in bulk copy program (bcp) can cause your system's performance to slow down.
By Brian Moran 

UDF Performance Costs

User-defined functions (UDFs) make reusing logic easy and help simplify complicated SQL statements. But do UDFs have hidden performance costs?
By Brian Moran 

Using CASE to Order a Result Set

Using multiple CASE statements in an ORDER BY clause can help you get the dynamically ordered result set you want.
By Brian Moran 



[Editorial]

Get Smart with BI

BI--and the OLAP and data-mining technologies that comprise it--are aimed squarely at delivering strategic business advantages.
By Michael Otey 



[Reader to Reader]

Finding Columns for Table Joins

A reader shares the stored procedures he uses when he needs to map an unfamiliar database to find columns to use for joins.
By Readers 

Improving Audit-Field Tracking

A reader shares a method for returning detailed transaction audit information while saving disk space.
By Readers 



[SQL Seven]

Top Online Discussion Forums

The Web provides many opportunities for you to exchange ideas with other SQL Server professionals. Here are links to seven of the best online SQL Server discussion groups.
By Michael Otey 



[Inside SQL Server]

Tame Bulky Inserts

Bulky inserts got your queries down? Test and test again to find just the right sequence of index creation.
By Kalen Delaney 



[Mastering Analysis]

.NET's Seismic Shift

You might not realize it, but the .NET shift is going to be a major seismic event. Use this overview to recognize the shift’s leading indicators and prepare for the changes it will bring.
By Russ Whitney 



[T-SQL Black Belt]

Separating Elements

User-defined functions can help when you have to work with denormalized data, but don’t worry if you don’t have SQL Server 2000. You can also create a SQL Server 7.0 solution to this headache.
By Itzik Ben-Gan 



[Answers from Microsoft]

Transferring Data Over a Dial-up Connection

Microsoft’s SQL Server Development Team describes two ways to transfer data to remote servers through a dial-up connection.
By Microsoft's SQL Server Development Team 

Using Views to Control User Access to SQL Server Data

Microsoft’s SQL Server Development Team provides views for two scenarios that let a reader control the SQL Server data available to Access users.
By Microsoft's SQL Server Development Team 



[Exploring XML]

Overcoming OpenXML Hangups

Before you put OpenXML to work inserting, updating, and deleting data in a real-world application, you need to fix a couple of glitches.
By Rich Rollman 



[Letters]

Letters, August 2002

Readers write in to share tips for controlling source through Visual SourceSafe and with a question about creating fiscal calendars in Analysis Services.
By Various Authors 



[New Products]

New Products, August 2002

Check out the latest SQL Server-related new and improved products.
By Carolyn Mader