Viewing 15 posts - 1,381 through 1,395 (of 5,502 total)
Since the CTE still contains the join to the views I wouldn't expect a major improvement.
As I stated before, one of the methods to improve the performance of such kind...
June 23, 2011 at 1:03 pm
I strongly vote against just the shrinking of tempdb.
Tempdb didn't expand to that size without a reason. And, as long as the reason has not been found and taken care...
June 23, 2011 at 12:58 pm
Here's what I would do:
Step 1: extract the columns belonging together (e.g. [LN 00005_RcvCo] and [LN 00005 CtrlStnFlag]) into a separate table with just the primary key of the original...
June 23, 2011 at 10:48 am
A view (assuming it's not an indexed view) usually just holds the definition of the query.
When referencing such a view in another query, SQL Server will use the underlying definition...
June 22, 2011 at 3:49 pm
without seeing the actual execution plan it's almost impossible to tune it any further. Especially since there seem to be views involved (vw_categoryColsQuestionLORAll vw_surveyCategoryHierarchyFlat). Those views might contain code that's...
June 22, 2011 at 3:16 pm
Steve Jones - SSC Editor (6/22/2011)
ALZDBA (6/22/2011)
Steve Jones - SSC Editor (6/21/2011)
June 22, 2011 at 2:08 pm
Following opc.three's line of thought:
Why don't you populate the "flag" together with the running total calculation?
Since the "flag" value depends on the previous "flag" value, it's just another running total...
June 22, 2011 at 1:08 pm
Please read and follow the advice given in the first article referenced in my signature on how to post SQL code questions.
We'll need table def and sample data ina ready...
June 22, 2011 at 11:59 am
You might consider having a look at the related link in my signature (strong hint: the name is related to perform a "Cross Tab" task)...
June 22, 2011 at 11:49 am
There might be a confusion between indexed views and "ordered" views.
In SS2K it's possible to control the order of the rows returned via ORDER BY in the view definition.
SS2K8 will...
June 21, 2011 at 5:29 am
To be as precise as the question is: most probably an issue with the query. 😉
If you decide to post a more detailed question you might get a more detailed...
June 20, 2011 at 1:09 pm
As you might have noticed, this is a MS SQL Server forum.
Maybe you'll find better answers on a Oracle forum... 😉
June 20, 2011 at 1:07 pm
Here's an alternative that should "slightly" outperform the previous solution...
It's the rather classic CrossTab approach (see the link in my signature for details).
;WITH cte AS
(
...
June 20, 2011 at 1:04 pm
UNPIVOT the data to get one row per project and rep, join it to the User table to assign the display name and either use PIVOT or the CrossTab method.
If...
June 18, 2011 at 6:09 am
Very interesting article. Thank you for providing the info.
At the place I work we've had a virtualization discussion recently with the (outsourced) hardware team. They presented a concept to reduce...
June 17, 2011 at 9:46 am
Viewing 15 posts - 1,381 through 1,395 (of 5,502 total)