[dba-SQLServer] Optimizing Stored Procedures and Views

Sounds like they replaced your leads as well as the unit itself.  I got
off lightly this time, they just unzipped my chest pocket and clipped in
a new pacer, no need to replace any of the wiring.  I felt pretty seedy
for a week, but you will feel much better with a lot of rest ... And no
early morning/late night programming! LOL 


Charlotte Foust

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of David
Emerson
Sent: Friday, April 07, 2006 2:11 PM
To: dba-sqlserver at databaseadvisors.com; accessd at databaseadvisors.com
Subject: Re: [dba-SQLServer] Optimizing Stored Procedures and Views

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

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com