Forum Replies Created

Viewing 15 posts - 37,936 through 37,950 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    Anyone want to take a stab at this?

    http://www.sqlservercentral.com/Forums/Topic746075-360-1.aspx

    Converting the while to a select off a (large) tally table's the easy part. The no duplicate values and exact number of returned...

    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

    July 2, 2009 at 9:15 am

    #1019227

  • RE: How to bypass duplicate records ?

    Could you explain in more detail what it is that you're trying to do?

    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

    July 2, 2009 at 9:05 am

    #1019220

  • RE: /3GB Switch

    Jeffrey Williams (7/2/2009)

    MichaelJasson (7/2/2009)

    Microsoft SQL Server 2000 - 8.00.2055 (Intel X86) Dec 16 2008 19:46:53 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows...

    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

    July 2, 2009 at 8:56 am

    #1019215

  • RE: Function Sum

    Table definitions, index definitions and execution plan please.

    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

    July 2, 2009 at 7:46 am

    #1019153

  • RE: Performance Question

    I have a gut-feel that this is not the best approach. What uses these codes and why can a code not be generated when it's needed rather than a few...

    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

    July 2, 2009 at 7:43 am

    #1019151

  • RE: Performance Question

    I can possibly write a set-based alternative, but it's not going to perform much better. The function will still have to be called a couple million times and that's going...

    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

    July 2, 2009 at 7:41 am

    #1019148

  • RE: Delay time in procedure

    Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

    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

    July 2, 2009 at 7:40 am

    #1019146

  • RE: SQL server 2000 to 2005 ? rebuild indexs?

    Update all statistics. With fullscan if possible

    Run CheckDB with the data_purity option

    Set page verify to checksum

    Run DBCC updateusage

    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

    July 2, 2009 at 7:39 am

    #1019145

  • RE: Performance Question

    Can you post the code for that function? Running a function repeatedly in a loop is not the fastest way of doing things, but if I put the function into...

    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

    July 2, 2009 at 7:24 am

    #1019124

  • RE: Performance Question

    What are you trying to achieve here? What is this function supposed to do and why?

    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

    July 2, 2009 at 7:15 am

    #1019114

  • RE: Function Sum

    Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

    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

    July 2, 2009 at 7:12 am

    #1019110

  • RE: problem with indexes and Index Tuning Wizard

    Honestly, I don't trust IDW and I don't use ITW. This is one of the reasons. Some other people have mentioned much the same behaviour with the 2005 DTA. I...

    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

    July 2, 2009 at 7:08 am

    #1019108

  • RE: /3GB Switch

    Is there a question there?

    If you want advice on memory settings, you're going to specify the hardware in that server. Just seeing DBCC memory status alone says very little.

    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

    July 2, 2009 at 6:23 am

    #1019076

  • RE: problem with indexes and Index Tuning Wizard

    Most likely it's because the index isn't covering and there's too many rows returned for an index seek + bookmark lookups to be optimal.

    See - http://sqlinthewild.co.za/index.php/2009/01/09/seek-or-scan/

    If you want 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

    July 2, 2009 at 5:54 am

    #1019059

  • RE: /3GB Switch

    MichaelJasson (7/2/2009)

    Yes this is on Vista. My TL took a decision to have this on Vista and not Microsoft sql server 2008 which we proposed. I was not able to...

    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

    July 2, 2009 at 5:47 am

    #1019053

Viewing 15 posts - 37,936 through 37,950 (of 49,552 total)