The Smart Guide to Building World-Class Applications
Browse By: Author | Issue
Solve your business problems with inspirations from the 2007 Innovators award-winning solutions: a T-SQL program for a video poker game, a way to centrally maintain data, a database maintenence tool, and a hospital's high-availability solution.
By Andrew J. Kelly
A SQL Server 2005 DMV eases the burden of cleaning up unused indexes. Get it working in your instance.
By Jeff James
Check out new and improved SQL Server–related products from GridApp Systems, O'Reilly Media, SqlLabs, Tableau Software, and xSQL Software.
Use this comprehensive list of SQL Server performance monitors to begin your product research and make the right purchasing decision.
By Kalen Delaney
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.
By Michelle A. Poolet
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.
By Anne Grubb
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.
By Douglas McDowell
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.
By
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 Omri Bahat
Eliminate the tedium and inefficiency from moving tables and indexed views in SQL Server 2005 and SQL Server 2000 with this handy script.
By Itzik Ben-Gan
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.
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.
Get the solution to December's puzzle "Minimum Number of Weights," and prepare your mind for January's puzzle, which involves counting triangles.
By Michael Otey
SQL Server 2008 can serve both your business needs and your infrastructure needs--that is, if you're even ready to migrate to it.
advertisement