Forum Replies Created

Viewing 9 posts - 1 through 9 (of 9 total)

  • RE: Query Help

    Thanks Jeffrey Williams that solution worked out great.

  • RE: Query Help

    The companies are allowed up to 3 coupons, So 3 titles.

    Im going to try the method posted above and let you know the results.

  • RE: Performance help

    Thanks. I did not notice that.

    That column is not even being used in the source code or even being returned by the main query to begin with ,so its been...

  • RE: Performance help

    Thank you very much!

    I could not get what you gave me to work exactly as it is, but the execution time is now 2.437 seconds on average vs 5.966 seconds.

    This...

  • RE: Performance help

    The function runs very fast.

    It returns all categories that are under the parent category.

    In the case of category 42 - it returns 965 subcategories , sub-sub categories and so...

  • RE: Performance help

    Auto Update for stats are turned on.

    I updated the stats on all tables using this script

    http://www.sqlservercentral.com/scripts/Index+Management/31823/

    but the estimated rows are still the same.

  • RE: Performance help

    changing that into a inner join produces the same execution plan

  • RE: Performance help

    I'm not sure how to get that information. I create all my indexes in SQL Management Studios table designer.

    I think your on to something. I removed it completely from the...

  • RE: Performance help

    The clustered index seek in the execution plan refers to these 2 lines in the sql below

    "AND (dbo.CSK_Store_Product.statusID <> 99)

    AND (dbo.CSK_Store_Product.isDeleted = 0)"

    SELECT

    ProductList.productID,

    ProductList.sku,

    ProductList.productName,

    ProductList.shortDescription,

    ProductList.manufacturerID,

    ProductList.statusID,

    ProductList.productTypeID,...

Viewing 9 posts - 1 through 9 (of 9 total)