Stefan and Bhuvnesh,

your guess was right. I did an UPDATE STATISTICS WWIT FULLSCAN and the query runs again.

Thanks for the hint - now I know a sample size of 30.000...

Thankx for your responses.

I have seen the bad statistics you pointed me on.

Until that I believed I had updated the statistics; between every load into the database and processing of...

Hi Steve,

all tables for the view are made up of about 100 distinct versions; all are loaede together; versions are always loaded in full.

The view is (about) as follows:

select...

Hi,

unfortunately, I am not really an expert when it comes to SQL jobs. I prefer using native SSIS and develop it using BI Developer Studio.

So my direction will only work...

Hi,

this is what my personal knowledge base sais (got the snippet from somewhere on the net; sorry, no sources cited):

Here is what I've found at

http://blogs.msdn.com/sql_protocols/archive/2005/12/22/506607.aspx

Your client side setting...

Hi Johnny,

we quite regularly run across problems like this. In our company, it mostly because our customers have maintained their databases themselves for a long time and are used to...

Hi Bob,

the way to embed Reports in yaour ASP.NEt app dependes on the type of usage.

If you want to display a report in some kind of 'frame' on your page,...

Hi,

I would suggest to use the SSIS logging features. You can enable SSIS to log any error messages to a database table inside your database. If you keep the package...

Hi,

from your infos I would have a look at permissions first.

Could it be that the application pool user from the default web site is different to your special web site?...

I would suggest to implement the tab logic in HTML or whatever language you use to implement your web site and put the reports into the tab via IFRAME. This...

Hi,

I have two ideas for solutions to this problem.

First, the complex one: you could write a script task that uses the excel object model to clear the rows before appending...

Wendy,

this error most often occurs when the account specified exists in Windows, but is not associated with any SQL server rights. It could be that you have forgotten to specify...

SJ,

SSIS is designed as a batch system that transforms some data input into some data output. So output is supposed to be put into some file or table that you...

matthijs.vogt (6/4/2009)

gtschech (6/3/2009)

Phil,

this...

Hi,

your problem is related to the fact that the call new XmlSerializer(typeof("yourtype")) by default tries to create a .NET assembly on the fly, saves it to some temporary location and...