In Cassandra, you can have a partition key to align partitions to particular server nodes.
My understanding is that you can distribute transactional responsibility horizontally in SQL Server 2016 (across horizontal servers) but you always come back to a 'node of truth for the database'.
I'm not sure if you can break that transactional responsibility down to the table or partition level.
For example - suppose I have asset information - I expect to have 1000 million rows in three years. I expect that my server load will increase due to usage, to the point where I'll have to scale my servers (web and database) horizontally.
I want to be able to do reads and writes across three database servers. On the first server I'll partition my assets so that the assets A-I can read and write, on the second I'll have J-R, and the third S-Z.
My question is: Is it possible to have a partition to distribute transaction load horizontally in SQL Server 2016?