Home Forums SQL Server 2016 SQL Server 2016 - Development and T-SQL Multiple Filegroups vs. Multiple Databases for better Performance RE: Multiple Filegroups vs. Multiple Databases for better Performance
amns
SSCrazy
Points: 2628
More actions
February 11, 2019 at 4:46 pm
#2021735
I see. Would be a reasonable idea to replicate these tables with static data also in the new DB, so the distributed transaction does not need to exist, and this new database would work almost completely separated?
Thanks, best regards!