SQL Server Magazine

		Options
ADO Programming Want to write code faster--and write faster code? This issue gives you tips for tuning your code to get the best performance from your ADO applications and your development team. Also learn about multifaceted relationships, programming with SQL-DMO, and how to code fake temporary tables.		• Subscribe • Renew • Master CD • Change Mailing Address • Customer Service • Back Issues • Article Reprints • Group Discounts
Browse Archived Articles By: Issue | Author | Subject | Department |

ADO Performance Best Practices

Want to write code faster--and write faster code? Here are some tips for tuning your code to get the best performance from your ADO applications and from your development team.
By William Vaughn 

Beyond Hierarchies

Expanding your repertoire of entity relationships beyond the usual parent-child hierarchy structure could pay off big.
By Jonathan Lurie  , et al.

SQL-DMO Picks Up Where Enterprise Manager Leaves Off

Use SQL-DMO, a COM-compliant type library, to programmatically manipulate native SQL Server objects.
By Jason Fisher 

Using Fake Temporary Tables

You can use data sets inside triggers and in stored procedure calls by creating permanent tables that emulate temporary tables.
By Fernando G. Guerrero 

Log Explorer

Lumigent Technologies introduces the first tool that lets you read SQL Server 7.0 transaction logs.
By Ron Talmage 

Questions, Answers, and Tips

Brian Moran answers readers' questions about reporting BCP errors inside a DTS package, enabling the Data Access option, loading SQL Server Profiler trace data into a table, and more.
By Brian Moran 

Paying to Play

To Microsoft’s advantage, Oracle is making more headway in its marketing exploits than in its software development.
By Michael Otey 

Readers' Tips and Tricks

Readers share their tips for dynamically killing SQL Server processes and for finding and inserting missing records into a production table.
By Various Authors 

Answers from Microsoft

Richard Waymire explains how to replicate column changes, upgrade primary keys, and more.
By Richard Waymire 

Overlooked Command-Line Utilities

Michael Otey shares his picks for the seven most overlooked SQL Server command-line utilities.
By Michael Otey 

Homegrown Security Solutions

Using object permissions and user-defined roles, you can fine-tune secure access to database objects.
By Rick Dobson 

SET Options and Recompilation

Learn how to tweak your server's SET options so that you don't have to constantly recompile.
By Kalen Delaney 

Debugging Stored Procedures

Use Visual Studio 6.0’s T-SQL Debugger to debug stored procedures.
By Ken Spencer 

MDX Secret Code Revealed

Discover the secret MDX code that lets you handle cubes with large numbers of member properties.
By Russ Whitney 

Over the TOP

Use the TOP clause to limit the results of a T-SQL query to a specific number of rows--and not by specifying a logical condition.
By Itzik Ben-Gan 

Companies Deploy Commerce Server

Several well-known companies used Commerce Server 2000 to install their business systems online within weeks of the server’s debut.
By Paul Thurrott 

EU: Microsoft Stifles Server Competition

The European Union is investigating Microsoft for allegedly using its clout in desktop systems to capture the number one spot in the server market.
By Paul Thurrott 

Microsoft Names 2000 Industry Solution Award Winners

Using Microsoft technologies, eight companies developed business programs for their customers and earned Microsoft’s 2000 Industry Solution Awards.
By Paul Thurrott 

XML Q&A

Rich Rollman answers readers’ questions about storing, indexing, and retrieving XML.
By Rich Rollman