In that case, just wrap your columns that potentially have NULLs in them with ISNULL(column, 0). In the case you gave, you could do this:

SELECT [Emp_no.], Org_Code, Org_Num FROM #Employee

EXCEPT...

Thanks for the responses guys. I tried out the DBCC FREEPROCCACHE with the plan handle and it works just fine with a read-only DB, so I'll use that while working...

Looks like I'm using the same collation as you. I checked and the database, table and column are all using SQL_Latin1_General_CP1_CI_AS collation.

Like I said though, there are several other...

Strange. It actually turns out, that just putting the OPTION(Recompile) at the bottom of the query without the casts also works. I've tried this on other tables (both...

Thanks for taking the time to reply Scott. Attached is the query plan from my smaller test copy of the database (there's only a couple million rows in the...

I think the problem is that because of the conversion, it has to go through the whole index to find that there is in fact no value that = 0...

If I'm understanding what you want, you might try doing a CTE:

;WITH IDRank AS (

SELECT t.Name,

t.ID,...

Thanks! It took me a sec to figure out what you were doing (it's Monday morning) but it's exactly what I needed. ...

Profiler or Extended Events? We're running...

Also, I verified that there is no shrinking occurring on the database. Like Jeff said, if shrinking was happening, the fragmentation would go way up and it would happen...

I had set up a job previously that captures the...

I think what everyone is saying is try not to reinvent the wheel with your own specific jobs. Ola's maintenance scripts work really well, are configurable and are updated...

So, back to my original topic. After getting a little bit of time today to do some testing of the various things that have been suggested, here's what I...

First of all, thanks for the responses. I don't think SQL Injection is a big problem given that the only time this procedure is called is by an application...