SQL Server Magazine

		Options
DTS Read all about SQL Server 2000's new and improved Data Transformation Services (DTS) tasks, which could cut your DTS development time in half. Then check out our exclusive lab report to find out which is faster for moving a large amount of data into or out of a SQL Server database: bulk copy program (bcp) or DTS's Bulk Insert task.		• Subscribe • Renew • Master CD • Change Mailing Address • Customer Service • Back Issues • Article Reprints • Group Discounts
Browse Archived Articles By: Issue | Author | Subject | Department |

DTS Grows Up

SQL Server 2000's Data Transformation Services is full of new and improved tasks that make transforming your data faster and easier than ever.
By Brian Knight 

Showdown-bcp vs. DTS

Need to move a large amount of data into or out of a SQL Server database as fast as possible? This report from the SQL Server Magazine Lab compares bulk copy program and Data Transformation Services' Bulk Insert task.
By John Green 

Accessing SQL Server Named Parameters with ADO 2.6

Learn how and why to use named parameters when you use ADO 2.6 to execute SQL Server stored procedures.
By William Vaughn 

Using T-SQL to Generate a Resultset in Tree Form

Use recursive stored procedures to generate a tree from a SQL Server table.
By Rohit Nadhani  , et al.

MDX Builder 2.0

MDX Builder 2.0 from BiSense helps expert MDX developers sidestep annoying logic and syntax errors.
By Rodney Landrum 

Questions, Answers, and Tips

Learn how to manage trace operations with SQL Server Profiler, how to move databases and their objects from one server to another, how to upgrade SQL Server Personal Edition to SQL Server Standard or Enterprise Editions, and more.
By Brian Moran 

Me Too.NET

No sooner did Oracle and Sun finish lambasting Microsoft’s new .NET Framework than they both turned around and launched their own Internet application platforms—both modeled on the Microsoft.NET Framework.
By Michael Otey 

Readers' Tips & Tricks

Readers share their tips for shrinking log files, checking a disk controller's write cache, and finding and inserting missing records.
By Various Authors 

Answers from Microsoft

Microsoft’s Richard Waymire explains security with dynamic T-SQL, triggers on multiple tables, and much more.
By Richard Waymire 

Top XML-Integration Features

Check out Michael Otey's picks for SQL Server 2000's top 7 XML-integration features.
By Michael Otey 

SQL-DMO: Learning the Basics

SQL-DMO lets you program custom solutions containing administrative functions for SQL Server by exposing objects, methods, properties, and events through a COM interface.
By Rick Dobson 

The Fill-Factor Truth

Kalen Delaney leads you through the wilds of undocumented SQL Server commands to solve another mystery.
By Kalen Delaney 

Cleaning House

Sweep out the cobwebs while you upgrade your Web site.
By Ken Spencer 

XML for Analysis

Microsoft's XML for Analysis specification will help Analysis Services build a bridge to the Web and .NET.
By Russ Whitney 

Real-Life Database Design

You can design a useful database for every corner of your life—including your cherished music CD collection.
By Michelle A. Poolet 

Sorting Techniques

As NULLs, UNION ALL, and random sorting show, sorting issues aren't always trivial.
By Itzik Ben-Gan 

Microsoft Rolls Out Small Business Server 2000

Small Business Server 2000 suite, which includes SQL Server 2000, promises relief to tech-challenged small and home businesses.
By Paul Thurrott 

Oracle Ships 9iAS Release 2

Oracle targets SQL Server and IBM DB2 users with 9i Application Server Release 2.
By Paul Thurrott 

T3 Solution Smashes OLAP Records

SQL Server 2000 and partner products from EMC, Knosys, and Unisys deliver record-smashing OLAP performance in the T3 trials.
By Paul Thurrott 

XML Q&A

Rich Rollman answers readers’ questions about using XML with SQL Server 7.5, posting parameters to a template, and accessing the value of an HREF attribute.
By Rich Rollman