Hi Sebastian,
Thanks for your reply. I try your script with success. The site is up :)

I have another question regarding with performance, specifically about your script TurboDNN.

Currently, the start up time is very long. Once the site show up, everything go faster. I thought the TurboDNN script could help. I'm right? In any case, I try the script and receive the following message:

------------
-- make sure, all constraints are enabled
IF (ServerProperty(N'EngineEdition') != 5) --Check for not running on SQL Azure
EXEC sp_msforeachtable "ALTER TABLE ? WITH CHECK CHECK CONSTRAINT all"
Msg 547, Level 16, State 0, Line number 1
The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_TanLD_ContactUsLocalization_Modules". The conflict occurred in database "DotNetNuke731", table "dbo.Modules", column 'ModuleID'.
------------

Appreciated any suggestion.

Julio

Hi Sebastian,

Thanks for the suggestion.

My ObjectQualifier is ''. With you input, I check the table and the tanld correspond with a custom module (TanLD Contact Us, http://store.dnnsoftware.com/vendor-p...).

I will ignore the message and assume everything work fine (including the TurboDNN script).

Do you suggest to apply the rest of the scripts to improve the performance?

Thanks

Julio