for reporting purpose , in sql server, which scenario is better?
one server that has many records for different categories, with one column making the difference.. (indicator telling what category of row of record it is)
creating a separate table for each category..
for example, the column that makes the difference could have data like
'car','bus','bike','suv','trailer'.. 15 more such entries.. they are all char type.
the table will result in millions of records regardless..
will one big table with proper index be the way to go? or is partitioning more beneficial for SELECT report queries?