[dba-SQLServer] Just an FYI

8-(

This database is largish and I have to do a LOT of counts of people, almost
always using many different fields.  These things can take 30 minutes or
more EACH and I currently have a request for individual counts each count
using a different field, about 20 of these counts.  I simply have to find a
better way.


John W. Colby
Colby Consulting
www.ColbyConsulting.com 
-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Susan
Harkins
Sent: Saturday, December 08, 2007 4:30 PM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [dba-SQLServer] Just an FYI

You are giving me a headache. ;)

Susan H.


>I am up to field 63 and now have 954 million data points, in 20 gig of 
>data  space.  BTW I broke this destination (vertical) table out into 
>its own db  but on the same drive (raid) as the source (wide) table.  I 
>doubt that is  the reason, however I am only averaging about 200 
>seconds per field at  this  point and the insert time isn't climbing as 
>I had expected.
>
> I have to wonder what the effect would be of running Windows 2003 x64 
> with SQL Server x64 and 8 gigs of ram (the max I can put in the 
> machine) instead of 4 gigs (the max that Windows 2003 x32 can handle).  
> I tried BTW to do the install, but it failed and I didn't have time to 
> pursue it.

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com