[dba-SQLServer] Optimizing Stored Procedures and Views

David Emerson newsgrps at dalyn.co.nz
Fri Apr 7 16:11:24 CDT 2006


Dear all,

Thanks for all your suggestions.  I was given 18 hours notice to turn 
up to our hospital for a pacemaker replacement (I wore out the old 
one - too much late night/early morning programming).

Operation successful but I feel as if someone hit my shoulder with a 
sledgehammer (which they well might have done considering the banging 
that was going on during the operation).

Hope to be back on deck next week to follow up the suggestions.

David

At 6/04/2006, you wrote:
>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...
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com




More information about the dba-SQLServer mailing list