Ok, so we log our time series process data to an existing SQL database managed by our IT department. We have transaction groups logging to individual tables for each process, 25-75 tags per process, currently at 10 tables all 1s interval logging. We initially set up this way because it was easy to track tags for each piece of equipment separately but I was speaking with our IT department and they said it would be easier for them to use the data from their side if we aggregated all the time series data logs to a single table.
I know we could build a cross reference to the existing tables the way they are set up currently but it made me wonder if there was a benefit for either scenario other than preference or ease of writing queries? 1 large table vs many small tables? (Also newbie to SQL here)