In the plan xml there are only the first ~6000 characters of the statement.

The Navision querries can be very long. So the interresting parts are missing (same in deadlock graphs...

What I can't understand is why they made NAV adding hints to every query.

In the past they had some querries suffer from parameter sniffing. And when OPTIMIZE FOR UNKONOWN came...

Can I also see wich query hints were used?

The query comes in with OPTIMIZE FOR UNKNOWN and FETCH 50, and the plan guide "adds" RECOMPILE.

Because I see parameter sniffing happening...

With plan guides just including a recompile hint the querries work pretty fast with only a few reads.

The like operator is now be evaluated as a seek predicate.

I'm wondering what...

Thanks Kevin,

they use the < filter for paging (that's at least what I think). They use TOP 50 with a filter on the primary key to get the data...

I tried it the way MysteryJimbo described. But the copy job didn't copy the backups. If I copy them manually, the restore job didn't restore them. The jobs don't create...

Thanks, Pablo.

Yes, the columns are defined in bytes.

We changed them to charaters and it works.

But I don't understand why 🙂

We read from varchar2(50 bytes) and insert into varchar2(50 bytes),...

I use...

Thanks for your feedback.

Is your system restarted often? dm_db_index_usage_stats is reset each time the server restarts so I would guess it's just how the data is used. i.e. everytime the...

If I run the query from ssms the actual execution plan shows a remote query with actual number of rows = 1.

If i run the query against the above mentoined...

Hi,

thanks to all for answering.

Is there a logon trigger per database instance? I guees not, but I would like to limit the connections only per database, not per server.

So every...

Thanks for your feedback.

I run transaction log backups every hour. At 07pm (so 11 hours later) another mp starts, wich backups the whole database and updates the statistics (okay, not...