The SSIS lookup task is case sensitive when it does comparisons, and there is a reasonable chance your database is set to a case insensitive collation. That would mean the...

I can see no error messages in any of those images - Can you post the exact text of the message you are seeing please?

I would suggest you post...

Can you post the definition of 'NEWTABLE' as used in your example, and when you say anything is passed in - can you show a call to the function that...

Just to say you are not alone in finding the current behaviour odd. There must have been some reason for it, but I just cannot understand what benefit there is...

Can you explain a little more what you are actually trying to do? You seem to have 3 separate queries there - what final result do you want?

Mike John

When you say "move" - do you mean update the dischargedate in the table to currentdate + 1 or just treat it that way ion the where clause of this...

There will be lots of things you can do.

Can you post the table definitions (create table etc) index definitions, sample execution plan for how this query is being executed, and...

From what you are saying these different columns sound like should be of several different data types, such things as account balances, credit limits, date last ordered, date last accessed,...

I'm going to use the classic answer.

"It Depends."

if you ALWAYS want all columns retrieved together then a single table will be faster at getting everything compared with multiple tables.

BUT in...

Most likely is the space has not been reclaimed in the old table yet. If you have no clustered index on a table some operations can not free up the...

I would have a read of the link Gail gave above. The others are not really answerable without knowing what else the server is running.

As for explaining to client...

SQL Server is designed to use as much memory as Windows will allow it, so unless you are experiencing problems elsewhere I would leave well alone.

You "may" need to restrict...

I have hit this myself in the past. It is not so much the catch that does not work - that handles errors that are raised just fine. However sp_start_job...

Sorry for misreading the stars/quotes - eyes must be getting old!

No reason I can think of for one or the other option not working - unless you actually have leading...

Two quick options

either

select ..

from a

inner join b on a.col1 = '"' + b.col1 + '"'

or

select ..

from a

inner join b on replace(a.col1,'"','') = b.col1

but either will...