Forum Replies Created

Viewing 15 posts - 1 through 15 (of 311 total)

  • RE: Log Shipping Question

    OK great thanks

  • RE: SQL Agent Job Last Run Outcome

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

  • RE: SQL Agent Job Last Run Outcome

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

  • RE: Query Tuning Index question

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

  • RE: Query Tuning Index question

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

  • RE: Query Tuning Index question

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

  • RE: SQL Trace file sizes

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

  • RE: SQL Trace file sizes

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

  • RE: SQL Trace file sizes

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

  • RE: Index Maintenance and Update Stats

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

  • RE: Cost Threshold for Parallelism

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

  • RE: Performance Tuning Methodology

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

  • RE: Performance Tuning Methodology

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

  • RE: Performance Tuning Methodology

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

  • RE: Performance Tuning Methodology

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

Viewing 15 posts - 1 through 15 (of 311 total)