I'd go this route.

Look for the current plan for this query using this code, run in the context of the relevant database.

USE Your_DB

go

DECLARE @Omit varchar(30)

SET @Omit = 'Ignore this result'

SET...

I've just noticed that in my version I sent there is an extra space after the last "DESC"

Leo

Your 2nd statement has the correct format. You have to have the parameter list separate from the T-SQL Query. I have compared this to one I've created recently that I...

OK, so the 2nd statement does create the Plan Guide. This makes sense because the create statement is correct.

Have you checked that your @stmt is identical to the incoming query?...

jean_chr_thiel (11/22/2016)

---

I have the following SQL generated by a third party application that is using a wrong index and create undue parallelisation.

I tried to create a plan guide without success.

It...

As I understand your first option you had 3 Entities (A, B, C) and a single link table, but you didn't define any table schemas.

Lets assume each entity has a...

Just be careful with how/where the 1000 page count is checked. I've reviewed a few automated optimisation routines, and a lot of them check the page count at the index...

moranamon (9/21/2016)

---

it seems that the following are the ideal options:

1. To hold a link table ("LINK_TBL") between the entities and Photos table, as follows:

A OTO LINK_TBL OTM Photos.

Each entity will...

And it gets more and more complicated as storage becomes more advanced.

If the vendor is managing tearing/placement of the files on a drive level, then having all the files on...

Criticism of poor code and old people aside, the only way to know what table is being referenced is to run a trace (Profiler or background) to capture the incoming...

In simple terms the Synchronous commits are taking too long, i.e. over 3000ms. This will probably also be seen as degraded performance for your users/application.

Check the latency between the servers....

I've been doing some testing and I can show that an @timeout argument = -1 causes the stored proc to wait until any existing locks with the same name are...

Having said all that, I might be missing it, but I don't see in the Aaron Bertrand article you reference where he suggests generally setting MAXDOP=1. It's listed by MS...

I've tested your code and it works without returning the overflow error. Are you sure the error is in this line? Could you post more of the code?

Minor correction to...

I looked at the table variable row estimation as a possible issue, and by default the table variable estimates 1 row, but it returns 145. I would expect this to...