It depends^tm.:-P

On one hand the SSIS sort will introduce blocking in your data flow.

On the other hand you'll have the cost of both writing and reading from the staging table...

Link to walkthru on an SSRS scale out

http://www.mssqltips.com/sqlservertip/2335/scale-out-sql-server-2008-r2-reporting-services-farm-using-nlb-part-1/

The only thing I would add is make sure you have console access to the report server when configuring MS NLB as you...

This was the first link on Google for "extract SSAS database"

How to: Create an Analysis Services Project Based on an Existing Analysis Services Database

http://msdn.microsoft.com/en-us/library/ms365361%28v=sql.105%29.aspx

TDE occurs when the pages are written to disk or read from disk. This means that TDE has little to no impact on page or row compression. You...

If you look at the properties on the select operator you'll notice that the query plan is timing out. I would move the inner query into a temp table...

You can create a dummy result set at the beginning of the stored procedure that matches the column names and data types of your actual result set. Just remember...

There were some bugs regarding cascading parameters in the RTM release of 2008. The following link has more information regarding updates that fix the problem.

http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/be4f5bc9-a170-49b9-966b-de1b29b3a3a5

SQL Prompt will already do this somewhat. Right click, script object as alter. An alter script with the object will be created in a new tab.

You cannot install integration services without a separate license.

Would the RTRIM function not work?

CREATE TABLE [#Names] (

[First_Name] [char] (14) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

...

These look HL7 messages (particularly for ICD 9) and you should be able to find a freeware parser for them.

I think it's quite typical for messages to be stored...

For analysis services you only supply a percentage of RAM to use, not an amount in MB as in SQL Server. So if you allocate 40% to both instances...

So what I'm wanting to do is install analysis services 2008 R2 on the same box that's running SQL 2008 server and 2008 analysis services do you guys think this...

In the chart axis properties set the LabelInterval property to 1. You'll need to do this from actual properties window(F4) and not from the axis context properties.

It seems like this would be trivial in any cube browser if you added a measure to the cube for calls with a

"ResolvedDate <= TargetResolutionTime"