Thanks!

Thanks, do you use BI - SSIS, SSRS in those boxes?

From what I read, it seems they carry over all the features, it won't lose any features if still using...

Thanks, I thought this forum may have already some dba upgraded previous standard version which they use ssis, ssrs, now upgraded to standard 2012. They may have experience about it...

SQL Kiwi (8/22/2012)

---

sqlfriends (8/22/2012)

---

Because I have quite a few <> comparisons in my sql, ( in my post it is just a part of them), if I write something like...

Ok. thanks.

If I simplize my question, any alternative to use <> to compare columns with null values?

Thanks, so I still cannot get a better improved solution?

I think Greg meant not sargable is because I use Isnull function on the left of the comparison.

I would like my query to be sargable.

So what other good...

Because I have quite a few <> comparisons in my sql, ( in my post it is just a part of them), if I write something like :

...

Thanks, I don't mean I will do it quite often. I will certainly make it correctly at the first place.

It just happens sometimes.

So I guess it is better not to...

Did you try to restore it? That will give you your answer... HINT: Can you restore a backup from 1 instance to a different one even though the backupset name...

It turns out everything works fine.

We did a DBCC check on each database, there is no error.

So not sure what happened.

Thanks,

Thanks a lot. I will check into it.

yes, I figured out that...