By Michelle A. Poolet, 12/18/2007
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 ...
By Jeff James, 12/18/2007
Use this comprehensive list of SQL Server performance monitors to begin your product research and make the right purchasing decision.
By Douglas McDowell, 12/18/2007
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 ...
By Jeff James, 12/18/2007
Check out new and improved SQL Server–related products from GridApp Systems, O'Reilly Media, SqlLabs, Tableau Software, and xSQL Software.
By Itzik Ben-Gan, 12/18/2007
Get the solution to December's puzzle "Minimum Number of Weights," and prepare your mind for January's puzzle, which involves counting triangles.
By Anne Grubb, 12/18/2007
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, ...
By Anne Grubb, 12/18/2007
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 ...
By Andrew J. Kelly, 12/18/2007
A SQL Server 2005 DMV eases the burden of cleaning up unused indexes. Get it working in your instance.
By Itzik Ben-Gan, 12/18/2007
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 ...
By Kalen Delaney, 12/18/2007
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 ...
By Omri Bahat, 12/18/2007
Eliminate the tedium and inefficiency from moving tables and indexed views in SQL Server 2005 and SQL Server 2000 with this handy script.
By Readers, 12/18/2007
This user-defined function is flexible and easy to maintain because it uses a matrix and simple math to locate the date you need.
By Michael Otey, 12/18/2007
SQL Server 2008 can serve both your business needs and your infrastructure needs--that is, if you're even ready to migrate to it.