Take a look at 'Maximum Capacity Specifications' in BOL.

In BOL one can read

Transact-SQL Joins

In earlier versions of Microsoft® SQL Server™ 2000, left and right outer join conditions were specified in the WHERE clause using the *= and...

Is it just me or did the original questioner remove his question?

I see a blank message

What is DB3?

Take a look at the TEXT datatype in BOL.

I stand corrected!

You're right, still I think it's a waste.

I'll bet SQL Server will almost always favor the clustered index, because the leaf level actually contains the data not a pointer to the data. If you query only for...

Yes, enjoy your weekend, too! I'm going home now.

Hey Dave,

what a cheap shot to increase your post count!

Btw, why don't you have it. Aren't you both Swedish and MVPs?

You're soo kind, Kenneth

To add to Kenneth (and maybe posted by me for the 1000th time) this one is VERY interesting

http://www.sommarskog.se/dynamic_sql.html

Cross post!

See http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=23&messageid=111549

Cross post!

See http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=23&messageid=111549

Do this homework by yourself!

Take a look at DATEDIFF in BOL and see if you can find out yourself and avoid these annoying cross posts!

http://search.microsoft.com/search/results.aspx?st=b&na=88&View=en-us&qu=vldb

http://www.microsoft.com/sql/techinfo/administration/2000/scalability.asp

might be a starting point.

Apart for this I would buy some external knowledge in form of a consultant with proven experience in planning, design and implementation of such...