In this lesson, we revisit usage-based optimization, a subject that we undertook in my article MSAS Administration and Optimization: Simple Cube Usage Analysis, in September of 2003, and MSAS Administration and Optimization: Toward More Sophisticated Analysis in October of 2003. In the earlier articles, we discovered that, among several tools that Microsoft SQL Server 2000 Analysis Services offered us to assist in the maintenance and optimization of our cubes, two of these tools, the Usage Analysis Wizard and the Usage-Based Optimization Wizard, leveraged the usage-based optimization features of Analysis Services.

PART 8: ESTIMATION

by Additional Articles

TDAN

Advanced

Data modeling is no doubt one of the most important and challenging aspects of developing, maintaining, augmenting and integrating typical enterprise systems. More than 90% of functionality of enterprise systems is centered round creating, manipulating and querying data. It therefore stands to reason that individuals managing enterprise projects should leverage on data modeling to execute their projects successfully and deliver not only capable and cost effective but also maintainable and extendable systems

SQL Writer in SQL Server 2005

by Additional Articles

TechNet Blogs

Administration

Definitely written for backup ISVs, but this is an interesting architectural article as to how the backup systems will work in SQL Server 2005.

Outer Join Trouble

by Steve Jones

SQLServerCentral.com

SQL Puzzles

Writing outer joins can be more difficult than it appears at first glance. Steve Jones examines this less often used query technique and brings to light a few places where you can lose data.

THE ROLE OF DATA DICTIONARY

by Additional Articles

TDAN

Design and Theory

IT leaders from enterprises around the world have realized that acquiring and implementing commercial off-the-shelf (COTS) application packages is a smarter thing to do, than the traditional approach of developing home-grown applications. This may not be the fit-for-all solution, but it makes sense from a cost, time to market and resource standpoint. Selection and acquisition of the software package is just the first step. How the software package brings value through successful implementation, is critical to the business. Internal groups as well as industry analysts will closely watch COTS package implementation in the organization.

Clustered Indexes in SQL Server: Things You Need to Know

by Additional Articles

SQL Server Performance

Indexing

This article covers a few, more advanced topics about the usage of clustered indexes in SQL Server. Not only will I try to convince you of the absolute necessity of using clustered indexes, I'll also give you some tips on how to use them in a not so obvious context.

Securing SQL Server

by Press Release

SQLServerCentral.com

SQLServerCentral

the January magazine is being printed right now and should be mailed out early next week. Read the editorial and see how you can get you e-copy now!

Digging Into Access Performance

by Andy Warren

SQLServerCentral.com

Access

Access can be a very quick and easy to use tool for working with SQL Server data and for quick and dirty projects, it might be the best tool. But there can be performance issues at times and Andy Warren digs into some of these based on some analysis of what Access does behind the scenes.

Creating an End-to-End Package

by Brian Knight

White Knight Technology

Integration Services (SSIS)

In this sample chapter, you'll get a full tutorial on how to create an end-to-end SSIS package including transformation, looping and archiving of files.

Cursors and embedded SQL

by Additional Articles

Redgate

Advanced Querying

In the days when I contentedly cut procedural code, I was puzzled by the visceral rages of the database specialists; they were like the ship’s cook occasionally going berserk with a meat-cleaver. After I switched to database work, I realized why.”

Usage-Based Optimization in Analysis Services 2005

PART 8: ESTIMATION

SQL Writer in SQL Server 2005

Outer Join Trouble

THE ROLE OF DATA DICTIONARY

Clustered Indexes in SQL Server: Things You Need to Know

Securing SQL Server

Digging Into Access Performance

Creating an End-to-End Package

Cursors and embedded SQL

Blogs

Mastering the ORDER BY Clause in SQL Window Functions

How to Get Web Design Clients: 12 Practical Tactics That Work

SQL Data Pipelines: The Ultimate Guide to Streamlining Your Data Flow

Forums

test new topic

New article

Monitoring Azure Blob Storage

Question of the Day

Azure Data Lake Storage Gen 2