Monthly Archives: April 2008

Influencing the Execution Plan

Posted on April 14, 2008 by Clay Lenhart

I had a performance problem recently with SQL Server. This post shows an easy relatively hands-off approach to influencing the execution plan. Continue reading →

Posted in SQL Server Development | Tagged , , | 1 Comment

Cached Execution Plans in SQL Server

Posted on April 13, 2008 by Clay Lenhart

This blog entry describes how you can get the SQL Server execution plan of any running statement and display the graphical representation in Enterprise Manager. Continue reading →

Posted in SQL Server Administration | Tagged , , , , , , | 1 Comment

SSAS Beginner’s Guide: Storage Structure

Posted on April 7, 2008 by Clay Lenhart

This is a second entry in a series on SQL Server Analysis Services (SSAS). To see the other blog entries on this tutorial, click on the SSAS Beginner’s Guide on the top bar. Relational Databases Let’s take a quick look … Continue reading →

Posted in SSAS | Tagged , | 7 Comments

SQL Server Analysis Services (SSAS) Series

Posted on April 1, 2008 by Clay Lenhart

I am going to use this blog to convince a friend to use SQL Server Analysis Services (SSAS) in his projects because it makes it easier to write reports on as compared to relational databases. Part of the challenge is … Continue reading →

Posted in SSAS | Tagged , | Leave a comment