All geek questions in one place

SQL Server needs to share data, but only have a standard version

Is there a way that I can distribute data for a table in several filegroups in code (Sproc, etc.) without actually having SQL Server partitions (standard version only)? I wanted to be able to punch FileStream data into different “sections”, but without an Enterprise license I cannot use the markup functionality.

Any suggestions are welcome.

Thanks,

S

+4
source share
1 answer

You can distribute your data in different databases and combine them with views. The hard part of this will be to update the views when adding / removing data.

You need to make this "section" on a logical key (for example, in a calendar date), where each database has data in a certain range. If you cluster in this field, the query analyzer will be able to determine which database to output data without problems.

At my workplace, we use this method for a very large (multi-billion dollar) data set, with which we receive monthly additions, and it works great.

+10
source

Source: https://habr.com/ru/post/1333728/

More articles:


All Articles