New SQL Guy need help

• VladRUS.ca

  SSC Enthusiast

  Points: 127

  More actions

  August 10, 2005 at 11:36 am

  #581129

  This is ODBC Outer Join Escape Sequence http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odbcouter_join_escape_sequence.asp

  change your code like below and try if it works:

  "...FROM

      myDatabase.dbo.tblBudgetPlanningXVYReportType XVYReportType INNER JOIN Mydatabase.dbo.tblBudgetPlanningXVYReportOutput XVY ON

          XVYReportType.xvyrtID = XVY.xvyroRTID WHERE..."

  Best Regards,

  Vlad

• John-79567

  SSCommitted

  Points: 1892

  More actions

  August 10, 2005 at 11:53 am

  #581134

  Removing the odbc outer join escape sequence worked, but didnt improve query performance. I guess i need to find a way to optimize this query or reduce the number of times SQL Server recreates the execution plan.

• VladRUS.ca

  SSC Enthusiast

  Points: 127

  More actions

  August 10, 2005 at 12:19 pm

  #581140

  If you want some tips how to optimize your query, you should post result of this script here.

  set showplan_text on

  go

  SELECT ... (your select)

  go

  set showplan_text off

  go

  OR You can do it yourself. The main point - you should play with indexes.

  All Index Scan in result of showplan_text should be replaced with Index Seek

  Best Regards,

  Vlad