March 22, 2010 at 5:06 am
Hi All,
I have 28+ million table with 30 columns. Now we want to split into
multiple tables.
It having the information
like name info, address info , company info, employees, sales, webaddress..
This having Rowid as identity data type and
email having primary key.
daily we want all these columns data.
Please suggest us the better way to split the table.
B'coz it hurts the performance of querying process.
March 22, 2010 at 6:30 am
Please don't cross-post. This just leads to confusion and bad information.
Do not reply.
Discussion already started here: http://www.sqlservercentral.com/Forums/Topic887267-373-1.aspx
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply