Averages can be misleading, you could have a server idling for 16 hours, and breaking for 8.

A better technique is to have buckets with how long the server is in...

Hi

Sorry to disillusion you, but the 2010 redistributable won't install if you have 64 bit office installed.

What you need is the 32 bit version of the AccessDatabaseEngine from 2007.

a bit...

I would love to see your benchmarks of custom .NET for integration vs SSIS

You don't explicitly say so, but I assume you're using dimension level security attached to those roles.

Under dimension level security, on the advanced tab, there's a tick box "Enable Visual...

The other point not mentioned, is that, for DimDate and DimTime, the real reason over and above the performance of joining via an int (and typically not going via the...

I'd be interested to see the results of the covering index in parallel, just to set a benchmark

One day when I'm bored I'll take a stab at it

I use the tool BIDocumenter, from Pragmatic Works (http://www.pragmaticworks.com)

Disclaimer : we signed up as a reseller locally.

But the reason we did is that it is an excellent...

@Forum_Newbie

Please post the link to the security patch you are talking about, for those who encounter the same issue

If you're only using Std Edition, yeah, I can understand 2008 doesn't offer much above 2005 - SSMS is nice, but a lot of the enterprise stuff is HUGE.

The star...

There's a flip side to this whole discussion of course - we're talking about programmers not understanding how the database functions, but I have worked on both sides (dev first,...

The one place where I frequently use with (nolock) is in our datawarehousing ETLs - I KNOW that nothing else is hitting my staging database while my ETL is loading...

It’s a good point, I remember from working in Oracle DB , we’d almost always rather use parametised queries in a DAL rather than stored procedures, the only exception...

We have worked with virtual servers extensively, both in the context of cloning entire environments, and in the context of insufficient machines (the live environment is 9 servers, and we...