[dba-SQLServer] Views

One reason is performance.

Another reason is if you recreate a database from
scripts, you have to know the order for views. They
cannot be created if they are based on another view
that does not exist. Sprocs can be created even if
there is a missing dependency on another sproc. They
will also have trouble if they are based on a view
and it does not exist yet when recreating it.

The last reason is lack of parameters in a view.

At 05:12 AM 10/8/2008, you wrote:
>Date: Tue, 7 Oct 2008 14:23:06 -0400
>From: "Susan Harkins" <ssharkins at gmail.com>
>Subject: Re: [dba-SQLServer] Views
>To: "Discussion concerning MS SQL Server"
>         <dba-sqlserver at databaseadvisors.com>
>Message-ID: <162e01c928a9$cd1f3b90$2f8601c7 at SusanOne>
>Content-Type: text/plain; format=flowed; charset="iso-8859-1";
>         reply-type=original
>
>Why?
>
>Susan H.
>
>
> > Where I am at now, we are trying to get rid of all views.
> > We are using stored procedures instead and using derived
> > tables rather heavily.