Post reply

Flush the queries from the RAM

  • April 10, 2008 at 6:02 am

    #800902

    It might. It's worth trying, though there are a lot of possible reasons for recompiles.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • April 10, 2008 at 6:50 am

    #800940

    Ashwin M N (4/10/2008)

    Does the two part naming of a table helps in single Select statement in the application side, because I have lot of Select queries in the application side which is I think not reusing the cache plan stored in the RAM. It is recompiling every time it is executed.

    Absolutely. Make sure, as Gail mentioned, you fully qualify your object names by specifying the schema name.

    AND, since you are currently not using sprocs, but bare SQL statements in your code:

    Make sure you refer to objects (tables, views etc) in your code in the exact case in which they were originally created.

    Mismatched case of objects causes recompiles in SQL batches.

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

Viewing 2 posts - 31 through 31 (of 31 total)

You must be logged in to reply to this topic. Login to reply