Forum Replies Created

Viewing 15 posts - 8,281 through 8,295 (of 49,552 total)

  • RE: Local Variables and BETWEEN clause

    There's nothing about local variables which prevent index usage.

    That 30% is the worst possible case for a guess by the optimiser, not the norm. If it can manage a better...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    August 4, 2014 at 6:46 am

    #1734824

  • RE: Search or data mining in SQL server

    MuhammadShafiq (8/4/2014)

    I am not using data mining here and i do not want to.

    Then why are you asking about all the data mining algorithms? That's what all the algorithms you...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    August 4, 2014 at 6:15 am

    #1734810

  • RE: Search or data mining in SQL server

    Do you understand what data mining is used for? If not, please do a bit of reading on it.

    The question is still too vague to be answerable.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    August 4, 2014 at 6:03 am

    #1734806

  • RE: Are the posted questions getting worse?

    Ed Wagner (8/4/2014)

    GilaMonster (8/4/2014)

    And vague question of the week award goes to: http://www.sqlservercentral.com/Forums/Topic1599205-391-1.aspx

    I want to make my search query faster and accurate.

    DO i need to use any algorithem in SQL?

    So...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    August 4, 2014 at 5:53 am

    #1734801

  • RE: Are the posted questions getting worse?

    And vague question of the week award goes to: http://www.sqlservercentral.com/Forums/Topic1599205-391-1.aspx

    I want to make my search query faster and accurate.

    DO i need to use any algorithem in SQL?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    August 4, 2014 at 5:42 am

    #1734798

  • RE: Search or data mining in SQL server

    That's a pretty vague question. Could you be any more specific?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    August 4, 2014 at 5:41 am

    #1734797

  • RE: Remotely called job returns success even if it's not finished

    EXEC sp_help_job <parameters>

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    August 4, 2014 at 3:44 am

    #1734772

  • RE: Remotely called job returns success even if it's not finished

    You will need something in the next step of your local job to poll/wait in a loop, checking the status of the remote job to see if it's finished.

    sp_start_job does...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    August 4, 2014 at 3:31 am

    #1734768

  • RE: Index and Page Split

    WhiteLotus (8/3/2014)

    GilaMonster (8/3/2014)

    murnilim9 (7/30/2014)

    Moreover , I noticed the PAGE SPLIT/Sec is still high ..around 90 . How do i know which table that cause that page split ?

    That counter is...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    August 3, 2014 at 10:06 am

    #1734693

  • RE: indexing a table having million of records

    raj.prabhu001 (8/3/2014)

    I have a fact table which has six field now and I have created non clustered index on all fields.

    It will also have more fields later with millions of...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    August 3, 2014 at 10:06 am

    #1734692

  • RE: Index and Page Split

    murnilim9 (7/30/2014)

    Moreover , I noticed the PAGE SPLIT/Sec is still high ..around 90 . How do i know which table that cause that page split ?

    That counter is misleading. It...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    August 3, 2014 at 5:56 am

    #1734665

  • RE: Get next primary key without identity

    Eirikur Eiriksson (8/2/2014)

    Jeff Moden (8/2/2014)

    I agree that SEQUENCE has the advantage of being able to cover multiple tables and that IDENTITY requires SET IDENTITY INSERT if you want to update...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    August 2, 2014 at 2:58 pm

    #1734641

  • RE: Trace Updated records

    Also need to keep in mind that CDC is Enterprise Only.

    p.s. Nolock has side effects, it's not a go-faster switch that should be added to every single statement. Let's not...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    August 2, 2014 at 2:25 pm

    #1734635

  • RE: calculate on newly created columns

    WITH Employees AS (

    SELECT

    [LastName] + ',' + [FirstName] AS FullName

    ,HireDate

    ,Title

    ,DepartmentName

    ,BaseRate

    ,VacationHours

    ,SickLeaveHours

    ,ROUND(DATEDIFF(DAY,HireDate,'2014-08-01')/365.25,2) AS EMP_TENURE

    ,(SOME LOGIC OFF OF VACATION DAYS) AS PTO_REMAINING

    FROM [AdventureWorksDW].dbo.DimEmployee

    )

    SELECT

    FullName

    ,HireDate

    ,Title

    ,DepartmentName

    ,BaseRate

    ,VacationHours

    ,SickLeaveHours

    ,EMP_TENURE

    ,PTO_REMAINING

    , (SOME LOGIC INVOLVING 'EMP_TENURE' AND 'PTO_REMAINING') AS BONUS

    , (SOME...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    August 2, 2014 at 12:50 pm

    #1734627

  • RE: Multiple row update query

    Daniel Matthee (8/2/2014)

    Can you please explain then when using an inner select statement (to minimize the sample )on huge table. (+- 20 columns, 400mil rows) the query runs WAY longer...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    August 2, 2014 at 12:36 pm

    #1734623

Viewing 15 posts - 8,281 through 8,295 (of 49,552 total)