Some one just pointed out to me that smalldatetime has an accuracy of one minute.

Stupid stupid stupid!

quote:

---

In profiler, under events and warning, missing column statistics.

Tom

---

doesn't appear to have any missing...

quote:

---

Have you run a profiler to check for missing column statistics? I have seen query times jump up when column statistics...

Thanks for the input Paul and Gabor.

To answer some of your questions:

1) There are about 12000 rows each in tlnreferences. I restore a back-up of production to the dev environ...

Thanks again Allen. It does not appear to be an issue with parallelism. Here are the plans for each:

SQL QUery:

SELECT distinct r.* 

FROM vw_RefVersionOwner Orig 

INNER...

Thanks Allen ... what exactly do you mean when you say that the query runs in parallel? How do I figure that out by looking at the execution plan?

Thanks,

R.

Thanks for the help folks ...

Ahhhh !!

Thanks Gary.

quote:

---

If you are using the debugger and have the check box to rollbak at the end checked then the following...

Word to the wise!! TURN OFF AUTO_ROLLBACK if you are testing

a transaction with the debugger!! I just turned it off and it

recognised my roll back no problem. I guess...

Thanks guys I'll give that a shot next time I restore the db ... I think that Antares686 is correct there have been changes to the underlying tables, so this...

Thanks everyone for responses ...

I found this at http://www.sql-server-performance.com/transact_sql.asp

"Try to avoid WHERE clauses that are non-sargable. Non-sargable search arguments in the WHERE clause, such as "IS NULL", "OR",...