I'd recommend that, whatever you do, you do NOT use "Set Transaction Isolation Level" in updatable views... don't know when it will happen but you will eventually run across an...

I'm pretty sure that you cannot pass an array... guess that leaves a CSV parameter...

If you don't have very many parameters in the "list", why not pass them as individual...

Unless it is a homework problem, I see no practical reason to index the view... the underlying indexes of the tables will inherently be used during normal view resolution. 

Strangely enough, you'll usually find a direct correlation between poor performance code and deadlocks and, with the exception of not allocating enough memory, hardware is not usually the problem nor...

It's apparent, now, the interviewer was asking the interviewee to think outside the box.  The original poster didn't explain it was an interview question until after I asked "why".  For...

I have an SQL Server based IVR at work (actually, 400 miles away from the main DB)... it uses a linked server connection with multiple pass through views as you...

Got it!  Thanks for the feedback, Susan.

You bet, Kevin.  Thank you and Niles for the feedback...

Kevin, could you tell us the actions you took?  Bet, lot's of folks would like to hear what the lickiest guy...

Thanks for looking, John.  If I find anything from Microsoft, I'll be sure to post it.

One other BIG thing to consider before you delete anything... do you have a permanent backup of the data you are about to delete?  One of the 10 commandments for...

Sorry about the confusion on the owners... I'm used to folks putting everything into production as "dbo".  Yes, the views you speak of would certainly and easily solve that problem...

Yep... I concur with PW... "Create or Replace" is definitely Oracle code and the string functions available are quite different in SQL Server.

So, which do you need, Oracle Code or...

Oh, yeah... almost forgot... you can get a list of available collations using the following code...

SELECT *

FROM ::fn_helpcollations()

Yes...

My recommendation (for U.S. installations) is to select a collation that is Dictionary Order, Case Insensitive (CI) and Accent Sensitive (AS).  This will normally be done during installtion of the server...

It's in Books Online under [Create Index] but here's a quick example for what you want to do...

CREATE UNIQUE  NONCLUSTERED INDEX index_name

    ON tablename (columnlist)