By Anne Grubb, 06/27/2008
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 William Vaughn, 06/27/2008
See how you can set up a clickthrough report without using SQL Server Reporting Services (SSRS).
By Jeff James, 06/27/2008
Check out new and improved SQL Server–related products from Data Dynamics, iT-Workplace, AVIcode, ApexSQL, and Thomas Smyczek.
By Derek Comingore, 06/27/2008
Learn how to use SQL Server 2008's Data Profiling task and Data Profile Viewer to examine and assess your data.
By Editors, 06/27/2008
A reader disagrees with comparative review's findings.
By Michael Otey, 06/27/2008
Find out how these two virtualization products compare in architecture, performance, and price.
By Michael Otey, 06/27/2008
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 ...
By Michael Otey, 06/27/2008
SQL Server Compact Edition 3.5 is Microsoft’s smallest full relational database—check out these FAQs to learn more.
By Bill McEvoy, 06/27/2008
Understand the differences between inner, outer, and cross joins before you use them in your queries.
By Readers, 06/27/2008
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 Michael K. Campbell, 06/27/2008
Avoid 10 common developer pitfalls with a little preparation.
By Itzik Ben-Gan, 06/27/2008
Get the solution to June’s puzzle, “Josephus Problem.”
By Andrew J. Kelly, 06/27/2008
Avoid re-indexing pandemonium by using the rebuild_indexes_by_db stored procedure to tackle only indexes that actually need help.
By Itzik Ben-Gan, 06/27/2008
Use SQL Server 2008’s new data type to maintain and query hierarchical data.
By Michelle A. Poolet, 06/27/2008
Learn how to model your database to support both market basket and affinity analysis.