[dba-SQLServer] Just an FYI

jwcolby jwcolby at colbyconsulting.com
Sat Dec 8 19:58:30 CST 2007


LOL, you BETTER think it will work, you were the one harping at me for the
last year to do this!  ;-)

The first table contains fields 001-083.  It contains 1.07 Gig data points
and uses 23.624 gig data space.
The next table will contain fields 084-142.  It is almost finished now.
The next table will contain fields 144-233.  It will run overnight.  
I will also start indexing tbl_084_143 overnight as I need to do counts on
that table tomorrow. 

All of these tables are in a single database file.  Do I need to be
concerned about fragmentation if I start the indexing while the next table
is building?

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 Arthur
Fuller
Sent: Saturday, December 08, 2007 7:41 PM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [dba-SQLServer] Just an FYI

I think it will work too.

On 12/8/07, jwcolby <jwcolby at colbyconsulting.com> wrote:
>
> And I am not expecting one, from you or anyone else on this list.  I 
> think that Arthur has presented a possible solution.  I think I am 
> going to break this down into 6 or so different result tables, each 
> with data from a consecutive range of fields across the big (wide) 
> table.  I need to build a little "query generator" anyway to write 
> queries for me, and if I add a field to my field lookup table to hold 
> which vertical table the field is held in, then the query generator 
> can write the query to pull data from the correct table.  That has 
> some advantages and few disadvantages.  The storage tables hold fewer 
> data elements so the scan for any given field is automatically faster.  
> It turns out that the data is grouped such that my client asks for 
> fields "close to each other", i.e. they tend to come from the same 
> survey.
>
> Thinking about it in that manner I think I can get this thing pretty fast.
> Essentially the wide table gets riced and diced and "partitioned"
> vertically, each vertical partition being N fields wide, but with the 
> advantage that the resulting "vertical" tables hold only the records 
> that actually contain data elements.
>
> I am running a program I wrote that builds up this vertical table.  I 
> just told it to stop at field 83 which is the end of a logical group.  
> That will be the end of one table.  The next table will start at field 
> 84 and go to...
> not sure yet but the same idea.  I think this will work...
>
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com




More information about the dba-SQLServer mailing list