you don't need to measure everything - if someone asked you to do that they don't know what they are talking about.

and comparing a proc over all others on a...

could be due to login not valid.

How are you setting up your connection string to DB2?

and is it using username/password or other method?

A simple google gives this

changing to read only does not prevent access to it.

changing security may prevent those that need access to it to do what they need.

So if it needs to be online...

either switch it off or rename it (in case data is volatile and someone needs to look at the old content).

Either will prevent unwilling access to it as Anthony mentioned.

you have not understood anything that was transmitted to you.

you setup a job - that job restores a particular database from a particular location - if name and location is...

I would also query the MAXDOP and (CTFP) settings - you seem to have a server with 64 HT (2 numa nodes) and you seem to either have a MAXDOP...

and sometimes being (or not) unicode also gives the same error - many times this happens because someone edited or created a file manually for testing and didn't set it...

your'e welcome.

try the following.

adjust number of columns as required - and if they vary hugely you can change that part of the code to be dynamic and based on the max...

in SQL the only thing that allows something nearer regex is patindex - but it is still not full regex.

give that one some time as it can do things that...

did a bit of changes to your code - untested and may have typos so if you get any error that is most likely why

there are a few comments on...

same thing

you can do it 2 ways

1 - when you are posting you can select the option from the menu that says "insert/edit code sample" - this pops up a...

you may not need one, even if MS tells you there is a missing index - many times you add those and they either don't improve performance or they aren't...

Here is the complete code:

I a now using coalesce so that extra query inside when exists is removed. I do not see a huge performance gain though.

code deleted as...

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