Jim Lawrence
jlawrenc1 at shaw.ca
Fri Apr 7 22:08:31 CDT 2006
David: It hard when you live a double life; same person just work twice as long as most. I am glad to hear your operation was a success. Jim -----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