You could query sysobjects for type 'U' (User Table) and run your command through a cursor to return the results of the statistics query for every table.

The following example will...

You can also query sys.triggers or sys.objects on type 'TR' or 'TA'

You may also need to think about Statistics, i.e. with such a large data load you should set a job to update statistics, also check to see if auto update...

The following book by Wiley has a good section on Excel with Analysis Services:

Data Mining with Microsoft SQL Server 2008

The last move I did was SSRS 2005.

I restored the dbs to new hardware with a different name and ip address as the original server following the instructions below:

Same here we use a domain account with complex passwords but they don't expire like the rest of the domain user accounts.

I don't like the idea of failing jobs because...

Is there something stopping you creating a seperate instance on the test server for the accounting database and linking to that? That way Live and Test would be on...

You may need to update any aliases your servers or clients could be using:

cliconfg.exe

Hi Hans

If you run profiler you can see exactly what the report runs.

It gets the values from DBCC SHOWFILESTATS and sys.data_spaces, DBCC SQLPERF ( LOGSPACE ), sysfiles, sys.partitions, sys.allocation_units and...

Done a bit more research and it seems although Standard Version supports Partitioned Views it does not always consider it when creating an execution plan, hence why the first query...

Thanks guys, didn't know about the first column being used for selectivity by the optimiser, that will be useful.

I'll let you know how it goes, thanks for the input guys.

Stef.

This problem does seem to point an execution plan problem.

After searching through the forum i have changed the date hardcoded values to variables and the query now completes in 4...

More observations....

If I change the query to a select * instead of doing the calculations the query returns within 1/2 minute.

If I specify a column in the select then the...

Just to confirm, you mean "execution plan", right ? Yes I did.

And you have verified that the plans are 100% identical ? Yes, I am looking more into the...

Hi PW

Just looking at pintable and although it does sound like the symptons we are experiencing are correct we do not pin any of our tables.

Thanks for your help so...