SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: February 2010

SQL Server 2008 - Adding Row Totals

During a recent client engagement I was asked if there was a quick way to add a row containing totals for each corresponding column in the details row from a Tablix item. The tablix contained about 18 columns, and the person was entering an expression that would sum the value…

Read more

0 comments, 674 reads

Posted in SQLDownSouth on 22 February 2010

Free Webinar Series This Week

If you haven’t heard already this week there is a great free webinar series going on that’s meant for beginners.  This series is meant to get you up to speed on many topics like TSQL, DBA Fundamentals, SSIS, SSAS, SSRS, and Performance Tuning.  Oh and did don’t forget… Read more

0 comments, 568 reads

Posted in Devin Knight on 22 February 2010

It will happen on a spring day in May...

"The world's favorite season is the spring. All things seem possible in May." - Edwin Way Teale This spring, the Portland, Oregon, development community is coming together in a way never experienced before. Using the University of Portland campus, SQL...(read more)

Read more

0 comments, 443 reads

Posted in SQLSequel on 22 February 2010

IgnoreUnrelatedDimensions in Analysis Services 2008

    Once of the more common issues with working with data in a cube is that it does not always line up like we expect. This is usually a combination of our interpretation of how SSAS will handle our business and a lack of understanding of some feature, option, property or…

Read more

0 comments, 430 reads

Posted in Adam Jorgensen on 22 February 2010

Basic SQL Querying From PowerShell

I promise to make this worth your time.  (Oops, I better make this quick.)

Alright so with PowerShell if you open it up and just run this code you’ll be able to query your database right from the start.  Anyone who has worked with data systems for a while will…

Read more

1 comments, 1,134 reads

Posted in SQLvariant on 22 February 2010

Christmas Holiday

We booked a vacation over the weekend, so I’m marking off the week before Christmas as vacation this year. Hoping not to get caught again with everyone but me taking time off.

Read more

0 comments, 865 reads

Posted in The Voice of the DBA on 22 February 2010

Introduction to Using Profiler with SSAS 2008

There are many ways to optimize your analysis services cubes, but the real trouble is how do you know where you’re making progress and where you’re not? Well, how would you do this in your T-SQL environment ? You’d check out a profiler trace while you were running the queries…

Read more

0 comments, 559 reads

Posted in Adam Jorgensen on 22 February 2010

I Feel Like a Heel

It’s now 3 events that I’ve canceled in the last 6 months, and a 4 or 5 more that I’ve declined an invitation to, despite having a desire to go. I got a note this morning, reminding me of a presentation tomorrow more, a remote webinar, that is supposed to… Read more

3 comments, 802 reads

Posted in The Voice of the DBA on 22 February 2010

What Does It Look Like When Everything Is Okay?

I'm a big believer in looking at systems when everything is okay. I'm not the only one, as Joe Richards, a Directory Services MVP, commented the same thing a while back. If you work with Active Directory and you don't know who Joe Richards is, you need to go ahead and revoke… Read more

What’s up with the reads?

So the other day I read Andrew Kelly’s article, Do You Have Hidden Cache Problems, in the latest electronic edition of SQL Server Magazine, and decided to run the query he listed in the article to see if my server was suffering from this problem:


Read more

4 comments, 335 reads

Posted in Wise Man or Wise Guy on 22 February 2010

When Should You Start Speaking?

I know it’s daunting and a little intimidating, but there are so many people with knowledge to share. I see them answering questions, sharing knowledge, and being helpful to the community, so when are you ready to start speaking?

The answer probably varies, but what I’ve seen in many areas… Read more

8 comments, 870 reads

Posted in The Voice of the DBA on 22 February 2010

City of Orlando Switches to Google Email

This happened earlier in the year, finally getting around to writing some notes on it – you can read more here. The numbers I found were that they were to save about $230k a year, mainly by reducing the need for two administrators.

I’ve used Outlook and Exchange for… Read more

1 comments, 670 reads

Posted in SQLAndy on 22 February 2010

Experiments with Data Compression in SQL Server 2008

Data compression is an Enterprise Edition only feature that was added in SQL Server 2008. It allows you to use either Page or Row compression on the clustered index or any non-clustered indexes on a table. Data compression lets SQL Server trade off disk space and I/O pressure for some… Read more

5 comments, 1,996 reads

Posted in Glenn Berry's SQL Server Performance on 22 February 2010

I’m givin’ ‘er all she’s got!

Or am I?

As I proceed down the path on a consolidation project, I have taken time to pause and ponder the approach.  One driving goal is to shrink our footprint.  Another goal is to improve performance and use of hardware and software resources.  I am looking to make sure… Read more

2 comments, 606 reads

Posted in SQL RNNR on 21 February 2010

SQL Server 2005 CLR execution error after restore

I recently restored a SQL Server 2005 database to a testing environment. The database contained several CLR assemblies, when the tester tried to execute one of the CLR’s SQL returned the following error:

An error occurred in the Microsoft .NET Framework while trying to load assembly id xxxxx. The server… Read more

0 comments, 944 reads

Posted in The SQL DBA in the UK on 21 February 2010

New iSCSI Performance Benchmark from Microsoft and Intel

The Windows Server Division blog has a post up trumpeting a very impressive iSCSI benchmarking result achieved with Intel hardware and Microsoft Windows Server 2008 R2 software in January of 2010. Running on server hardware equipped with an Intel Xeon 5580 CPU and an Intel 82599 10GbE network interface card… Read more

0 comments, 868 reads

Posted in Glenn Berry's SQL Server Performance on 21 February 2010

Problem Using the Aggregate Function with Calculated Measures

Recently, I was working with a client we were working on a calculated measure using the aggregate function to rollup a periodstodate calculation using a calculated measure. The value repeatedly returned null, but when I used SUM it worked fine. This appears to be directly related to an issue Microsoft…

Read more

0 comments, 620 reads

Posted in Adam Jorgensen on 21 February 2010

Measure Properties Explained


    When configuring measures in SSAS, you want to make sure you address a few important  properties. They are show in the screenshot, but let’s talk about them and what they do.

    Aggregate Function

    As shown in the screenshot you have a number of different options (pardon the pun). These are…

Read more

0 comments, 983 reads

Posted in Adam Jorgensen on 21 February 2010

Measure Group Properties Explained

When configuring measure groups in SSAS, you want to make sure you address a few important properties. They are show in the screenshot, but let’s talk about them and what they do.


Ignoring Unrelated Dimensions controls the way an unrelated measure is rolled up based on if there is…

Read more

0 comments, 2,753 reads

Posted in Adam Jorgensen on 21 February 2010

MDX Member Functions

There are a large number of Member functions in MDX that do everything from returning ancestry of a member to identifying the current member context dynamically. They can also provide some functionality around periods for opening and closing. Let’s review a few of the most important and commonly reviewed ones…

Read more

0 comments, 1,595 reads

Posted in Adam Jorgensen on 21 February 2010

Newer posts

Older posts