I have a table contains data for different nodes (~100). Each node contains records anywhere from a few thausands to a million. Each node program is interested in its own data only. Even though I have a combo clustered index on this table, is it a good idea to split this table into pieces, each piece will contain data for only one node, each piece (table) will be created on the fly by the program? Thanks!