Graphing Database Growth Rate

Hello, all -- I have a job that grabs the size of each SQL Server database
and log file size and saves one row per database into a table. I run this
routine on a daily basis, so I basically grab the size each day and can
monitor growth.

The table data is below.

What I would like to do is have a SQL Query setup to graph the data in Excel
to show the growth rate of each database by week, month, year.

I'm not sure the best way to do the SQL and the best way to do the graph.
Since new databases are created all the time, new rows will appear in the
output -- so creating specific graphs for each database may not be ideal...
so I'm hoping someone could help me.

Essentially, I want a graph of:

By Week -All Databases (DB274, DB332, DB344, etc) showing the start size and
the end size within a specified period.
By Month - All Databases (DB274, DB332, DB344, etc) showing the start size
and the end size within a specified period.
By Year - All Databases (DB274, DB332, DB344, etc) showing the start size
and the end size within a specified period.

I woudl then like to graph each database individually showing its individual
growt as:
By Week - DB274
By Month - DB274
By Year - DB274

Then again another by Week, Month, Year for each remaining database.

I figure I'll need a separate query for the Week, Month, Year for all
databases. Then separate queries for the Week, Month, Year for each
individual database.

How to have this in Excel for graphing is another big question for me.
Obviously, as new databases come on... I do not want to have to remember and
add/create a new graph. (If this is required, fine... I'm just trying to
find a dynamic solution here.)

Here is all my data that I've been collecting each data starting 12/17/04
thru 02/01/05.

Any help or pointers would be appreciated greatly.

