No, we are talking about creating an index on a view not using a view's indexes.

Looks like MS has taken a stab at this:

http://msdn2.microsoft.com/en-us/library/ms189786(en-US,SQL.90).aspx

They have a new function: NEWSEQUENTIALID()

It can _only_ be used as the default value for a column in a table...

What you say is true only if you are using NEWID(). If you roll your own GUIDs like the article shows. You have nearly the same performance as...

OK, I got off my butt and did the research :p Here is a great article:

http://www.informit.com/articles/printerfriendly.asp?p=25862

The short of it:

GUIDs as PKs kill performance in large tables and...

Darn, still need Enterprise then. One of the best reasons to use Enterprise imo...

Thank you!

You can only have 8k per row. So, only if all other columns are empty can you have 8k in one varchar. You must always add up the...

Thanks for the links!

Carl,

Do you have a simple example of a Theta-Join?  I cant seem to find one.

Thanks!

Great idea, let’s compare:

1) Project -check!

2) Extend -not on my...

Carl,

Thanks for the try but that’s not what I am looking for.  As that article...

I didn’t know about this tool.  Thank you for making me aware of it!  It is very easy to use.

Ah!  Now we are getting somewhere.  Thanks for the tip!

"I have seen some opposite situations that are just as bad. Companies that rotate their personnel through jobs so fast that no one ever really becomes an "expert" so their...

One more thing I disagree with is your section on uniqueness/specialization:

I have seen bosses that...

Very good article, Steve.  I wish there were a lot more information out there about how to be a good worker and how to be...