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, 1 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, 1 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.

this google gets you a few hits https://www.google.com/search?q=powershell+change+sql+server+service+account&oq=powershell+change+sql+ser&aqs=chrome.0.0l2j69i57j0l4j69i60.7272j0j7&sourceid=chrome&ie=UTF-8

but I advise you to use GMSA accounts instead of username/password - safer and you won't have to worry about them anymore.

Developer = Enterprise - just not licensed for production use.

no other limits neither differences.

taking in consideration who you are advising this to I have to clarify this - Developer edition CAN't...

neither is good - but having the single set statement just makes it easier for you to change your code when time comes your users complain about bad data

it does not work like that - it is not the "login name" that counts as a user, but the user of the application (or device) that connects to the...