This reminded me of a post some time ago by Marc Friedman where he talks about distinct aggregations and table spools. I took Paul’s solution and applied it (or at...

I’m not real great with MDX yet either but I’ll throw a couple things out there. I believe there are MIN and MAX functions but normally used with measures so...

Let's say for example I drop in a measure (call it measure1) into a cube browser and then drop a time dimension (call it time1) into the column field. In...

Thanks for the reply Derek.

I need to use the value of what I see in the Grand Total of a measure in a calculation for any given level or...

There are probably several options for your backups. On one of our databases we are lucky enough to have "monthly" data where each month I can create new filegroups and...

Thanks, Perry.

There will be only one filegroup – PRIMARY. What I am shooting for is to get the data to evenly span across multiple volumes and drives. But I was...

Here are the results of Perfmon for the 2 servers. I also set statistics IO on and pasted those results below each. The graphical execution plans were still identical. For...

We just added 2 gig of memory but I haven't had a chance to configure the max memory for sql. Is leaving 1 - 1.5 gig enough for the OS?

I'm...

You might already be planning for this but it’s probably not a bad idea to designate a couple of the extra servers you’ll end up with as test servers if...

Thanks Paul - it's great having you on the forums!

I appreciate your help.

Thanks, Paul. That helps quite a bit.

I always assumed just inserting and deleting so many records as frequently as we do would cause fragmentation. There are several columns in the...

I could be wrong here but I would think you want to try and get any critical data exported out from the database before you detach it because there is...

I ran into the same problem. Changed the sample size to 20% and still no luck so I finally just put in a T-SQL task and used sp_updatestats which is...

Thanks for the reply, Steve. I think I have a pretty fair idea of how to set this up. Now if only we could get a few minutes downtime to...

Yes, that does help.

Although I hate loosing the space, I'm thinking of using 4 of the 300 GB drives for a RAID10 on put tempdb there. The templog will...