Views Vs Stored Procs

Question

Views Vs Stored Procs

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1004339 More actions · Answer 1

CirquedeSQLeil (5/12/2010)
GilaMonster (5/12/2010)
It depends.
p.s. A 5-table query is not exactly complex.
Agreed.

Heh... it depends. 😛

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

SQLRNNR SSC Guru Points: 281334 More actions · Answer 2

Jeff Moden (5/12/2010)
CirquedeSQLeil (5/12/2010)
GilaMonster (5/12/2010)
It depends.
p.s. A 5-table query is not exactly complex.
Agreed.
Heh... it depends. 😛

LOL

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

The Dixie Flatline SSC Guru Points: 53354 More actions · Answer 3

It's highly possible that the interview question was simply designed to draw out your knowledge of views and stored procedures. If I was conducting an interview and asked you that question, I would be evaluating the questions you first asked before you offered an answer.

__________________________________________________

Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills