How about REPLACENULL( «expression», «expression» )

I agree downtime is downtime just make sure your SLA and measurements are clear on that point and shouldn't be a problem. We should always be striving to reduce downtime...

Still working through my problem but I did have some updates I thought I would share. So far a couple of things going on here.

1) first off the script I...

Good point let me check a system with SQL 2008 Non R2 and see what it's doing.

I have this solution partly implemented. I have recently upgraded quite a few servers to Windows 2008 R2 and SQL 2008 R2 and just found out that the vb script...

My take is it all depends on how this is performed and what process the company you work for undertakes. To me the best process encompasses continuous performance management. Agreed...

Jesse can you point to a reference on how alert suppression works?

Tom, I did finally get this all setup and thanks a ton for this. I am still having some issues on certain instances not showing up. I'll dig more but...

I have searched on this quite a bit and keep finding the simple answer of turn it off. I get that but my question is why is it on in...

So what I'm struggling with is I have a server dedicated to processing cubes (only MSAS 2008 installed) with all kinds of resources in procs and memory and I can't...

Have you had any issues with aggregations taking exponentially longer after upgrading a cube from 2005 to 2008. I am and can't figure out why.

Peel away, totally not a problem and is actually pretty neat technology. My opinion is that if you need to advertise to keep the lights on then go for it...

I have experienced similar issues. In my example the arrow keys and backspace keys on the keyboard do not work.

I have not found a patch, if you find one can...