Keeping this relatively "simple" and avoiding technical terms, deduplication by applications like CommVault rely largely on the assumption that any two successive versions of a given file have changed minimally,...

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...