---

[Features]

---

Moving Tables Between Filegroups: A Better Way
Eliminate the tedium and inefficiency from moving tables and indexed views in SQL Server 2005 and SQL Server 2000 with this handy script.
 — Omri Bahat

---

[Editorial]

---

SQL Server as a Data Platform . . . Finally
SQL Server 2008 can serve both your business needs and your infrastructure needs--that is, if you're even ready to migrate to it.
 — Michael Otey

---

[Reader to Reader]

---

T-SQL Function Finds Almost Any Kind of Date
This user-defined function is flexible and easy to maintain because it uses a matrix and simple math to locate the date you need.
 — Readers

---

[Inside SQL Server]

---

Examining XML Plans in Cache
A large plan cache can seriously impact performance. By using plan-cache metadata in SQL Server 2005, you can analyze any user query without actually running the query and avoid expensive queries by comparing many plans at once.
 — Kalen Delaney

---

[Solutions by Design]

---

Data Warehousing: Slowly Changing Dimensions
When dealing with slowly changing dimensions, you can respond in three different ways. Find out what these responses to change are, and under what circumstances each response type should be used.
 — Michelle A. Poolet

---

[T-SQL Black Belt]

---

SQL Server Read-Consistency Problems, Part 2
Now that you're familiar with the read-consistency problems that can develop under the Read Uncommitted isolation, check out these tangible examples that demonstrate those problems and begin to learn some workarounds.
 — Itzik Ben-Gan

---

[New Products]

---

New Products
Check out new and improved SQL Server–related products from GridApp Systems, O'Reilly Media, SqlLabs, Tableau Software, and xSQL Software.
 — Jeff James

---

[SELECT TOP(X)]

---

SQL Server Management Studio Tips
Use SQL Server Management Studio more efficiently by taking advantage of hidden features in this great SQL Server tool—we give you the inside tips about how to use SSMS to find T-SQL errors, generate scripts, display Server Dashboard, and more.
 — Michael Otey

---

[Buyer's Guide]

---

SQL Server Performance Monitors
Use this comprehensive list of SQL Server performance monitors to begin your product research and make the right purchasing decision.
 — Jeff James

---

[Cover Story]

---

SQL Server Innovators Solve Business Problems with Style
Blending ingenuity and skill, the 2007 SQL Server Innovators winners include a T-SQL program that does math for a video poker game, a way to centrally maintain applications' data, a database maintenance tool, and a hospital disaster recovery system.
 — Anne Grubb

---

[PTO for the Rest of Us]

---

A SQL Server 2005 DMV Cleans Up Your Indexes
A SQL Server 2005 DMV eases the burden of cleaning up unused indexes. Get it working in your instance.
 — Andrew J. Kelly

---

[Sqlmag.com Community Dialog]

---

Online vs. Print Content: Finding the Right Mix
We answer a reader's question about why parts of some articles in SQL Server Magazine are available only on Sqlmag.com, and SQL Mag editors spark a lively online discussion about women in IT.
 — Anne Grubb

---

[Eye on BI]

---

My PerformancePoint Server Wish List
Microsoft Office PerformancePoint Server 2007 can enhance your BI and BPM capabilities. But the product could be even better—here's a wish list for new features and for how to integrate the various components of PPS in future releases.
 — Douglas McDowell