Forum Replies Created

Viewing 15 posts - 61 through 75 (of 100 total)

  • RE: performance issue

    Grant Fritchey (11/21/2011)

    Lexa (11/20/2011)

    Grant Fritchey (11/20/2011)

    Try getting the execution plan when it's slow and when it's fast. Compare the two. It could be bad parameter sniffing.

    But to be honest,...

    November 21, 2011 at 6:12 am

    #1410642

  • RE: performance issue

    GilaMonster (11/20/2011)

    Lexa (11/19/2011)

    GilaMonster (11/19/2011)

    Is it consistently slow or slow at random times? Slow for specific parameter values and fast for others or slow for all?

    Random times. I caputred a...

    November 20, 2011 at 4:48 pm

    #1410438

  • RE: performance issue

    Grant Fritchey (11/20/2011)

    Try getting the execution plan when it's slow and when it's fast. Compare the two. It could be bad parameter sniffing.

    But to be honest, it sounds like...

    November 20, 2011 at 4:46 pm

    #1410437

  • RE: performance issue

    GilaMonster (11/19/2011)

    Is it consistently slow or slow at random times? Slow for specific parameter values and fast for others or slow for all?

    Random times. I caputred a trace when...

    November 19, 2011 at 5:25 pm

    #1410351

  • RE: Index Maintenance

    GilaMonster (11/16/2011)

    Lexa (11/15/2011)

    Since there is no option to rebuild an index on a specific partition with option ONLINE=ON, would rebuilding index across all partitions but with option ONLINE=ON avoid blocking...

    November 16, 2011 at 5:55 am

    #1408413

  • RE: SSIS with script

    SQLRNNR (11/3/2011)

    Yes you can.

    You would create a data connection to the database inside your script and then insert those records into the table.

    Here is an article on creating such a...

    November 3, 2011 at 7:24 pm

    #1403001

  • RE: CTEs

    Jeff Moden (11/2/2011)

    Lexa (11/2/2011)

    So basically there isn't a situation where CTE will outperform temp table or temp table variable, is that correct?

    No. Didn't say that. As with anything...

    November 2, 2011 at 7:21 am

    #1402123

  • RE: Updating Stats

    So basically you cannot "over" update statistics, right?

    November 2, 2011 at 7:20 am

    #1402121

  • RE: CTEs

    Jeff Moden (11/1/2011)

    Lexa (11/1/2011)

    Folks,

    When are the CTEs used best? Is it true that procs that are called thousands of times a minute and store less than 100K of records...

    November 2, 2011 at 5:38 am

    #1402073

  • RE: Windows Server 2008 service pack 2

    derekr 43208 (10/31/2011)

    Just a question

    Multi-Node??

    2 nodes. Failed over to one, installed SP on the passive. Did the same for the other.

    October 31, 2011 at 8:27 am

    #1401102

  • RE: Windows Server 2008 service pack 2

    derekr 43208 (10/31/2011)

    What is your environment?

    Standalone, Clustered etc....

    Clustered. Pushed the install, everything seems to work just fine.

    October 31, 2011 at 8:19 am

    #1401093

  • RE: Index scan vs. seek

    GilaMonster (10/28/2011)

    I'd like to see the exec plan with the scan please.

    Now that I updated stats, don't seem to have any scans at all... But will post if I see...

    October 28, 2011 at 12:26 pm

    #1400755

  • RE: Index scan vs. seek

    GilaMonster (10/28/2011)

    Lexa (10/28/2011)

    Execution plans is 100% index seek on my_index

    In your initial post you said you had a scan.

    Yep, here is what I posted: "...which time to time gets scanned...

    October 28, 2011 at 11:52 am

    #1400743

  • RE: Index scan vs. seek

    GilaMonster (10/28/2011)

    Can you post the index definition please?

    Can you post the execution plan please?

    CREATE UNIQUE NONCLUSTERED INDEX my_index ON table1

    (

    [f1] ASC,

    [f2] ASC

    )

    INCLUDE ( [f3],

    [f4]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE...

    October 28, 2011 at 9:29 am

    #1400685

  • RE: Index scan vs. seek

    David Moutray (10/27/2011)

    Lexa (10/27/2011)

    Evil Kraig F (10/27/2011)

    Estimated data volume and cost of traversing just the leaf level vs. running the tree repeatedly.

    One example cause: http://sqlskills.com/BLOGS/KIMBERLY/category/The-Tipping-Point.aspx

    I don't think this is...

    October 27, 2011 at 8:37 pm

    #1400477

Viewing 15 posts - 61 through 75 (of 100 total)