Home Forums SQL Server 2005 SQL Server 2005 Performance Tuning its very urgent !! How to Improving Performance or Query Tuning of SQLView with Select Command,Please help me on this issue RE: its very urgent !! How to Improving Performance or Query Tuning of SQLView with Select Command,Please help me on this issue

  • Read the following article to know what is needed for performance problems:

    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

    Your view uses functions on your joins. Remove them as they're not useful at all as demonstrated in the following query.

    SELECT 1

    WHERE 'a' = 'a '

    Why are you converting your date columns? Aren't they some kind of date/time data type?

    Are you aware on what the NOLOCK hint does? Are your users aware that they can get inconsistent results? Are they fine with that? Do you know that it's not a go-fast option?

    http://blogs.msdn.com/b/davidlean/archive/2009/04/06/sql-server-nolock-hint-other-poor-ideas.aspx

    http://www.jasonstrate.com/2012/06/the-side-effect-of-nolock/

    http://sqlblogcasts.com/blogs/tonyrogerson/archive/2006/11/10/1280.aspx

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2