Bit of a cheat...

SELECT CASE WHEN a < 0 THEN 0 ELSE a END AS aResult

FROM ( SELECT CEILING((@aCount-@aFrom+0.0001)/@aRatio) a ) #t

use SQLCmd.exe

http://msdn.microsoft.com/en-us/library/ms162773(SQL.90).aspx

Check the executionlog table to determine if the time is spent on data retrieval or processing or rendering. If your resultset is very large, eventhough the query results may be...

Step 1:

Open your SSAS project in IDE and build it. It will generate the following files in bin folder

- YourDB.asdatabase

- YourDB.configsettings

- YourDB.deploymentoptions

- YourDB.deploymenttargets

Step 2:

Run the Analysis Services deployment wizard,...

After you create a SSAS project and build it using BIDS, you will get the list of the files that you have mentioned. Then use Analysis Services deployment (wizard or...

Check out Analysis Services deployment wizard in BOL : http://msdn.microsoft.com/en-us/library/ms176121.aspx.

I also use ASCMD in a batch file to release the XMLA scripts into prod environment.

Change the above to

where

d.contactid in (select ContactID from saleslogix.london_remote.sysdba.contact

Cheers,

Arun

Is your SSRS service and the SQL Server Database Engine (where Report Server DB resides) installed in different machines ? If so, I think you have not configured Kerberos. Check...

Follow the below method to read the file using SP

http://www.java2s.com/Code/SQLServer/Insert-Delete-Update/InsertingImages.htm

(use single quotes instead of double quotes as mentioned in the sample. You can insert this to a...

The estimate done by SSAS 2005 is not accurate in some scenarios. The processing may not require the same amount of memory as estimated. In which case, try setting SSAS...

Haven't gone through the whole post.

Couple of things

-Use UNION ALL instead of UNION

- Try to remove NOT IN using temp table and left outer join.

Its better to check the usual stuff: Disk access counters by msmdrv using Perfmon - this may give you some idea. Also, make sure AV real-time protection is turned of...

It is worth checking the design of the dimension. Does it have any user defined hierarchy? For 18 M records with just 2 attributes, it should not take this long.

What...

I use CLR to access SSAS. When data changes in data warehouse, the cube has to be processed immediatly based on the changes and I have found that using CLR...