Francisco Tapia
fhtapia at gmail.com
Fri Apr 7 16:41:35 CDT 2006
Yikes, This query was tough on you. I hope you get better soon! On 4/7/06, David Emerson <newsgrps at dalyn.co.nz> wrote: > 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 > > -- -Francisco http://pcthis.blogspot.com |PC news with out the jargon! http://sqlthis.blogspot.com | Tsql and More...