SQL Server Magazine January 2008
[Features]
Eliminate the tedium and inefficiency from moving tables and indexed views in SQL Server 2005 and SQL Server 2000 with this handy script.
By Omri Bahat
[Editorial]
SQL Server 2008 can serve both your business needs and your infrastructure needs--that is, if you're even ready to migrate to it.
By Michael Otey
[Reader to Reader]
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 Readers
[Inside SQL Server]
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 Kalen Delaney
[Solutions by Design]
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 Michelle A. Poolet
[T-SQL Black Belt]
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.
By Itzik Ben-Gan
[New Products]
Check out new and improved SQL Server–related products from GridApp Systems, O'Reilly Media, SqlLabs, Tableau Software, and xSQL Software.
By Jeff James
[SELECT TOP(X)]
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.
By Michael Otey
[Buyer's Guide]
Use this comprehensive list of SQL Server performance monitors to begin your product research and make the right purchasing decision.
By Jeff James
[Cover Story]
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 Anne Grubb
[PTO for the Rest of Us]
A SQL Server 2005 DMV eases the burden of cleaning up unused indexes. Get it working in your instance.
By Andrew J. Kelly
[Sqlmag.com Community Dialog]
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.
By Anne Grubb
[Eye on BI]
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 Douglas McDowell
|
