Great. Thanks for clearing that up for me.

Then which values are best used for comparing queries?

SET STATISTICS IO ON & SET STATISTICS TIME ON?

Using IF statements also seems to generate 1 plan. Is this what you wish...

Thanks for your input guys.

@Grant,

In our case we are using an indexed view only so that we can replicate it to the products table in another database. If...

Hi,

Thanks for the explaination.

So I don't need to worry about a big performance hit?

Just need to remove the extra WHEN THEN ELSEs when tuning so that the results are more...

Thanks Mark !! Works a charm!

Take a look at this : http://support.microsoft.com/kb/960791

Check out the link.

GLENWHILLY

The Meaning of Liff (Douglas Adams, John Lloyd)

http://folk.uio.no/alied/TMoL.html#anchorG

Get yourself a test server running SQL 2008 R2.

Try out all the possible ways of doing this.

Detach / Attach (make a copy if needed), SSIS, backup / restore.

Script the one...

Sorry don't think I can help you. Don't know what this [dbo].[udtYesNo] is about.

What is Task Manager telling you?

Is all your hardware functioning properly?

Check out Gail Shaw's article on finding performance issues.

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

Paul White's blog series will pretty much any question you could ever think of on this.

http://www.sqlservercentral.com/articles/SQL+Server+2008/71019/

Go on then, post the helpful data.

I made the same insightful example.

Found some helpful info to correct my mind set. Also found out you can you unique constraint to reference FKs. Don't know that either. This...

Small and contiguous are considerations for the clustered index. PK != clustered index.

The primary key is a logical database design decision, it is a column or set of columns that...