Forum Replies Created

Viewing 15 posts - 22,921 through 22,935 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    Jeff Moden (10/16/2011)

    GilaMonster (10/15/2011)

    Jeff Moden (10/15/2011)

    Heh... nah... you're a good friend... so I thawed the chops for ya. 😛

    And even de-boned and par-cooked em to be really nice.

    That was just...

    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

    October 16, 2011 at 1:36 pm

    #1395090

  • RE: Inserting into large table in SQL SERVER 2008

    You should always be on the latest service pack, but, best practices aside, it's unlikely to be the cause of the problem. Production has extra load, lots of users.

    I've asked...

    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

    October 16, 2011 at 12:41 pm

    #1395085

  • RE: Inserting into large table in SQL SERVER 2008

    GilaMonster (10/16/2011)

    Aspet Golestanian Namagerdi (10/16/2011)

    All the sql statments in SP runs very fast(0 ms).In SP I have two insert statment that these two also run fast ,but sometimes after their...

    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

    October 16, 2011 at 9:48 am

    #1395073

  • RE: Are the posted questions getting worse?

    MysteryJimbo (10/16/2011)

    GilaMonster (10/16/2011)

    MysteryJimbo (10/16/2011)

    GilaMonster (10/16/2011)

    Oh, nice.... After pointing out that performance is not the main reason for partitioning.

    GilaMonster...Really I wonder from your comments ..!!!!!!

    Please read more about schema partitioning +...

    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

    October 16, 2011 at 9:43 am

    #1395072

  • RE: Inserting into large table in SQL SERVER 2008

    Aspet Golestanian Namagerdi (10/16/2011)

    All the sql statments in SP runs very fast(0 ms).In SP I have two insert statment that these two also run fast ,but sometimes after their execution...

    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

    October 16, 2011 at 9:05 am

    #1395070

  • RE: simple one table query

    Performace Guard (Shehap) (10/16/2011)

    So if you intend to use TVF , you will get much table scan resulted by TVF where no index could be there at all >>>leading 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

    October 16, 2011 at 8:57 am

    #1395069

  • RE: Are the posted questions getting worse?

    Grant Fritchey (10/16/2011)

    GilaMonster (10/14/2011)

    You have GOT to watch this: http://www.youtube.com/watch?v=xC1DIf5hcVw

    WHOOP! SQL Chuck Norris makes an appearance... and then some goofball sings about reading plans in the wrong direction.

    😀

    I had a...

    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

    October 16, 2011 at 8:54 am

    #1395067

  • RE: Are the posted questions getting worse?

    MysteryJimbo (10/16/2011)

    GilaMonster (10/16/2011)

    Oh, nice.... After pointing out that performance is not the main reason for partitioning.

    GilaMonster...Really I wonder from your comments ..!!!!!!

    Please read more about schema partitioning + SQL Alerts+...

    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

    October 16, 2011 at 8:51 am

    #1395066

  • RE: Are the posted questions getting worse?

    Oh, nice.... After pointing out that performance is not the main reason for partitioning.

    GilaMonster...Really I wonder from your comments ..!!!!!!

    Please read more about schema partitioning + SQL Alerts+ benefits 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

    October 16, 2011 at 8:48 am

    #1395064

  • RE: Logical Error in the Proc involving Nested Cursor

    You can't put expressions as a parameter to a procedure. It has to be a literal or a variable only. So the call to sp_executesql must be just @Query. Hence...

    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

    October 16, 2011 at 12:43 am

    #1395042

  • RE: Inserting into large table in SQL SERVER 2008

    Aspet Golestanian Namagerdi (10/13/2011)

    Is there any other possible solution for this problem?

    Maybe, but the first thing we need to do is identify a cause.

    Can you post an execution plan 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

    October 16, 2011 at 12:37 am

    #1395041

  • RE: Are the posted questions getting worse?

    I've been reading over the threads for the last week. Posted questions getting worse, no. Posted answers, yes (and I'm not referring to anyone who posts here)

    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

    October 16, 2011 at 12:36 am

    #1395040

  • RE: Inserting into large table in SQL SERVER 2008

    Performace Guard (Shehap) (10/15/2011)

    5.Implement a schema partitioning on an appropriate field (Much preferred to be PK not to lose storage aligned concept of partitioning )

    Partitioning is Enterprise only, and...

    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

    October 16, 2011 at 12:34 am

    #1395039

  • RE: Are the posted questions getting worse?

    Jeff Moden (10/15/2011)

    Heh... nah... you're a good friend... so I thawed the chops for ya. 😛

    And even de-boned and par-cooked em to be really nice.

    That was just for the 'if...

    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

    October 15, 2011 at 11:22 pm

    #1395036

  • RE: what is poly performance on a sql statement

    Never heard of the word 'poly' used with SQL queries. Where did you hear it and in what context.

    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

    October 15, 2011 at 6:10 pm

    #1395014

Viewing 15 posts - 22,921 through 22,935 (of 49,552 total)