did you do any performance comparison between row/page compression? I, like you, thought about automating compression and I'm trying it out on a reporting environment. I put a ddl trigger...

You certainly can have NULL values in a dimension. You just have to adjust the NULL processing settings on the dimension. Check under the Error configuration of the dimension

I use this function to clean tabs, new lines, etc from a string. You can try it:

ALTER FUNCTION [Processing].[fnFormatString](@s varchar(200))

RETURNS varchar(200)

AS

BEGIN

RETURN ISNULL(

LTRIM( RTRIM(

REPLACE(

REPLACE(

REPLACE(

REPLACE(@s, CHAR(0), ''),

CHAR(10)...

First you are processing the Cube and then you do a process full on the dimensions? When you process full on a dimension it forces you to rebuild the cube...

Cool article. I like CozyRoc's SFTP task too

Funny you should write an article about this. This is a good topic. I solved this problem in a similar but different way.

We have hundreds of SQL servers in...