Viewing 15 posts - 1 through 15 (of 16 total)
Thanks for the CTE recommendation. I will have to try it out and compare performance to the old method.
July 6, 2013 at 12:53 pm
I would love to modify the entire SELECT statement to use an alternative, faster method than the aggregated query in play. I have attached the actual execution plan if anyone...
July 5, 2013 at 9:05 am
Okay, I couldn't help it--I had to post Microsoft's covered index recommendation for the real problem query (see attached image). Below is the query that caused the performance problem. You'll...
July 3, 2013 at 12:56 am
Guys, thanks for the suggestion regarding the covered index. Sorry it took so long to get back to you, but I spent all day (and I mean all day!) on...
July 3, 2013 at 12:34 am
Also, let me re-emphasize that I created a non-unique, non-clustered index for SaleDate, which eliminated the Key Lookup in the execution plan, but peformance is still slow.
July 1, 2013 at 6:33 pm
I'm still trying to make heads and tails out of what covering indexes do. I've got a dozen non-unique, non-clustered indexes in SVSales, including the primary key. The SELECT statement...
July 1, 2013 at 6:32 pm
Okay, I did two things that marginally improved performance.
First, I researched the issue online and saw that "Key Lookups" are bad when it comes to execution plans. I guess...
July 1, 2013 at 6:13 pm
Attached is the actual execution plan. Here are the table definitions, including primary keys and indexes for the five tables used in the problem query. I gave row counts for...
July 1, 2013 at 1:09 pm
I hear what you're saying about not using a cursor. Unfortunately, there are five-thousand lines of code for the dozens of incentive rules in place. We don't have the programming...
June 28, 2013 at 4:55 pm
That sounds good. What I will do is work on the aggregation queries and then post my solution using a sample dataset. Then the community can analyze the solution and...
January 7, 2013 at 11:23 am
Yes, agreed. I have a steep learning curve ahead of me, but it's necessary. Thanks again for your contribution.
January 7, 2013 at 11:09 am
JLS, I tried out your code and it works like a champ! Thank you for taking the time to construct the code. I am very interested in testing it out...
January 7, 2013 at 9:52 am
I will definitely try out your code...thanks.
The reason for insert into ResultHistory is that we process large quantities of sales data from a detail table containing each account opening that...
January 5, 2013 at 8:02 pm
Sean, I'm looking to do a single INSERT statement, similar to the one below. The gist of it is that the outer query needs to insert all the parent group...
January 4, 2013 at 4:39 pm
I read over the article on running totals. However, I'm not looking to produce a running total on a set of transactions. I'm trying to sum child rows into parents...
January 4, 2013 at 3:03 pm
Viewing 15 posts - 1 through 15 (of 16 total)