|
|
|
SSC-Enthusiastic
      
Group: General Forum Members
Last Login: Tuesday, March 26, 2013 11:32 AM
Points: 195,
Visits: 70
|
|
| Comments posted here are about the content posted at temp
|
|
|
|
|
SSC-Enthusiastic
      
Group: General Forum Members
Last Login: 2 days ago @ 9:32 AM
Points: 127,
Visits: 490
|
|
Great Job, You made it so simple and clear. Thanks,
|
|
|
|
|
Forum Newbie
      
Group: General Forum Members
Last Login: Wednesday, June 20, 2007 10:40 AM
Points: 1,
Visits: 1
|
|
|
|
|
|
Valued Member
      
Group: General Forum Members
Last Login: Tuesday, January 15, 2013 12:25 PM
Points: 67,
Visits: 133
|
|
Nice article...very simple and precise.
But, I did not understand the second report...what are P1, P2, P3 columns represent ? Please let me know. thanks, Ranga
|
|
|
|
|
SSC-Enthusiastic
      
Group: General Forum Members
Last Login: Tuesday, March 26, 2013 11:32 AM
Points: 195,
Visits: 70
|
|
P1, P2 and P3 refer to Period1, Period2 and Period3. In a real situation, they could be labelled week1, week2, week3,.....weekN so if you have data collected for 2 years (i.e. 52 * 2 = 104 weeks) you could create a report comparing data across those 104 periods. Normally I do for the last 10 periods. hope I answered your question. If still not clear, please bug me. I will try to be more explanatory. thankz jambu
|
|
|
|
|
SSCrazy
      
Group: General Forum Members
Last Login: 2 days ago @ 2:10 PM
Points: 2,668,
Visits: 688
|
|
very nice! adds more leverage to the power of sql server, and as you say would produce excellent olap cubes. excellent article.
The GrumpyOldDBA www.grumpyolddba.co.uk http://sqlblogcasts.com/blogs/grumpyolddba/
|
|
|
|
|
Valued Member
      
Group: General Forum Members
Last Login: Tuesday, January 15, 2013 12:25 PM
Points: 67,
Visits: 133
|
|
Thanks...You answere my question.
|
|
|
|
|
Forum Newbie
      
Group: General Forum Members
Last Login: Monday, May 21, 2007 9:16 PM
Points: 5,
Visits: 1
|
|
Thanks
Good article. Very clear and easy to understand. I am currently working my way through performance testing and how to get the best out of Performance Monitor. This is a great help to me.
Cheers
|
|
|
|