Hello all again:

Still struggling with the plan guide, now I can make one and have the query use it WHEN I use SQL Server Management Studio, however when the query...

Hi all again:

Found the problem with creating the PLan Guide as an SQL Statement, it turns out I was missing a whitespace at the beginning and at the end of...

That was my first attempt, here it is:

exec sp_create_plan_guide

@name = N'Plan_Codigo_MIS_250',

@stmt = N'select top 251 contact.FullName as ''fullname'',contact.Telephone1 as ''telephone1'',contact.OwnerId as ''ownerid'',contact.OwnerIdDsc as

''owneriddsc'',contact.OwnerIdName as ''owneridname'',contact.OwnerIdType as ''owneridtype'',contact.OwningTeam as...

When creating the plan guide for an object, the parameter list must be null, I of course have the parameters since this query is sent by the aplication through sp_execsql,...

I'm afraid I don't follow you, if I do the mentioned query using SQLServer Management studio and I include the hint by hand (using option (hash join)), it works fine,...

The template option only allows me to define the form of parametrization, it doesn't allow me to include hints......