Maybe there's another way, but I think the safest way would be to recheck every statement to make sure it returns the correct result (not just this one as something...

Is there any indexes on the live db?

I'm not sure how to change the db settings so I'll let someone else answer this one.

this solution however shows you how to change the setting on the connection

SET ANSI_NULLS...

I'll give this to you but keep in mind that you could break the whole app by changing this setting.. but since it seems to be already the case it...

select * from qrbanca where codabi = '03069'

in this case will return all records (nulls or not)

I might add that citta like '%' filters absolutely nothing (besides nulls in this...

What's the avg run time of the queries?

What are the most ran queries?

How many queries/minute do you run?

Do you have auto-clause or auto-shrink set to on on any production database???

Declare @Input as varchar(25)

set @Input = null

Select case when @Input is null then 'none' else @Input end, isnull(@Input, 'none')

set @Input = '8'

Select case when @Input is null then 'none' else...

This will give you the columns too... but you'll have to filter out the constraint types using the first query I gave you..

Select * from INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE WHERE TABLE_NAME = 'tname'

Select * from INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME = 'Departement'

Select * from INFORMATION_SCHEMA.TABLE_CONSTRAINTS where TABLE_NAME = 'tablename' AND CONSTRAINT_TYPE = 'UNIQUE'

Yes it's the same query... and they'll all most likely end up as clustered index scan (or bookmark lookup).... unless field4 is the primary key of the table.

Update Inventory

set DateColumn = CASE WHEN ISDATE(DateStringColumn) = 1 THEN convert(datetime, DateStringColumn, 101) ELSE NULL END

That's gonna be an interesting answer. Let me get some popcorn and coke before you answer that one .

Ya but nobody loves me... does that mean something?

O'll be sure to get my hands on one of these books. Thanx Nick.