that has another few views within it - need those also

when you are querying this view are you applying any filtering or just doing a select * from view without...

The main difference between PowerBI & SSRS are the datasets.  An SSRS report runs the dataset each time the report is invoked.  PowerBI caches the data from the first...

that is a straight basic sql with a top 1, a where clause and a order by. - either assign to a variable and check the contents of the variable...

and if that view uses other views post the definition of those also.. recursively

It would decrease use of tempdb and increase usage of what ever db you put those tables on.

might be worth seeing if those temp tables can be redone so size...

can you post table and indexes ddl for that table.

if you need to add a trace flag you do it through configuration manager so it is there whenever the instance starts.

net start does not support parameters - it will...

you need 'tempdb..#xxx' when checking for object existence.

e.g. if object_id('tempdb..#xxx') is not null drop table #xxx;

other than the case above you do not need to reference tempdb.. and you can...

following will help.

1 - get ride of those nolock

if you really have to use them and your business signs off on the possibility of having bad data being supplied to...

• This reply was modified 5 years, 10 months ago by frederico_fonseca.

one question that may help this.

why so many updates? and how are they being done - SQL please, not just explaining.

and potentially why aren't some being done as part of...

1. Tables get truncated
2. Constraints get dropped
3. Bulk imports
4. Table updates
5. Index and constraints get created

Day in day out. Somehow 2 weeks ago the process is 30 to 40...

• This reply was modified 5 years, 10 months ago by frederico_fonseca.

It doesn't sound like a memory issue, but if you are sure it is you could reduce the memory SQL Server uses just before the SSIS packages run and...

and is SSIS running packages through SSIS Catalog, filesystem or msdb? 32 bit or 64 bit - and are you access databases from other vendors using their drivers (Oracle, DB2...

easy - a select with a where with a update with a replace and a where clause.

what have you tried so far and what issues did you get ? this...

which adds to justify not using nolock unless absolutely required and with knowledge that such cases will not occur.