ID RECORD_TYPE DBNAME
DATA_SIZE DATA_USED LOG_SIZE LOG_USED STAT_DATE
----------- ----------- -------------------------------------------------- -----------
----------- ----------- ----------- ------------------------------------------------------
2 1 DB274
15670.00 15517.00 3.49 .40 2005-01-17 13:59:10.477
36 1 DB274
15670.00 15518.00 .99 .62 2005-01-18 08:00:11.637
70 1 DB274
15670.00 15518.00 .99 .57 2005-01-19 08:00:09.123
104 1 DB274
15670.00 15518.00 .99 .70 2005-01-20 08:00:09.873
138 1 DB274
15670.00 15519.00 .99 .60 2005-01-21 08:00:10.237
172 1 DB274
15670.00 15520.00 .99 .57 2005-01-22 08:00:11.680
206 1 DB274
15670.00 15519.00 10.99 .71 2005-01-23 08:00:15.493
240 1 DB274
15670.00 15519.00 5.99 .59 2005-01-24 08:00:10.137
274 1 DB274
15670.00 15520.00 3.49 .79 2005-01-25 08:00:09.380
308 1 DB274
15670.00 15522.00 3.49 .60 2005-01-27 08:00:10.640
342 1 DB274
15670.00 15523.00 3.49 .90 2005-01-28 08:00:11.520
376 1 DB274
15670.00 15524.00 3.49 .59 2005-01-29 08:00:14.120
411 1 DB274
15670.00 15523.00 5.99 .47 2005-01-30 08:00:10.823
446 1 DB274
15670.00 15523.00 5.99 .79 2005-01-31 08:00:09.457
481 1 DB274
15720.00 15692.00 3.49 .53 2005-02-01 08:00:07.140
3 1 DB332
828.00 727.00 .99 .43 2005-01-17 13:59:10.477
37 1 DB332
828.00 728.00 .99 .55 2005-01-18 08:00:11.637
71 1 DB332
828.00 730.00 .99 .68 2005-01-19 08:00:09.123
105 1 DB332
828.00 732.00 .99 .65 2005-01-20 08:00:09.873
139 1 DB332
828.00 733.00 .99 .58 2005-01-21 08:00:10.237
173 1 DB332
828.00 734.00 .99 .59 2005-01-22 08:00:11.680
207 1 DB332
828.00 733.00 3.99 .54 2005-01-23 08:00:15.493
241 1 DB332
828.00 734.00 1.99 .41 2005-01-24 08:00:10.137
275 1 DB332
828.00 736.00 1.99 .62 2005-01-25 08:00:09.380
309 1 DB332
828.00 741.00 1.99 .42 2005-01-27 08:00:10.640
343 1 DB332
828.00 745.00 1.99 .68 2005-01-28 08:00:11.520
377 1 DB332
828.00 754.00 1.99 1.34 2005-01-29 08:00:14.120
412 1 DB332
878.00 746.00 3.99 .54 2005-01-30 08:00:10.823
447 1 DB332
878.00 747.00 2.99 1.10 2005-01-31 08:00:09.457
482 1 DB332
878.00 752.00 1.99 .59 2005-02-01 08:00:07.140
4 1 DB344
27.00 20.00 .99 .52 2005-01-17 13:59:10.477
38 1 DB344
27.00 20.00 .99 .58 2005-01-18 08:00:11.637
72 1 DB344
27.00 21.00 .99 .68 2005-01-19 08:00:09.123
106 1 DB344
27.00 21.00 .99 .65 2005-01-20 08:00:09.873
140 1 DB344
27.00 22.00 .99 .53 2005-01-21 08:00:10.237
174 1 DB344
27.00 22.00 .99 .60 2005-01-22 08:00:11.680
208 1 DB344
27.00 22.00 .99 .66 2005-01-23 08:00:15.493
242 1 DB344
27.00 22.00 .99 .56 2005-01-24 08:00:10.137
276 1 DB344
27.00 23.00 .99 .54 2005-01-25 08:00:09.380
310 1 DB344
27.00 24.00 .99 .58 2005-01-27 08:00:10.640
344 1 DB344
27.00 25.00 .99 .56 2005-01-28 08:00:11.520
378 1 DB344
27.00 26.00 .99 .63 2005-01-29 08:00:14.120
413 1 DB344
77.00 26.00 .99 .61 2005-01-30 08:00:10.823
448 1 DB344
34.00 26.00 .99 .63 2005-01-31 08:00:09.457
483 1 DB344
34.00 32.00 .99 .59 2005-02-01 08:00:07.140
5 1 DB347
1303.00 1127.00 5.99 .47 2005-01-17 13:59:10.477
39 1 DB347
1303.00 1127.00 .99 .55 2005-01-18 08:00:11.637
73 1 DB347
1303.00 1128.00 .99 .69 2005-01-19 08:00:09.123
107 1 DB347
1303.00 1129.00 .99 .63 2005-01-20 08:00:09.873
141 1 DB347
1303.00 1130.00 .99 .67 2005-01-21 08:00:10.237
175 1 DB347
1303.00 1131.00 .99 .66 2005-01-22 08:00:11.680
209 1 DB347
1303.00 1130.00 5.99 .47 2005-01-23 08:00:15.493
243 1 DB347
1303.00 1131.00 5.99 .53 2005-01-24 08:00:10.137
277 1 DB347
1303.00 1132.00 .99 .52 2005-01-25 08:00:09.380
311 1 DB347
1303.00 1134.00 .99 .56 2005-01-27 08:00:10.640
345 1 DB347
1303.00 1135.00 .99 .63 2005-01-28 08:00:11.520
379 1 DB347
1303.00 1136.00 .99 .55 2005-01-29 08:00:14.120
414 1 DB347
1303.00 1135.00 5.99 .47 2005-01-30 08:00:10.823
449 1 DB347
1303.00 1135.00 5.99 .64 2005-01-31 08:00:09.457
484 1 DB347
1303.00 1144.00 .99 .57 2005-02-01 08:00:07.140
6 1 DB358
369.00 312.00 5.99 .47 2005-01-17 13:59:10.477
40 1 DB358
369.00 312.00 .99 .51 2005-01-18 08:00:11.637
74 1 DB358
369.00 313.00 .99 .60 2005-01-19 08:00:09.123
108 1 DB358
369.00 313.00 .99 .68 2005-01-20 08:00:09.873
142 1 DB358
369.00 314.00 .99 .56 2005-01-21 08:00:10.237
176 1 DB358
369.00 314.00 .99 .54 2005-01-22 08:00:11.680
210 1 DB358
369.00 314.00 5.99 .47 2005-01-23 08:00:15.493
244 1 DB358
369.00 314.00 5.99 .66 2005-01-24 08:00:10.137
278 1 DB358
369.00 315.00 3.49 1.47 2005-01-25 08:00:09.380
312 1 DB358
369.00 316.00 3.49 .79 2005-01-27 08:00:10.640
346 1 DB358
369.00 316.00 3.49 1.64 2005-01-28 08:00:11.520
380 1 DB358
369.00 316.00 3.49 1.80 2005-01-29 08:00:14.120
415 1 DB358
369.00 316.00 3.49 1.76 2005-01-30 08:00:10.823
450 1 DB358
369.00 316.00 .99 .65 2005-01-31 08:00:09.457
485 1 DB358
369.00 317.00 .99 .54 2005-02-01 08:00:07.140
7 1 DB377
881.00 777.00 5.99 .47 2005-01-17 13:59:10.477
41 1 DB377
881.00 777.00 .99 .52 2005-01-18 08:00:11.637
75 1 DB377
881.00 778.00 .99 .67 2005-01-19 08:00:09.123
109 1 DB377
881.00 779.00 .99 .50 2005-01-20 08:00:09.873
143 1 DB377
881.00 779.00 .99 .53 2005-01-21 08:00:10.237
177 1 DB377
881.00 780.00 .99 .57 2005-01-22 08:00:11.680
211 1 DB377
881.00 779.00 5.99 .47 2005-01-23 08:00:15.493
245 1 DB377
881.00 779.00 5.99 .68 2005-01-24 08:00:10.137
279 1 DB377
881.00 780.00 3.49 2.66 2005-01-25 08:00:09.380
313 1 DB377
881.00 783.00 .99 .55 2005-01-27 08:00:10.640
347 1 DB377
881.00 784.00 .99 .70 2005-01-28 08:00:11.520
381 1 DB377
881.00 784.00 .99 .54 2005-01-29 08:00:14.120
416 1 DB377
881.00 784.00 5.99 .47 2005-01-30 08:00:10.823
451 1 DB377
881.00 784.00 5.99 .58 2005-01-31 08:00:09.457
486 1 DB377
881.00 785.00 5.99 1.60 2005-02-01 08:00:07.140
8 1 DB424
69.00 17.00 52.99 52.59 2005-01-17 13:59:10.477
42 1 DB424
69.00 17.00 52.99 52.59 2005-01-18 08:00:11.637
76 1 DB424
69.00 17.00 52.99 52.59 2005-01-19 08:00:09.123
110 1 DB424
69.00 17.00 53.99 52.97 2005-01-20 08:00:09.873
144 1 DB424
69.00 17.00 53.99 52.97 2005-01-21 08:00:10.237
178 1 DB424
69.00 17.00 53.99 52.99 2005-01-22 08:00:11.680
212 1 DB424
69.00 18.00 57.99 57.71 2005-01-23 08:00:15.493
246 1 DB424
69.00 18.00 57.99 57.71 2005-01-24 08:00:10.137
280 1 DB424
69.00 18.00 57.99 57.71 2005-01-25 08:00:09.380
314 1 DB424
69.00 18.00 57.99 57.73 2005-01-27 08:00:10.640
348 1 DB424
69.00 18.00 57.99 57.75 2005-01-28 08:00:11.520
382 1 DB424
69.00 18.00 57.99 57.73 2005-01-29 08:00:14.120
417 1 DB424
69.00 18.00 62.99 62.65 2005-01-30 08:00:10.823
452 1 DB424
69.00 18.00 62.99 62.65 2005-01-31 08:00:09.457
487 1 DB424
69.00 18.00 62.99 62.66 2005-02-01 08:00:07.140
9 1 DB489
55.00 17.00 40.99 40.76 2005-01-17 13:59:10.477
43 1 DB489
55.00 17.00 40.99 40.76 2005-01-18 08:00:11.637
77 1 DB489
55.00 17.00 40.99 40.76 2005-01-19 08:00:09.123
111 1 DB489
55.00 17.00 41.99 41.16 2005-01-20 08:00:09.873
145 1 DB489
55.00 17.00 41.99 41.16 2005-01-21 08:00:10.237
179 1 DB489
55.00 17.00 41.99 41.18 2005-01-22 08:00:11.680
213 1 DB489
55.00 17.00 45.99 45.78 2005-01-23 08:00:15.493
247 1 DB489
55.00 17.00 45.99 45.78 2005-01-24 08:00:10.137
281 1 DB489
55.00 17.00 45.99 45.78 2005-01-25 08:00:09.380
315 1 DB489
55.00 17.00 45.99 45.80 2005-01-27 08:00:10.640
349 1 DB489
55.00 18.00 49.99 49.39 2005-01-28 08:00:11.520
383 1 DB489
55.00 18.00 49.99 49.39 2005-01-29 08:00:14.120
418 1 DB489
55.00 18.00 54.99 54.72 2005-01-30 08:00:10.823
453 1 DB489
55.00 18.00 54.99 54.72 2005-01-31 08:00:09.457
488 1 DB489
55.00 18.00 54.99 54.72 2005-02-01 08:00:07.140
384 1 DB530
17.00 12.00 .99 .34 2005-01-29 08:00:14.120
419 1 DB530
17.00 13.00 .99 .61 2005-01-30 08:00:10.823
454 1 DB530
17.00 13.00 .99 .61 2005-01-31 08:00:09.457
489 1 DB530
24.00 18.00 .99 .54 2005-02-01 08:00:07.140
10 1 DB533
500.00 451.00 24.88 10.98 2005-01-17 13:59:10.477
44 1 DB533
500.00 451.00 24.88 10.98 2005-01-18 08:00:11.637
78 1 DB533
500.00 452.00 24.88 3.13 2005-01-19 08:00:09.123
112 1 DB533
500.00 453.00 24.88 6.46 2005-01-20 08:00:09.873
146 1 DB533
500.00 454.00 24.88 10.04 2005-01-21 08:00:10.237
180 1 DB533
500.00 454.00 24.88 .58 2005-01-22 08:00:11.680
214 1 DB533
500.00 454.00 24.88 4.47 2005-01-23 08:00:15.493
248 1 DB533
500.00 454.00 24.88 4.74 2005-01-24 08:00:10.137
282 1 DB533
500.00 454.00 24.88 7.99 2005-01-25 08:00:09.380
316 1 DB533
500.00 456.00 24.88 15.13 2005-01-27 08:00:10.640
350 1 DB533
500.00 457.00 24.88 5.86 2005-01-28 08:00:11.520
385 1 DB533
500.00 457.00 24.88 9.01 2005-01-29 08:00:14.120
420 1 DB533
500.00 457.00 24.88 12.74 2005-01-30 08:00:10.823
455 1 DB533
500.00 457.00 24.88 13.14 2005-01-31 08:00:09.457
490 1 DB533
500.00 462.00 24.88 7.11 2005-02-01 08:00:07.140
11 1 DB562
95.00 78.00 .99 .51 2005-01-17 13:59:10.477
45 1 DB562
95.00 78.00 .99 .51 2005-01-18 08:00:11.637
79 1 DB562
95.00 78.00 .99 .59 2005-01-19 08:00:09.123
113 1 DB562
95.00 78.00 .99 .50 2005-01-20 08:00:09.873
147 1 DB562
95.00 79.00 .99 .61 2005-01-21 08:00:10.237
181 1 DB562
95.00 79.00 .99 .55 2005-01-22 08:00:11.680
215 1 DB562
95.00 79.00 .99 .53 2005-01-23 08:00:15.493
249 1 DB562
95.00 79.00 .99 .56 2005-01-24 08:00:10.137
283 1 DB562
95.00 79.00 .99 .51 2005-01-25 08:00:09.380
317 1 DB562
95.00 80.00 .99 .62 2005-01-27 08:00:10.640
351 1 DB562
95.00 80.00 .99 .58 2005-01-28 08:00:11.520
386 1 DB562
95.00 81.00 .99 .64 2005-01-29 08:00:14.120
421 1 DB562
95.00 81.00 .99 .54 2005-01-30 08:00:10.823
456 1 DB562
95.00 81.00 .99 .64 2005-01-31 08:00:09.457
491 1 DB562
95.00 84.00 .99 .51 2005-02-01 08:00:07.140
12 1 DB586
150.00 132.00 .99 .60 2005-01-17 13:59:10.477
46 1 DB586
150.00 132.00 .99 .60 2005-01-18 08:00:11.637
80 1 DB586
150.00 132.00 .99 .67 2005-01-19 08:00:09.123
114 1 DB586
150.00 132.00 .99 .55 2005-01-20 08:00:09.873
148 1 DB586
150.00 133.00 .99 .54 2005-01-21 08:00:10.237
182 1 DB586
150.00 133.00 .99 .59 2005-01-22 08:00:11.680
216 1 DB586
154.00 133.00 .99 .65 2005-01-23 08:00:15.493
250 1 DB586
154.00 133.00 .99 .53 2005-01-24 08:00:10.137
284 1 DB586
154.00 133.00 .99 .55 2005-01-25 08:00:09.380
318 1 DB586
154.00 134.00 .99 .56 2005-01-27 08:00:10.640
352 1 DB586
154.00 134.00 .99 .55 2005-01-28 08:00:11.520
387 1 DB586
154.00 135.00 .99 .56 2005-01-29 08:00:14.120
422 1 DB586
155.00 135.00 .99 .61 2005-01-30 08:00:10.823
457 1 DB586
155.00 135.00 .99 .58 2005-01-31 08:00:09.457
492 1 DB586
155.00 135.00 .99 .66 2005-02-01 08:00:07.140
13 1 DB587
229.00 197.00 .99 .56 2005-01-17 13:59:10.477
47 1 DB587
229.00 197.00 .99 .56 2005-01-18 08:00:11.637
81 1 DB587
229.00 198.00 .99 .69 2005-01-19 08:00:09.123
115 1 DB587
229.00 199.00 .99 .70 2005-01-20 08:00:09.873
149 1 DB587
229.00 200.00 .99 .57 2005-01-21 08:00:10.237
183 1 DB587
229.00 200.00 .99 .59 2005-01-22 08:00:11.680
217 1 DB587
229.00 200.00 .99 .59 2005-01-23 08:00:15.493
251 1 DB587
229.00 200.00 .99 .70 2005-01-24 08:00:10.137
285 1 DB587
229.00 201.00 .99 .67 2005-01-25 08:00:09.380
319 1 DB587
229.00 203.00 .99 .64 2005-01-27 08:00:10.640
353 1 DB587
229.00 203.00 .99 .69 2005-01-28 08:00:11.520
388 1 DB587
229.00 203.00 .99 .66 2005-01-29 08:00:14.120
423 1 DB587
229.00 203.00 .99 .58 2005-01-30 08:00:10.823
458 1 DB587
229.00 203.00 .99 .58 2005-01-31 08:00:09.457
493 1 DB587
229.00 207.00 .99 .64 2005-02-01 08:00:07.140
14 1 DB611
841.00 724.00 5.99 .47 2005-01-17 13:59:10.477
48 1 DB611
841.00 724.00 5.99 .48 2005-01-18 08:00:11.637
82 1 DB611
841.00 725.00 .99 .56 2005-01-19 08:00:09.123
116 1 DB611
841.00 726.00 .99 .56 2005-01-20 08:00:09.873
150 1 DB611
841.00 726.00 .99 .62 2005-01-21 08:00:10.237
184 1 DB611
841.00 726.00 .99 .69 2005-01-22 08:00:11.680
218 1 DB611
841.00 726.00 10.99 1.37 2005-01-23 08:00:15.493
252 1 DB611
841.00 726.00 5.99 .68 2005-01-24 08:00:10.137
286 1 DB611
841.00 727.00 5.99 .68 2005-01-25 08:00:09.380
320 1 DB611
841.00 728.00 .99 .52 2005-01-27 08:00:10.640
354 1 DB611
841.00 729.00 .99 .64 2005-01-28 08:00:11.520
389 1 DB611
841.00 729.00 .99 .56 2005-01-29 08:00:14.120
424 1 DB611
841.00 729.00 5.99 .47 2005-01-30 08:00:10.823
459 1 DB611
841.00 729.00 5.99 .47 2005-01-31 08:00:09.457
494 1 DB611
841.00 743.00 .99 .61 2005-02-01 08:00:07.140
15 1 DB634
47000.00 46820.00 13.49 .40 2005-01-17 13:59:10.477
49 1 DB634
47000.00 46820.00 .99 .34 2005-01-18 08:00:11.637
83 1 DB634
47000.00 46820.00 .99 .51 2005-01-19 08:00:09.123
117 1 DB634
47000.00 46821.00 .99 .52 2005-01-20 08:00:09.873
151 1 DB634
47000.00 46821.00 .99 .54 2005-01-21 08:00:10.237
185 1 DB634
47000.00 46821.00 .99 .51 2005-01-22 08:00:11.680
219 1 DB634
47000.00 46821.00 50.99 6.71 2005-01-23 08:00:15.493
253 1 DB634
47000.00 46821.00 13.49 .53 2005-01-24 08:00:10.137
287 1 DB634
47000.00 46821.00 .99 .56 2005-01-25 08:00:09.380
321 1 DB634
47000.00 46823.00 .99 .58 2005-01-27 08:00:10.640
355 1 DB634
47000.00 46824.00 .99 .51 2005-01-28 08:00:11.520
390 1 DB634
47000.00 46826.00 .99 .54 2005-01-29 08:00:14.120
425 1 DB634
47000.00 46823.00 50.99 6.18 2005-01-30 08:00:10.823
460 1 DB634
47000.00 46823.00 25.99 .47 2005-01-31 08:00:09.457
495 1 DB634
47000.00 46895.00 13.49 3.34 2005-02-01 08:00:07.140
16 1 DB683
1385.00 1220.00 3.49 .59 2005-01-17 13:59:10.477
50 1 DB683
1385.00 1221.00 3.49 .66 2005-01-18 08:00:11.637
84 1 DB683
1385.00 1222.00 3.49 1.95 2005-01-19 08:00:09.123
118 1 DB683
1385.00 1224.00 3.49 2.87 2005-01-20 08:00:09.873
152 1 DB683
1385.00 1225.00 3.49 .45 2005-01-21 08:00:10.237
186 1 DB683
1385.00 1231.00 3.49 1.78 2005-01-22 08:00:11.680
220 1 DB683
1385.00 1230.00 5.99 .52 2005-01-23 08:00:15.493
254 1 DB683
1385.00 1230.00 5.99 1.57 2005-01-24 08:00:10.137
288 1 DB683
1385.00 1231.00 3.49 .62 2005-01-25 08:00:09.380
322 1 DB683
1385.00 1235.00 3.49 .58 2005-01-27 08:00:10.640
356 1 DB683
1385.00 1237.00 3.49 2.03 2005-01-28 08:00:11.520
391 1 DB683
1385.00 1239.00 3.49 1.50 2005-01-29 08:00:14.120
426 1 DB683
1435.00 1238.00 13.49 1.34 2005-01-30 08:00:10.823
461 1 DB683
1435.00 1238.00 5.99 .48 2005-01-31 08:00:09.457
496 1 DB683
1435.00 1247.00 3.49 .61 2005-02-01 08:00:07.140
17 1 DB770
13000.00 12845.00 5.99 .47 2005-01-17 13:59:10.477
51 1 DB770
13000.00 12845.00 .99 .34 2005-01-18 08:00:11.637
85 1 DB770
13000.00 12845.00 .99 .35 2005-01-19 08:00:09.123
119 1 DB770
13000.00 12845.00 .99 .35 2005-01-20 08:00:09.873
153 1 DB770
13000.00 12845.00 .99 .35 2005-01-21 08:00:10.237
187 1 DB770
13000.00 12845.00 .99 .35 2005-01-22 08:00:11.680
221 1 DB770
13000.00 12845.00 10.99 .88 2005-01-23 08:00:15.493
255 1 DB770
13000.00 12845.00 5.99 .51 2005-01-24 08:00:10.137
289 1 DB770
13000.00 12845.00 .99 .34 2005-01-25 08:00:09.380
323 1 DB770
13000.00 12845.00 .99 .34 2005-01-27 08:00:10.640
357 1 DB770
13000.00 12845.00 .99 .49 2005-01-28 08:00:11.520
392 1 DB770
13000.00 12845.00 .99 .49 2005-01-29 08:00:14.120
427 1 DB770
13000.00 12845.00 5.99 .47 2005-01-30 08:00:10.823
462 1 DB770
13000.00 12845.00 5.99 .47 2005-01-31 08:00:09.457
497 1 DB770
13000.00 12845.00 .99 .34 2005-02-01 08:00:07.140
18 1 DB776
1425.00 1274.00 .99 .41 2005-01-17 13:59:10.477
52 1 DB776
1425.00 1274.00 .99 .64 2005-01-18 08:00:11.637
86 1 DB776
1425.00 1276.00 .99 .51 2005-01-19 08:00:09.123
120 1 DB776
1425.00 1278.00 .99 .53 2005-01-20 08:00:09.873
154 1 DB776
1425.00 1279.00 .99 .53 2005-01-21 08:00:10.237
188 1 DB776
1425.00 1282.00 .99 .55 2005-01-22 08:00:11.680
222 1 DB776
1425.00 1280.00 5.99 .51 2005-01-23 08:00:15.493
256 1 DB776
1425.00 1280.00 .99 .35 2005-01-24 08:00:10.137
290 1 DB776
1425.00 1282.00 .99 .68 2005-01-25 08:00:09.380
324 1 DB776
1425.00 1292.00 .99 .55 2005-01-27 08:00:10.640
358 1 DB776
1425.00 1300.00 .99 .54 2005-01-28 08:00:11.520
393 1 DB776
1425.00 1303.00 .99 .56 2005-01-29 08:00:14.120
428 1 DB776
1475.00 1293.00 5.99 .47 2005-01-30 08:00:10.823
463 1 DB776
1475.00 1293.00 5.99 .65 2005-01-31 08:00:09.457
498 1 DB776
1475.00 1310.00 3.49 .66 2005-02-01 08:00:07.140
19 1 DB778
1051.00 926.00 1.48 .63 2005-01-17 13:59:10.477
53 1 DB778
1051.00 926.00 .99 .42 2005-01-18 08:00:11.637
87 1 DB778
1051.00 929.00 .99 .54 2005-01-19 08:00:09.123
121 1 DB778
1051.00 932.00 .99 .66 2005-01-20 08:00:09.873
155 1 DB778
1051.00 936.00 .99 .54 2005-01-21 08:00:10.237
189 1 DB778
1051.00 940.00 .99 .66 2005-01-22 08:00:11.680
223 1 DB778
1051.00 937.00 2.99 .88 2005-01-23 08:00:15.493
257 1 DB778
1051.00 938.00 1.48 .55 2005-01-24 08:00:10.137
291 1 DB778
1051.00 947.00 .99 .60 2005-01-25 08:00:09.380
325 1 DB778
1051.00 965.00 .99 .56 2005-01-27 08:00:10.640
359 1 DB778
1051.00 994.00 .99 .69 2005-01-28 08:00:11.520
394 1 DB778
1051.00 1011.00 .99 .61 2005-01-29 08:00:14.120
429 1 DB778
1101.00 974.00 2.99 1.03 2005-01-30 08:00:10.823
464 1 DB778
1101.00 982.00 1.48 .50 2005-01-31 08:00:09.457
499 1 DB778
1101.00 1053.00 1.23 .62 2005-02-01 08:00:07.140
20 1 DB779
4366.00 4111.00 .99 .38 2005-01-17 13:59:10.477
54 1 DB779
4366.00 4111.00 .99 .38 2005-01-18 08:00:11.637
88 1 DB779
4366.00 4113.00 .99 .53 2005-01-19 08:00:09.123
122 1 DB779
4366.00 4114.00 .99 .55 2005-01-20 08:00:09.873
156 1 DB779
4366.00 4117.00 .99 .60 2005-01-21 08:00:10.237
190 1 DB779
4366.00 4118.00 .99 .60 2005-01-22 08:00:11.680
224 1 DB779
4366.00 4117.00 6.99 1.99 2005-01-23 08:00:15.493
258 1 DB779
4366.00 4117.00 2.99 .87 2005-01-24 08:00:10.137
292 1 DB779
4366.00 4118.00 1.99 .76 2005-01-25 08:00:09.380
326 1 DB779
4366.00 4136.00 .99 .53 2005-01-27 08:00:10.640
360 1 DB779
4366.00 4147.00 .99 .67 2005-01-28 08:00:11.520
395 1 DB779
4366.00 4170.00 .99 .56 2005-01-29 08:00:14.120
430 1 DB779
4416.00 4140.00 7.99 2.29 2005-01-30 08:00:10.823
465 1 DB779
4416.00 4140.00 .99 .34 2005-01-31 08:00:09.457
500 1 DB779
5916.00 5883.00 .99 .58 2005-02-01 08:00:07.140
21 1 DB780
744.00 631.00 5.99 .47 2005-01-17 13:59:10.477
55 1 DB780
744.00 631.00 .99 .34 2005-01-18 08:00:11.637
89 1 DB780
744.00 632.00 .99 .59 2005-01-19 08:00:09.123
123 1 DB780
744.00 633.00 .99 .56 2005-01-20 08:00:09.873
157 1 DB780
744.00 634.00 .99 .67 2005-01-21 08:00:10.237
191 1 DB780
744.00 634.00 .99 .55 2005-01-22 08:00:11.680
225 1 DB780
744.00 635.00 5.99 .47 2005-01-23 08:00:15.493
259 1 DB780
744.00 635.00 5.99 .63 2005-01-24 08:00:10.137
293 1 DB780
744.00 635.00 5.99 .71 2005-01-25 08:00:09.380
327 1 DB780
744.00 637.00 5.99 .77 2005-01-27 08:00:10.640
361 1 DB780
744.00 637.00 5.99 2.90 2005-01-28 08:00:11.520
396 1 DB780
744.00 638.00 5.99 1.23 2005-01-29 08:00:14.120
431 1 DB780
744.00 638.00 5.99 1.90 2005-01-30 08:00:10.823
466 1 DB780
744.00 638.00 5.99 .47 2005-01-31 08:00:09.457
501 1 DB780
744.00 642.00 3.49 2.81 2005-02-01 08:00:07.140
22 1 DB781
1190.00 996.00 5.99 .53 2005-01-17 13:59:10.477
56 1 DB781
1190.00 996.00 .99 .40 2005-01-18 08:00:11.637
90 1 DB781
1190.00 997.00 .99 .57 2005-01-19 08:00:09.123
124 1 DB781
1190.00 998.00 .99 .55 2005-01-20 08:00:09.873
158 1 DB781
1190.00 999.00 .99 .64 2005-01-21 08:00:10.237
192 1 DB781
1190.00 1001.00 .99 .53 2005-01-22 08:00:11.680
226 1 DB781
1190.00 1000.00 5.99 .47 2005-01-23 08:00:15.493
260 1 DB781
1190.00 1001.00 5.99 .57 2005-01-24 08:00:10.137
294 1 DB781
1190.00 1002.00 5.99 1.15 2005-01-25 08:00:09.380
328 1 DB781
1190.00 1004.00 5.99 1.82 2005-01-27 08:00:10.640
362 1 DB781
1190.00 1006.00 5.99 .70 2005-01-28 08:00:11.520
397 1 DB781
1190.00 1008.00 5.99 2.00 2005-01-29 08:00:14.120
432 1 DB781
1190.00 1007.00 5.99 .48 2005-01-30 08:00:10.823
467 1 DB781
1190.00 1007.00 .99 .35 2005-01-31 08:00:09.457
502 1 DB781
1190.00 1011.00 .99 .61 2005-02-01 08:00:07.140
23 1 DB784
851.00 724.00 5.99 .47 2005-01-17 13:59:10.477
57 1 DB784
851.00 724.00 .99 .34 2005-01-18 08:00:11.637
91 1 DB784
851.00 725.00 .99 .56 2005-01-19 08:00:09.123
125 1 DB784
851.00 726.00 .99 .52 2005-01-20 08:00:09.873
159 1 DB784
851.00 726.00 .99 .59 2005-01-21 08:00:10.237
193 1 DB784
851.00 727.00 .99 .52 2005-01-22 08:00:11.680
227 1 DB784
851.00 727.00 5.99 .47 2005-01-23 08:00:15.493
261 1 DB784
851.00 727.00 5.99 .63 2005-01-24 08:00:10.137
295 1 DB784
851.00 727.00 5.99 .82 2005-01-25 08:00:09.380
329 1 DB784
851.00 729.00 5.99 .55 2005-01-27 08:00:10.640
363 1 DB784
851.00 729.00 5.99 2.63 2005-01-28 08:00:11.520
398 1 DB784
851.00 730.00 5.99 2.81 2005-01-29 08:00:14.120
433 1 DB784
851.00 730.00 5.99 1.98 2005-01-30 08:00:10.823
468 1 DB784
851.00 730.00 5.99 .47 2005-01-31 08:00:09.457
503 1 DB784
851.00 738.00 3.49 2.08 2005-02-01 08:00:07.140
24 1 DB785
591.00 495.00 .99 .34 2005-01-17 13:59:10.477
58 1 DB785
591.00 495.00 .99 .34 2005-01-18 08:00:11.637
92 1 DB785
591.00 495.00 .99 .52 2005-01-19 08:00:09.123
126 1 DB785
591.00 496.00 .99 .56 2005-01-20 08:00:09.873
160 1 DB785
591.00 497.00 .99 .66 2005-01-21 08:00:10.237
194 1 DB785
591.00 497.00 .99 .55 2005-01-22 08:00:11.680
228 1 DB785
591.00 497.00 5.99 .47 2005-01-23 08:00:15.493
262 1 DB785
591.00 497.00 5.99 .65 2005-01-24 08:00:10.137
296 1 DB785
591.00 498.00 5.99 .60 2005-01-25 08:00:09.380
330 1 DB785
591.00 500.00 5.99 .78 2005-01-27 08:00:10.640
364 1 DB785
591.00 500.00 5.99 2.87 2005-01-28 08:00:11.520
399 1 DB785
591.00 501.00 5.99 .78 2005-01-29 08:00:14.120
434 1 DB785
591.00 501.00 5.99 1.45 2005-01-30 08:00:10.823
469 1 DB785
591.00 501.00 5.99 .47 2005-01-31 08:00:09.457
504 1 DB785
591.00 502.00 3.49 .60 2005-02-01 08:00:07.140
25 1 DB820
133.00 118.00 .99 .55 2005-01-17 13:59:10.477
59 1 DB820
133.00 118.00 .99 .67 2005-01-18 08:00:11.637
93 1 DB820
133.00 119.00 .99 .57 2005-01-19 08:00:09.123
127 1 DB820
133.00 119.00 .99 .56 2005-01-20 08:00:09.873
161 1 DB820
133.00 121.00 .99 .66 2005-01-21 08:00:10.237
195 1 DB820
133.00 121.00 .99 .54 2005-01-22 08:00:11.680
229 1 DB820
136.00 121.00 .99 .67 2005-01-23 08:00:15.493
263 1 DB820
136.00 121.00 .99 .59 2005-01-24 08:00:10.137
297 1 DB820
136.00 122.00 .99 .59 2005-01-25 08:00:09.380
331 1 DB820
136.00 124.00 .99 .52 2005-01-27 08:00:10.640
365 1 DB820
136.00 125.00 .99 .54 2005-01-28 08:00:11.520
400 1 DB820
136.00 126.00 .99 .60 2005-01-29 08:00:14.120
435 1 DB820
142.00 125.00 .99 .63 2005-01-30 08:00:10.823
470 1 DB820
142.00 125.00 .99 .68 2005-01-31 08:00:09.457
505 1 DB820
142.00 127.00 .99 .51 2005-02-01 08:00:07.140
26 1 DB859
92288.00 92048.00 13.49 .51 2005-01-17 13:59:10.477
60 1 DB859
92288.00 92048.00 .99 .51 2005-01-18 08:00:11.637
94 1 DB859
92288.00 92048.00 .99 .57 2005-01-19 08:00:09.123
128 1 DB859
92288.00 92050.00 .99 .52 2005-01-20 08:00:09.873
162 1 DB859
92288.00 92052.00 .99 .58 2005-01-21 08:00:10.237
196 1 DB859
92288.00 92054.00 .99 .70 2005-01-22 08:00:11.680
230 1 DB859
92288.00 92053.00 50.99 8.85 2005-01-23 08:00:15.493
264 1 DB859
92288.00 92054.00 13.49 .52 2005-01-24 08:00:10.137
298 1 DB859
92288.00 92055.00 13.49 5.08 2005-01-25 08:00:09.380
332 1 DB859
92288.00 92104.00 13.49 5.50 2005-01-27 08:00:10.640
366 1 DB859
92388.00 92362.00 13.49 1.32 2005-01-28 08:00:11.520
401 1 DB859
93288.00 93241.00 13.49 .93 2005-01-29 08:00:14.120
436 1 DB859
93488.00 93231.00 13.49 9.25 2005-01-30 08:00:10.823
471 1 DB859
93488.00 93242.00 13.49 .54 2005-01-31 08:00:09.457
506 1 DB859
95788.00 95757.00 13.49 8.86 2005-02-01 08:00:07.140
27 1 DB872
63891.00 63624.00 5.99 .63 2005-01-17 13:59:10.477
61 1 DB872
63891.00 63624.00 .99 .50 2005-01-18 08:00:11.637
95 1 DB872
63891.00 63624.00 .99 .55 2005-01-19 08:00:09.123
129 1 DB872
63891.00 63626.00 .99 .61 2005-01-20 08:00:09.873
163 1 DB872
63891.00 63626.00 .99 .56 2005-01-21 08:00:10.237
197 1 DB872
63891.00 63627.00 .99 .68 2005-01-22 08:00:11.680
231 1 DB872
63891.00 63627.00 10.99 1.65 2005-01-23 08:00:15.493
265 1 DB872
63891.00 63627.00 5.99 .66 2005-01-24 08:00:10.137
299 1 DB872
63891.00 63627.00 .99 .60 2005-01-25 08:00:09.380
333 1 DB872
63891.00 63677.00 .99 .62 2005-01-27 08:00:10.640
367 1 DB872
63941.00 63925.00 .99 .63 2005-01-28 08:00:11.520
402 1 DB872
64391.00 64369.00 .99 .53 2005-01-29 08:00:14.120
437 1 DB872
64641.00 64364.00 10.99 1.76 2005-01-30 08:00:10.823
472 1 DB872
64641.00 64364.00 8.49 .55 2005-01-31 08:00:09.457
507 1 DB872
64641.00 64500.00 .99 .53 2005-02-01 08:00:07.140

