Do I have to rebuild all my aggs after a ProcessUpdate of my dimensions

In this thread: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=580892&SiteID=1 Edward told me that doing a ProcessUpdate of your dimensions causes the indexes and aggregations of all your partitions that use those dimensions to get dropped.

I am really worried about this. Does this mean that I have to manually rebuild all my indexes and on ALL partitions after I have done the ProcessUpdate or is it done for me?

Another worry is that if I have a big fact table this could take a long long long time. In fact I'm not just worried, that is a huge risk in my book.

Could soeone fill me in as to what happens with the indexes and aggs after they are dropped.

Thanks

Jamie

This is known and well documented situation. Most of the references talk about AS 2000, but pretty much the same logic applies to AS 2005 as well:

http://support.microsoft.com/Default.aspx?kbid=896864

http://blogs.msdn.com/bi_systems/articles/187701.aspx

you can search more about flexible aggregations and lazy processing.

In short solution to this situation is following:

1. As part of ProcessUpdate command for processing your dimensions you can specify ProcessAffectedObjects flag on the processing command. It is exposed as check box in the processing dialog.
If you select this option, the partition's aggregations and indexes are going to be rebuild as part of the same command you submitting.

2. You can turn on Lazy processing ( see Analysis Server configuraiton options whitepaper ) and Analysis Server is going to rebuild your aggregations and indexes in the backgroud after ProcessUpdate for the dimension is done.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

DNS Error

Approximately 10 minutes after I start SQL Server, some protocols such as HTTP and IRC are no longer available. When I try to open a webpage in IEX, I get a DNS error, however I can still ping the sites.
Any advice?Could you be experiencing MyDoom (http://support.microsoft.com/?kbid=836528) or Blaster (http://www.microsoft.com/security/incident/blast.mspx)? They could produce these kind of symptoms.

-PatP|||Pat,

no I don't think so, since:

-I don't have any other problems with my PC
-This started only with SQL server
-I have the latest security updates, and the extra Blaster fix
-I have a virus scanner that updates daily

Could it have something to do with the hosts file?|||Could it have something to do with the hosts file?While pretty much anything is possible, that seems unlikely to me. If that were the case, how would starting SQL Server enter into the picture (so that the sites worked before SQL starts, and fail while SQL is running)?

-PatP|||Hmm I thought because I get DNS erros...
I did the Blaster and Doom update again but no infection was found.
Anyone else any ideas what could be wrong? Or how to detect?

Edit: I checked my Event log and there is always 4 errors and 1 warning when this occurs:

Event Type: Error
Event Source: MSSQLSERVER

19012 :
SuperSocket Info: Bind failed on TCP port 1433.

Event Type: Warning
Event Source: MSSQLServer

SuperSocket-Information: (SpnRegister) : Error 1355.

But SQL Server is still working after this. I checked KB but didn't find anything.|||Just curious, but does netstat -a -n show anything relevant?

-PatP|||I`m not sure... I did some checks with that but couldn`t make to much sense
of it. Could you tell me what I`m looking for?

The problem persists... Now I am on a small network and after the said problem the whole network breaks down and I lose internet connection. I have to reboot all machines and sometimes repair the network connection Very strange indeed. I can confirm that this only happens when SQL server is started.

Other programs running:

Kaspersky AV
Webroot SypSweeper
Sometimes ICQ or mIRC
The usual XP services|||Are you absolutely certain that the machine isn't infected by Slammer (http://www.microsoft.com/technet/security/alerts/slammer.mspx)?

-PatP|||Pat I think that was it. I didn't know that my Antivirus Program may not have been aware of this exploit.

Thanks!|||De nada! Glad that you were finally able to isolate (and fix) the problem!

-PatPsql

dling xml file over SSIS possible?

i need to download a file over HTTP and get a xml file then upload it into SSIS.

Only 2 methods are available in SSIS: FTP and web method. How come there is no HTTP transfer task in SSIS? pretty strange.

then i found a script at

http://www.sqljunkies.com/howto/49e823fd-d126-4134-893d-1fd8bd3bd3ba.scuk

What kind of SSIS tasks do i need to perform this operation? I got the script above but I don't know where to key it in.

It goes in a script task.

-Jamie

|||ok i did the script task but how do i pass the variables remoteuri and the local filename to store to the script task?|||

Put them into the ReadOnlyVariables property of the script task.

http://www.google.co.uk/search?hl=en&q=task+readonlyvariables&btnG=Search&meta=

-Jamie

|||

the readonly variables i shld put

"remoteurl, localfilename"

then how i should set the remote url to http://yahoo.com/test1.xml

localfilename to "c:\test1.xml"?

i look at the urls but not much of help....make me more confused.