Don't know why but that picture reminds me of the story of the RAF testing cockpits for bird-strike survivability by firing oven ready chickens at them.  When the USAF tried...

Welcome to the board Jyoti

Also, if you could provide a meaningful title to the post thread that helps others to scan for questions that they can assist with...

I would still prefer to connect to the source database and run the select statement behind the report rather than consume the report as a data source.

As already identified by others, I think what you need is a covering index which could be the current unique index and includes the fields that are required by the...

+1 for the suggestions so far.

One thing we might need to consider is whether this is an OLTP (transactional) or OLAP (reporting) database.  For transactional systems (EPOS, ticket...

I would agree that it is broke, but its not as broke as some other parts of the system 🙂

In reality most of the data is historical and...

My preferred solution for this is to create a linked server and then create synonyms for the remote tables.  When you call the truncate with the synonym it translates that...

and your successor in 5 years time will be 

"What was this guy smoking :)"

So make sure you put in comments so that it is clear it's...

My thinking behind the Temp Table is that I can build a suitable index on it, otherwise we are likely to be doing table scans.

I generally add a RANK() OVER() in a CTE to the original table then you can use

Select
          A.Field
   ...

UPDATE:

Fixed the issue with the SSIS package.  Make sure you use an ADO.NET connection and not an OLEDB.  Normally OLEDB is expected to be faster, but not in...

Thanks for the input Eirikur.  Could you post an example of what you mean.  I need the data to come out as a single file of N Statements.

I...

Thanks Anthony,

We found out what the problem was.  A 3rd party system was trying to insert records into the table and the application vendors have changed the nullability...

Thanks guys,

@bartedgerton-2, no recursive self joins - it might have been easier if there were as then the nesting would  be enforced by the application.