Tag Info

New answers tagged

2

There's really no one 'best way' to store time series data, and it honestly depends on a number of factors. However, I'm going to focus on two factors primarily, with them being: (1) How serious is this project that it deserves your effort to optimize the schema? (2) What are your query access patterns really going to be like? With those questions in ...


1

In general multiple instances do not increase security, only complexity. There are reasons to use multiple instances but I don't think they fit your situation. You have different groups of users that need administrative (sysadmin, securityadmin etc) access. One of your databases needs to be on a different side of the firewall than the rest. I'm honestly ...



Top 50 recent answers are included