SQL Server Magazine July 2008
[Focus]
Avoid 10 common developer pitfalls with a little preparation.
By Michael K. Campbell
[Features]
See how you can set up a clickthrough report without using SQL Server Reporting Services (SSRS).
By William Vaughn
Learn how to use SQL Server 2008's Data Profiling task and Data Profile Viewer to examine and assess your data.
By Derek Comingore
Understand the differences between inner, outer, and cross joins before you use them in your queries.
By Bill McEvoy
[Editorial]
Tests of server virtualization products VMware ESX Server 3.5 and Windows Server 2008 Hyper-V, plus SQL Server running four virtual machines (VMs) indicate that SQL Server running in a VM is ready to handle production workloads.
By Michael Otey
[Reader to Reader]
No temporary tables or table variables are needed to perform FOR XML PATH concatenation, so the resulting query is not only fast but also high performing.
By Readers
[Solutions by Design]
Learn how to model your database to support both market basket and affinity analysis.
By Michelle A. Poolet
[T-SQL Black Belt]
Use SQL Server 2008’s new data type to maintain and query hierarchical data.
By Itzik Ben-Gan
[Letters]
A reader disagrees with comparative review's findings.
By Editors
[New Products]
Check out new and improved SQL Server–related products from Data Dynamics, iT-Workplace, AVIcode, ApexSQL, and Thomas Smyczek.
By Jeff James
[SELECT TOP(X)]
SQL Server Compact Edition 3.5 is Microsoft’s smallest full relational database—check out these FAQs to learn more.
By Michael Otey
[Review]
Find out how these two virtualization products compare in architecture, performance, and price.
By Michael Otey
[PTO for the Rest of Us]
Avoid re-indexing pandemonium by using the rebuild_indexes_by_db stored procedure to tackle only indexes that actually need help.
By Andrew J. Kelly
[Sqlmag.com Community Dialog]
An informal poll shows that SQL Mag readers prefer quality over quantity of articles—and would rather not pay more for a larger magazine.
By Anne Grubb
|
