SQL Server Magazine February 2004
[Focus]
Analysis Services is a valuable business intelligence (BI) tool, but when queries become complex, Analysis Services can bog down. Get your queries running efficiently by using these techniques for proper cube partitioning.
By Herts Chen
The next release of Analysis Services, coming in SQL Server Yukon, will combine the best aspects of traditional OLAP-based analysis and relational reporting into one dimensional model--the Unified Dimensional Model (UDM).
By Paul Sanders
[Features]
When you create a SQL Server login that has the same permissions as an existing login, the process of researching the old login's permissions and reassigning them can be tedious. Here's a way to automate permissions analysis-- and save your sanity.
By Gregory A. Larsen
[SQL Server Savvy]
Customers can end up with inaccurate benchmarks by conducting tests on SQL Server Evaluation Edition when they plan to deploy Standard Edition.
By Brian Moran
SQL Server performance won't suffer if the page file is too large and not being fully used, but having a large page file wastes disk space.
By Brian Moran
Learning how the procedures associated with running an SQL trace work is tricky because they aren't documented well. Here's an example of how you can stop a SQL Server Profiler trace and delete the definition from your server.
By Brian Moran
Failing to understand the rules of data-type precedence leads to subtle T-SQL errors and incorrect result sets that are difficult to troubleshoot.
By Brian Moran
[Editorial]
Reporting Services fills the one big hole that still exists in SQL Server: the inability to generate reports for the database. Best of all, it’s free for all existing SQL Server 2000 license holders.
By Michael Otey
[Reader to Reader]
In an enterprise that uses heterogeneous data systems, providing high-quality customer service is a challenge. Innovator Award winner Douglas McDowell shares a solution that lets a company track and solve problems quickly.
By Readers , et al.
[Inside SQL Server]
A broken link in a cross-database ownership chain can put your data at risk. Understanding SQL Server 2000’s security model can keep your data safer now and prepare you to take advantage of security enhancements in Yukon.
By Kalen Delaney
[Mastering Analysis]
Because forecasting depends on the needs of your business, creating a forecasting cube often requires some artistic finesse. Here are some techniques you can use to solve some common cube-design problems.
By Russ Whitney , et al.
[T-SQL Black Belt]
Here are some keys that open hidden back doors to special T-SQL objects.
By Itzik Ben-Gan
[Letters]
Microsoft's Lubor Kollar--responding to Itzik Ben-Gan's January 2004 column, "Take Control of Joins"--explains how to control joins in the FROM clause, noting that parentheses are optional but helpful.
By Various Authors
[New Products]
Check out the latest SQL Server-related new and improved products.
By Dawn Cyr
[SELECT TOP(X)]
To get practical knowledge and advice about implementing Microsoft technologies in your organization, check out Microsoft’s Patterns and Practices Library. Here are five database-centric guidebooks that you will find there.
By Michael Otey
|
