Viewing 15 posts - 31 through 45 (of 57 total)
GilaMonster (2/17/2009)
February 17, 2009 at 12:44 am
Oke, the results of the performance test. I tested this on 40.000 items with a difference of 30 days between the start and enddate (so that will be around 1.000.000...
February 9, 2009 at 8:36 am
Ramesh (2/9/2009)I'd better like to see a performance test:)..., And I know if it fares well, you don't mind typing too many case statements...:D
BTW, I was thinking you &...
February 9, 2009 at 7:51 am
The date is relevant because you have to select the sum of the statistics / kpis in a certain timerange.
Date is of type smalldatetime and contains just the datepart
February 9, 2009 at 7:21 am
Ramesh (2/9/2009)
February 9, 2009 at 7:00 am
I think i have found the best solution:
SELECT Item.Name
, stat.Stat1
, stat.Stat2
, stat.Stat3
, kpi.kpi1
, kpi.kpi2
, kpi.kpi3
FROM Items
LEFT JOIN (
SELECT
IDItem
, SUM(Statistics.stat1) stat1
, SUM(Statistics.stat2) stat2
, SUM(Statistics.stat3) stat3
FROM Statistics
WHERE statistics.Date BETWEEN '2009-01-01' AND...
February 9, 2009 at 2:39 am
Vijaya Kadiyala (2/2/2009)
Check out the below link
http://www.odetocode.com/Articles/70.aspx
Thanks -- Vj
http://dotnetvj.blogspot.com[/quote%5D
Thanx, this is a nice start for them 🙂
@ the others: thanx for your responce. Ofcourse i already...
February 2, 2009 at 11:47 pm
Fernando (11/14/2008)
November 14, 2008 at 10:42 am
Jeff Moden (11/14/2008)
When you guys made the "new" TempDB, did you make sure it was still set to the "Simple" recovery mode?
moving the TempDB files is as simple as altering...
November 14, 2008 at 12:17 am
winash (11/13/2008)
November 13, 2008 at 11:42 pm
free_mascot (11/13/2008)
Have you checked DBCC OPENTRAN ? What is...
November 13, 2008 at 5:44 am
free_mascot (11/13/2008)
Try to findout more detail about the processes running on the Tempdb. Find out any open transactions are there or not in Tempdb?
But in that case you are asuming...
November 13, 2008 at 5:22 am
Madhivanan (11/3/2008)
http://sql-server-performance.com/Community/forums/p/28631/152790.aspx
Damn, more simple and better than mine.... i have to stop thinking the hard way 😛
November 3, 2008 at 6:01 am
You don't want to group by Overflow, because in that case you get a result per overflow (1 result voor overflow=0 and 1 for overflow=1). But you can't simply leave...
November 3, 2008 at 5:42 am
Wandrag (10/23/2008)
Rather create the clustered index on the ID field, and a non-clustered index on (IDItem,Date).
You can re-organize the non-clustered index online daily...
October 23, 2008 at 5:48 am
Viewing 15 posts - 31 through 45 (of 57 total)