If I were in your shoes, the first thing I'd do is see if a PivotTable
(and Chart) do the job. Start with Data | PivotTable and PivotChart
Report...

One of the options you will see is to use an external database. Follow
the various dialog boxes and XL should do all the necessary
SQL/whatever work is needed to get you the data.

If that is not good enough, consider using Data | Import External Data
> and then either Import Data... or New Database query... This will
give you the data from your database in a XL worksheet. You can then
analyze it in various ways.


--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <#[email protected]>, [email protected]
says...
> Hello, all -- I have a job that grabs the size of each SQL Server database
> and log file size and saves one row per database into a table. I run this
> routine on a daily basis, so I basically grab the size each day and can
> monitor growth.
>
> The table data is below.
>
> What I would like to do is have a SQL Query setup to graph the data in Excel
> to show the growth rate of each database by week, month, year.
>
> I'm not sure the best way to do the SQL and the best way to do the graph.
> Since new databases are created all the time, new rows will appear in the
> output -- so creating specific graphs for each database may not be ideal...
> so I'm hoping someone could help me.
>
> Essentially, I want a graph of:
>
> By Week -All Databases (DB274, DB332, DB344, etc) showing the start size and
> the end size within a specified period.
> By Month - All Databases (DB274, DB332, DB344, etc) showing the start size
> and the end size within a specified period.
> By Year - All Databases (DB274, DB332, DB344, etc) showing the start size
> and the end size within a specified period.
>
> I woudl then like to graph each database individually showing its individual
> growt as:
> By Week - DB274
> By Month - DB274
> By Year - DB274
>
> Then again another by Week, Month, Year for each remaining database.
>
> I figure I'll need a separate query for the Week, Month, Year for all
> databases. Then separate queries for the Week, Month, Year for each
> individual database.
>
> How to have this in Excel for graphing is another big question for me.
> Obviously, as new databases come on... I do not want to have to remember and
> add/create a new graph. (If this is required, fine... I'm just trying to
> find a dynamic solution here.)
>
> Here is all my data that I've been collecting each data starting 12/17/04
> thru 02/01/05.
>
> Any help or pointers would be appreciated greatly.
>
> ID RECORD_TYPE DBNAME
> DATA_SIZE DATA_USED LOG_SIZE LOG_USED STAT_DATE
> ----------- ----------- -------------------------------------------------- -----------
> ----------- ----------- ----------- ------------------------------------------------------
> 2 1 DB274
> 15670.00 15517.00 3.49 .40 2005-01-17 13:59:10.477
> 36 1 DB274
> 15670.00 15518.00 .99 .62 2005-01-18 08:00:11.637
> 70 1 DB274
{snip}