OK great thanks

Sorry maybe I am not being clear.

If you stop a continuous replication job its last outcome status is cancelled. I want a way for it to have...

Really I want a graceful way to stop the continous distribution job such that the last outcome shows succeeded.

Yes I have raised this but its Microsoft Dynamics AX and without a lot of customisation to the way AX uses X++ to generate the SQL then unfortunately its not...

Sean Pearce (8/5/2014)

---

The Non-clustered Index is performing a seek on LANGUAGEID and PRODUCT and using a predicate to filter on PARTITION.

The Clustered Index is performing a seek on LANGUAGEID, PRODUCT...

Here you go

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[ECORESPRODUCTTRANSLATION](

[DESCRIPTION] [nvarchar](1000) NOT NULL,

[NAME] [nvarchar](60) NOT NULL,

[PRODUCT] [bigint] NOT NULL,

[LANGUAGEID] [nvarchar](7) NOT NULL,

[RECVERSION] [int] NOT NULL,

[PARTITION] [bigint] NOT NULL,

[RECID] [bigint] NOT NULL,

[MODIFIEDBY]...

I see, so you generally get a set of users to simulate some workload and capture that.

Yes that was my point really, I wasn't able to get a decent workload as I collected too much information.

I wondered if collecting workloads should be performed at the...

Hi thanks for that but I was more interested in how people collect their workloads in the first place do people just filter on a particular database over a...

Thanks, I wan't aware of that trace flag. Is there a good list of useful trace flags anywhere?

Ah yes thats sorted it, I was reading this article where it says "Estimatedcost in seconds.." which is what confused me.

http://msdn.microsoft.com/en-us/library/ms190949.aspx

Hopefully catch your session at SQLBits later this...

TheSQLGuru (7/2/2014)

---

Unfortunately for the SQL Saturday (and other conference precons) you have to be there. Some may be able to be downloaded if you pay, but not sure about...

Well I am glad you are talking about things I generally look at when configure a SQL server instance, makes me feel I am on the right track.

In regards your...

Thanks to you both, I didn't know about the Qure tool so will take a look at that, and thanks for pointing me in the right direction.

In regards server level...

Hi Grant

I actually have your book SQl Server 2012 Performance Tuning. The flow of the book seems to be arming the reader with techniques for tuning queries followed by...