[dba-SQLServer] Optimizing Stored Procedures and Views

If this is a very busy table you can generally use table hints to
prevent locking the table, and is generally very fast, simplay add a
WITH(NOLOCK) at the end of your table names (not variable tables).


On 4/5/06, David Lewis <DavidL at sierranevada.com> wrote:
> Well, there is a lot there to begin to look through...
>
> One thing that sticks out is the
>
> "SELECT TOP 100 PERCENT"   in the underlying view.  Remove that and the
> "ORDER BY" clause and you will do much to streamline the execution of
> the view.  Also consider making as many of the queries covered as
> possible by either adding indexes or removing columns from the views
> that are not needed in the final query.
>
> I am not very experienced with streamline execution plans by optimizing
> joins, but I do try to read what comes my way and I have read that all
> joins are NOT created equal.  Because your joins are relatively complex,
> it may be that there is much to do in that area.  When I find a good
> reference I will pass it on...
>
> D. Lewis
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>


--
-Francisco
http://pcthis.blogspot.com |PC news with out the jargon!
http://sqlthis.blogspot.com | Tsql and More...