"with recompile" is one way to avoid parameter sniffing.
I think another way is using dynamic queries in SPs. This will cause extra plans in plan cache. So make sure...

Not sure what you are looking for...if just want to get rid of left outer join, a sub-query for table InformationOverride would work. If record does not exist, null is...

A great article. Very detailed and easy to follow.

It always has pros and cons.:-)

If it’s in my coding, I would use 0.000005 in the SQL statement to save some calculation time, but put comments with detailed calculation formula...

agree, computed column is the easiest way...

If you really want to run a query, then try this:

select cp_code, total_pageviews, (1.0*total_pageviews/1000000)*5

from <view_name>

I see. the password in credential has to be the correct account password. Sorry, but your admin has to inform you if the password has been changed.:-P

Use alias on the second box.

Alias g1 point database g2.

Please check the ProtectionLevel of the SSIS package.

If it's not DontSaveSensitive, change it to.

Hope that helps.

I did the exact steps you posted and got no error.

go to SQL Server configuration manager -> SQL Server Services. Right click the service and show properities -> Service tab -> Binary Path.

I am using sql2008. not sure if...

Keys are for keeping data integrities. On fact tables, usually dimension fields are foreign keys to dimention tables. They should not have performance impact.

Indexes will help the search performance...

I don't think a group account without password will work this way. The originally purpose of doing that is to bypass different accounts that do not having access...

Thanks for all the comments. It's encouraging.:-)