[dba-SQLServer] SQL Server: An interesting data load article

I found the concept of loading a temp table and then using that table as a partition of the final 
table to be pretty darned cool.

And of course, as for the server...

I WANT ONE!

;)

John W. Colby
www.ColbyConsulting.com


Mike Mattys wrote:
> Cool. This is an important niche.
> 
> I am pondering the levels where the setup requires the
> hash table for evenly distibuting threads I just read about
> vs partitioning plus NUMA.
> 
> -
> Michael R Mattys
> MapPoint and Database Dev
> www.mattysconsulting.com
> -
> ----- Original Message ----- 
> From: "jwcolby" <jwcolby at colbyconsulting.com>
> To: "Access Developers discussion and problem solving" 
> <accessd at databaseadvisors.com>; "VBA" <dba-vb at databaseadvisors.com>; 
> "Dba-Sqlserver" <dba-sqlserver at databaseadvisors.com>
> Sent: Tuesday, January 19, 2010 9:05 AM
> Subject: [dba-SQLServer] SQL Server: An interesting data load article
> 
> 
>> http://msdn.microsoft.com/en-us/library/dd537533.aspx
>>
>> -- 
>> John W. Colby
>> www.ColbyConsulting.com
>> _______________________________________________
>> dba-SQLServer mailing list
>> dba-SQLServer at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>> http://www.databaseadvisors.com
>>
>>
> 
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
> 
>