---

[Focus]

---

Making Package Magic
Microsoft has completely rewritten SQL Server 2005 DTS, making the DTS Import/Export Wizard an even more effective tool for quickly building packages for moving data. Follow along with this example to learn about the wizard’s new features.
 — Kirk Haselden

---

[Features]

---

A View to Automation
Stored procedures can save you time and simplify common tasks such as table updates. But you can make your life even easier by using SQL Server information schema views to automatically generate the procedures you use the most.
 — Alex Glauberzon , et al.


Automatic Reindexing
Reindexing your database tables to eliminate fragmentation is important for maintaining your databases’ health, but it can be time-consuming. Here’s a utility that uses DBCC SHOWCONTIG to automate this essential task.
 — Derek Wilson


Integration Testing
Piece by piece, then all together, test your application code by following this simple plan.
 — Dan Sawyer

---

[Departments]

---

MSDE Reborn
Microsoft has introduced SQL Server 2005 Express Edition to replace Microsoft SQL Server Desktop Engine (MSDE). Find out what’s changed and what’s remained the same!
 — William Vaughn

---

[SQL Server Savvy]

---

Query Analyzer Doesn't Accurately Report I/O for UDFs
You can get a wrong answer if you're using Query Analyzer to analyze I/O for a query that includes a user-defined function (UDF). And wrong answers lead to poor query-tuning decisions.
 — Brian Moran


SQL Server Tools Return Different Results
Learn why you different SQL Server tools return widely varying statistics information about the same event.
 — Brian Moran


Using T-SQL to Automatically Move Tables
You can automate the process of moving a table--not just its indexes--to a different filegroup using T-SQL. Here's how!
 — Brian Moran

---

[Editorial]

---

Making Sense of the CLR
Michael Otey dispels some myths and gives readers the real scoop about SQL Server 2005's CLR integration.
 — Michael Otey

---

[Inside SQL Server]

---

Trouble with Mixed Extents
If mixed extents are causing contention in your database, these solutions can smooth out the ruffled pages and get your database purring along again.
 — Kalen Delaney

---

[T-SQL Black Belt]

---

Understanding Query Filters and Clauses
If you don't know which clause to specify a logical expression in, you're not alone. Learn why logical query-processing order matters.
 — Itzik Ben-Gan

---

[New Products]

---

New Products, October 2004
Check out the latest SQL Server-related new and improved products.
 — Dawn Cyr

---

[SELECT TOP(X)]

---

Visual Studio 2005 Team System
Visual Studio 2005 Team System enters enterprise development space. Here are Team System's top five new enterprise-oriented features.
 — Michael Otey

---

[Ask Microsoft]

---

Remotely Installing a SQL Server Hotfix
Microsoft's Richard Waymire says installing a hotfix from a remote desktop session works fine.
 — Microsoft's SQL Server Development Team


Resizing a Column in a Large Table
Microsoft's Richard Waymire says your best bet for changing the size of a column in a large table is to use the ALTER TABLE command.
 — Microsoft's SQL Server Development Team


Tracking Auto-Growing Databases
Microsoft's Patrick Conlan explains how to baseline file sizes to determine when a database is auto-growing.
 — Microsoft's SQL Server Development Team